QUERY: SELECT
p.products_id,
p.products_model,
p.label_ids,
p.main_category,
p.products_ean,
p.products_fsk18,
p.products_quantity,
p.products_quantity_min,
p.products_quantity_step,
p.products_price,
p.products_price_small_opt,
p.products_price_opt,
p.products_purchase_price,
p.small_opt_purchase_price,
p.count_small_opt_purchase_price,
p.count_opt_purchase_price,
p.opt_purchase_price,
p.postavshik,
p.suplier_catalog_id,
p.postavshik_comment,
p.name_catalog_id,
p.products_tax_class_id,
p.products_image,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_currency,
p.products_page_url,
p.video,
p.show_video,
pd.products_short_description,
p.rev_total,
p.rev_rating,
pd.products_name,
p.products_ordered,
pd.products_short_description,
s.status,
IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
m.manufacturers_name,
m.manufacturers_id FROM products AS p
LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id)
LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN specials AS s on p.products_id = s.products_id
LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id)
LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '1' AND p.products_id IN(7201618,7067857,10103539,7075898,7075899,7201730,10843290,10843325,10843328,10843332,10843339,10843343,4970487,4970488,4970489,4970490,4970491,4970492,4970493,4970494,4970495,4970496,4970497,4970498,4970499,4970500,4970501,4970502,4970503,7076167,4970504,4970505,4970506,4970507,4970508,4970509,4970510,4970511,4970512,4970513,4970514,4970515,4970516,4970517,4970518,4970519,4970520,4970521,7068193,7068231,10943750,7076243,10843549,10943787,10843578,7068302,8618691,4970672,4970738,8618831,8836474,8618863,7068507,7068508,4970852,7068536,10104221,4970904,8836573,4970912,10843863,10944100,10843898,10843906,10843973,10944222,10944223,10944224,10944225,10944226,10944227,10944228,10944229,10944230,7202520,10944300,7202572,10104465,10844147,7073867,7065883,10844187,10933378,10933379,7065968,8836998,10199384,10199385,7066166,7066167,7066168,8837248,3227275,7066441,3227420,7066510,10844934,10844935,10844936,7066663,7066668,3227619,10845016,10845017,7066751,3227696,7066817,7066820,10223064,7066837,7066840,7066845,7066851,7066904,7066957,7074961,7067060,10842359,7075083,7067103,8835111,10197350,7067129,7067150,7067157,7075175,10842471,8835233,7067246,7067247,7067294,10842612,8835334,8835340,7067350,7067364,7075372,10103030,10842714,10842726,7067481,7075488,7075518,7067533,8835582,7067582,10842879,10842881,10842883,7067688,7075759,10843041,7075761,7075815,10931258,8615194,10931310,10247114,7071904,7071935,7071936,7071937,7071940,7071943,7071944,7071946,7071947,7071996,10840282,10840283,7072025,7064026,10840366,10840434,10840439,7064180,7064197,7072234,10931691,10234513,10234514,7072325,10221590,10840664,10840665,10840685,8564652,8564653,8564654,8564655,7072433,7064460,7064466,8564707,10840779,8615876,8564751,8564756,8564757,7072535,7072538,10195792,10195793,10195794,10195795,10195796,10195797,10195798,10195799,10195800,10195801,10195802,10195803,10195804,10195805,10195806,10195807,10195808,10195809,10195810,10195811,7072592,7072596,7072600,10840895,7072626,7072643,7072655,7072661,8564908,8564909,7072728,7072730,7064733,7064749,7072750,7072759,8616127,10841066,10841067,7064787,7064792,8565017,7072819,7064828,10101487,7072839,8616214,7072870,7064887,7072910,7072916,7072944,7072952,8616328,7064973,7072985,10196329,7065092,7073108,10841421,10841521,7073280,8834285,10248609,8834382,8616755,7073400,7073402,7073483,10841765,7073526,7073541,7073553,7065558,4967931,4967932,4967933,4967934,4967935,4967936,4967937,4967938,4967939,8834608,7065610,7065614,7065663,8834673,7065681,7065691,8834701,10102357,7073719,7073730,7065759,7073789,7065813,7070873,7070892,7070908,7070937,10839292,7071042,7197841,10839390,10839474,10839482,10839487,10839496,8614616,7071258,10839561,7071282,7071284,10839569,10839570,7071321,7071323,7071324,7071326,10839609,7071331,7071363,7071372,7071373,7071382,7071394,7071405,7071420,8615026,10839961,10195003,8563990,8563997,7071795,10840086,8615170,10218060,7068868,7068869,7068870,7068873,7068885,7068886,7068923,8541991,8541996,10837238,7068960,8542009,8542010,8542023,8542054,8542056,10944534,8542123,7069095,10257335,10257336,10944640,7069172,8542226,10837521,10837522,8542349,8542354,8542356,10837663,7069404,7196191,7196192,7196193,10945010,10945032,10945051,8612918,7069563,10945081,7196369,7196370,7196371,7196376,7069629,7196427,7196429,7196430,7069696,7069747,10838214,10838218,8613320,8613359,10838276,10838360,10838366,7070113,8613517,7196950,7196958,7196971,7197042,7197047,7197050,7070281,7197078,7197081,8613732,7070404,8613792,8613793,7070616,10839074,10432987,10203165,10425895,8610403,10190278,10203284,10433145,10848331,10433216,10848477,10848488,10848496,10848497,10426125,10426126,10426127,10426128,10426129,10426130,10623391,10426626,8611356,10204246,10204377,10204378,10204379,10427127,8611628,10282872,10282873,10269957,10619893,10837072,10431917,10431930,10431942,10254125,10202198,10202199,10202200,10622140,8584002,10617165,10617166,8622457,10432238,8609565,8609566,8609568,8609569,8609602,8609633,10280535,8609676,8609677,8609684,10202630,10202631,10202632,10622541,8622792,8576186,10202755,10202756,10202757,8609946,8609963,10241853,10425557,10425558,10447329,10447332,10447333,10447343,10447400,10447428,10447599,8620569,10615533,8570365,8570410,8570452,10239725,8574227,8574297,10448035,8838709,8574469,8574470,8574471,8574476,8574477,8574479,8574481,8621140,8574482,8574483,8574484,8574485,8574486,8574487,8574488,8574489,8574491,8574492,8574494,10448193,8574496,8838793,8574497,8574499,8574500,8574505,8574507,8574508,8574510,8574511,8574512,8574513,8574514,8574515,8574518,8574520,8574523,8838820,8574524,8574525,8574526,8574527,8574528,8574529,8574530,8574531,8574532,8574533,8574534,8621195,10921489,10615989,10448273,10616066,10930890,8838977,8839011,10448421,8839027,10930988,10931021,8621448,8583183,8583198,8575027,10431480,10431594,8575270,10616790,10616791,8622142,10616943,8863845,7059494,7059514,9173354,9197354,7059544,7059583,7059586,7059599,7059614,7059615,10565297,10565298,7059652,10565299,10565300,7059655,7059750,8864123,9189625,9189626,8864149,9197654,9197655,10614323,9173799,6665841,10614552,10614553,6665889,10614554,6666016,8864633,10566061,10566062,10566083,8861830,8861831,7057541,8861948,8862052,8862092,7057808,8862182,10557517,10557518,7057941,8862318,8862341,10612485,8862354,8862355,8862356,7058054,9171901,7058089,7058093,8862477,9195956,7058123,10612738,10612741,10120361,10120364,10120366,10612845,10612883,7058413,8862805,9212290,9196350,10613115,7058639,10558300,7058817,10613349,10561557,10561558,9204809,9196873,8863631,8863635,10515116,4974227,7015058,7015066,4974265,9185543,9185544,10117808,10117809,10117811,7055974,10118029,7056012,7056013,4974760,7056099,7056134,9169992,9210144,9178374,9178380,9178391,9178426,9178435,9178438,9178439,9178452,10118649,9178461,9178462,9178465,9178474,9178477,7056644,7056663,9178509,9178524,9178528,7056725,9170943,7057115,9210976,7057167,7057178,7057223,7057336,9195234,7014067,7014068,7014069,7014070,7014071,7014072,7014073,7014074,7014075,7014076,9168462,10416443,10116733,10116734,8918272,7054911,10420118,7055363,4974079,9161243,9174388,10466994,10466995,10466996,10466997,10466998,10466999,10467000,10467001,10467002,10467003,10467004,10467005,6666430,4971326,9174602,6666603,8865197,9166762,9166763,6666808,10467466,9174988,9167003,9175006,9175007,9175008,9175009,9175010,9175011,9175012,9175013,9199036,6667038,4972006,4972022,6667193,6667292,9183397,9175408,9175422,8917092,9175483,4972502,9175657,8550834,9175826,10116043,10116044,9175855,6667883,8551066,9208027,9208028,7013851,7013852,9168203,9168206,10470805,9176257,10883514,10946379,10946380,10946381,10946382,10946383,10946384,10946385,10174897,10174898,10174899,10174900,10174901,10174902,10883958,10160271,10155485,10155486,10155487,8594486,10155488,10175600,10170726,10170727,10170728,10155752,10166388,10156428,10161430,10161431,10161432,10161433,10161434,10161435,10161436,10161437,10161438,10158489,10178503,7000693,7000694,10178551,10173584,7000765,7000815,7000816,10178639,10627277,10178801,10183819,10627328,10178867,10163873,10183900,10178908,7001117,10178955,10178956,10163968,10169025,10159030,10179034,10179339,10179363,10174446,10166522,10176774,10171945,10948870,10948871,10948872,10948873,10948874,10948875,10948876,10948877,10948878,10948879,10948880,10187209,10162281,10881430,10881431,10881432,10881433,10881434,10881435,10881436,10881437,10881438,10881439,10172454,10177496,10177551,10177596,10876667,10876668,10876669,10876670,10876671,10876672,10876673,10876674,10876675,10876676,10876677,10177731,10626253,10876769,10876770,10876771,10876773,10187814,10167922,10167927,10167931,10167942,10167947,10167953,10167960,10167961,10167966,10187969,10167973,10167976,10167977,10167978,10167979,10167982,10167985,10167986,10167990,10167993,10167998,10168004,10168013,10168020,10168024,10168029,10168032,10168033,10168039,10168040,10168043,10168044,10168047,10168054,10168055,10168057,10168059,10168061,10168062,10168066,10168072,10178096,10158155,10178155,10188172,10168211,10173238,10882302,10178343,10626828,10877364,10877365,10877366,10877367,10877368,10877369,10877370,10877371,10586166,10586167,10574319,10574320,10574321,10574322,10574323,10574324,10568549,10589800,10589823,10590027,10590028,10590029,10590030,10590031,10590064,10590065,10590066,10590087,10590090,10590093,10590094,10590095,10590121,10575765,10588720,10588721,10521286,10521287,10521288,10521289,10521290,10527806,10522061,10536669,10421279,10424457) GROUP BY p.products_id ORDER BY CASE WHEN products_price = 0 THEN 99999999 WHEN products_price > 0 THEN products_price END asc ,p.products_specials desc
ERROR: Unknown column 'p.products_specials' in 'order clause'