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(4970450,4970673,4970676,4970677,4970678,4970679,4970680,4970681,4970682,4970683,4970706,4970724,4970759,4970760,4970773,8569559,8569568,8569569,8569750,7065910,7065933,7065950,7065951,7065960,7065961,7065962,7065963,7065964,7065965,7065966,7065967,7065968,7065969,7065970,7065971,7065972,7065973,7065974,7065975,7065976,7065977,7065978,7065979,7065980,7066011,7066012,7066013,7066024,7066025,7066026,7066027,7066028,7066029,7066030,7066031,7066032,7066227,7066228,7066229,7066230,7066231,7066232,7066233,7066234,7066235,7066236,8067906,8067907,8067908,8067909,7072068,10942755,10931197,7069593,10942029,10942030,8860323,8860337,8860338,8860339,8860340,8860341,8860342,8860343,8860344,8860345,8860346,8860347,8860348,8860349,8860350,8860351,8860352,8860353,8860354,8860364,8860365,8860366,8860404,8860414,8860443,10618267,10618271,10618272,10618293,10618305,10618306,10618307,10618325,10618330,10618331,10618332,10623501,10623505,10623508,8070780,10619177,10619237,10927888,10622424,10622441,10622508,10622526,10928331,10620487,10620488,10620491,10620565,10621652,10621653,10621654,10621660,10621661,10621662,10621664,10621665,10621671,10621675,10621677,10621678,10621679,10621680,10621684,10621688,10621732,10614078,10614079,10614085,10614086,10614089,10614106,10614107,10614108,10614221,10614222,10614223,10614224,10614225,10614226,10559396,10614316,10614327,10614328,10614329,10614374,10614465,10614466,10614467,10614468,10614469,10614470,10614475,10614476,10614485,10614486,10614488,10614489,10614492,10614537,10614538,10614539,10614570,10614588,10614596,10614624,10614632,10614635,10614636,10614637,10614648,10614663,10614695,10614819,10614820,10614821,10614822,10614823,10614824,10614825,10614826,10614827,10614849,10614857,10614894,10614895,10614896,10614913,10566080,10566081,10566082,10566083,10611968,10611981,10612029,10612032,10612034,10612058,10612062,10612063,10612064,10612095,10612158,10612159,10612160,10612161,10612162,10612163,10612164,10612165,10612166,10612167,10612168,10612169,10612170,10612191,10612192,10612194,10612195,10612196,10612197,10612198,10612201,10612228,10612248,10612256,10612257,10612259,10612264,10612267,10612273,10612320,10612321,10612322,10612323,10612324,10612325,10612326,10612327,10612328,10612329,10612330,10612331,10612332,10612333,10612334,10612335,10612336,10612337,10612338,10612339,10612340,10612341,10612344,10612384,10612389,10612390,10612391,10612479,10612506,10612555,10612556,10612557,10612558,10612620,10612757,10612763,10612765,10612766,10612772,10612782,10612809,10612821,10612822,10612884,10612886,10612888,10612889,10612893,10612894,10612895,10612896,10612907,10612912,10612914,10612952,10612958,10612982,10613018,10613019,10613079,10613080,10613163,10613187,10613220,10613221,10613260,10613315,10613321,10613322,10613323,10613324,10613325,10613326,10613327,10613378,10558592,10613453,10613562,10613693,10613750,10613754,10613768,10613804,10613819,10613844,10517536,10513728,10513729,10514036,10514037,10514038,10514041,10514075,10514076,10514090,10514091,10514092,10514093,10514114,10514115,10514116,10512118,10512119,10512120,10514364,10514368,10514369,10514370,10514371,10514372,10514373,10514374,10514376,10514377,10514378,10514379,10514380,10514381,10514382,10514383,10514384,10514385,10514386,10514387,10514388,10514389,10514390,10514391,10514392,10514393,10514394,10514395,10514396,10514397,10514398,10514399,10514400,10514401,10514402,10514403,10514404,10514405,10514406,10514407,10514408,10514409,10514410,10514411,10514412,10514413,10514414,10514415,10514416,10514417,10514418,10514419,10514420,10514421,10514422,10514423,10514424,10514425,10514426,10514427,10514428,10514429,10514430,10514431,10514432,10514433,10514434,10514435,10514446,10514463,10514464,10514472,10512559,10512949,10512950,10512951,10514964,10514965,10514975,10514976,10514977,10515067,10515068,10515069,10515072,10515073,10515074,10515075,10515087,10515088,10515089,10515090,10515091,10515092,10515093,10515094,10515095,10515096,10515097,10515098,10515099,10515100,10515101,10515102,10419253,10419255,10419271,10419364,10419365,10419407,10419408,10417424,10417425,10417426,10417427,10417428,10417429,10417430,10417431,10417432,10417433,10417434,10417435,10417436,10417437,10417438,10417439,10417440,10417441,10417442,10419443,10419444,10419470,10419493,10417506,10417507,10417508,10417509,10417510,10417511,10417512,10417513,10417514,10417515,10417516,10417517,10417518,10417519,10417520,10417521,10417523,10417524,10417525,10417526,10417527,10417528,10417539,10417540,10417541,10417562,10416566,10419566,10416567,10419567,10416568,10419572,10419573,10419574,10419575,10419576,10419577,10419578,10419579,10419580,10419581,10419582,10419583,10419584,10419585,10419586,10419587,10419588,10419589,10419590,10419591,10416678,10416758,10416761,10416762,10416763,10416765,10416766,10416770,10419791,10419792,10419793,10417811,10417812,10417813,10417814,10417815,10417816,10417817,10417818,10417819,10417820,10417821,10417822,10417823,10417824,10417825,10417826,10417827,10417828,10417829,10417830,10417831,10417832,10417833,10417834,10417835,10417836,10417837,10417838,10417839,10417840,10417841,10417842,10417843,10417844,10417845,10417846,10417847,10417848,10417849,10417850,10417851,10417852,10417853,10417854,10417855,10417856,10417857,10417858,10417859,10417860,10417861,10417862,10417863,10417864,10417865,10417866,10417867,10417868,10417869,10417870,10417871,10417872,10417873,10417874,10417875,10417876,10417877,10417878,10417879,10417880,10417881,10417882,10417883,10417884,10417885,10417886,10417887,10417888,10417889,10417890,10417891,10417892,10417893,10417894,10417895,10417896,10417897,10417898,10417899,10417900,10417901,10417902,10417903,10417904,10417905,10417906,10417907,10417908,10417909,10417910,10417911,10417912,10417913,10417914,10417915,10417916,10417917,10417918,10417919,10417920,10417921,10417922,10417923,10417924,10417925,10417926,10417927,10417928,10417929,10417930,10417931,10417932,10417933,10417934,10417935,10417936,10417937,10417938,10417939,10417940,10417941,10417942,10417943,10417944,10417945,10420084,10420085,10420086,10420087,10420088,10420089,10420090,10420091,10420092,10420093,10420094,10420095,10420096,10420097,10420098,10420154,10420157,10420160,10420162,10420164,10420167,10420169,10420192,10420193,10420195,10470876,10470877,10470878,10470879,10470880,10470881,10470882,10470883,10470884,10470885,10470886,10470887,10470888,10470889,10470890,10470891,10470892,10470893,10470894,10470895,10470896,10470897,10470898,10470899,10470900,10470901,10470902,10470903,10470904,10470905,10470906,10470907,10470908,10470909,10470910,10470911,10470912,10470913,10470914,10470915,10470916,10470917,10470918,10470919,10470920,10470921,10470922,10470923,10470924,10470925,10470926,10470927,10470928,10470929,10470930,10470931,10470932,10470933,10470934,10470935,10470936,10470937,10470938,10470939,10470940,10470941,10470942,10470943,10470944,10470945,10470946,10470947,10470948,10470949,10470950,10470951,10470952,10470953,10470954,10470955,10470956,10470957,10470958,10470959,10470960,10470961,10470962,10470963,10470964,10470965,10470966,10470967,10470968,10470969,10470970,10470971,10470972,10470973,10470974,10470975,10470976,10470977,10470978,10470979,10470980,10470981,10470982,10470983,10470984,10470985,10470986,10470987,10470988,10470989,10470990,10470991,10470992,10470993,10470994,10470995,10470996,10470997,10470998,10467115,10467486,10467487,10467488,10467489,10467490,10467491,10467492,10467493,10467494,10467495,10467496,10467497,10467498,10467499,10467500,10467501,10467502,10467503,10467504,10467505,10467506,10467507,10467508,10467509,10467510,10467511,10467512,10467513,10467514,10467515,10467516,10467517,10467518,10467519,10467520,10467521,10467522,10467523,10467524,10467525,10467526,10467527,10467528,10467529,10467530,10467531,10467532,10467533,10467534,10467535,10467536,10467537,10467538,10467539,10467540,10467541,10467542,10467543,10467544,10467545,10467546,10467547,10467548,10467549,10467550,10467551,10467552,10467553,10467554,10467555,10467556,10467557,10467558,10467798,10467799,10467800,10467801,10467802,10467803,10463896,10469897,10465899,10463906,10463923,10470083,10470084,10470085,10470086,10470087,10470088,10470089,10470090,10470091,10466340,10466347,10466406,10466413,10466427,10466443,10466446,10470696,10470725,10470813,10470814,10470815,10470816,10470817,10470818,10470819,10470820,10470821,10470822,10470823,10470824,10470825,10470826,10470827,10470828,10470829,10470830,10470831,10470832,10470833,10470834,10470835,10470836,10470837,10470838,10470839,10470840,10470841,10470842,10470843,10470844,10470845,10470846,10470847,10470848,10470849,10470850,10470851,10470852,10470853,10466854,10470854,10470855,10470856,10470857,10470858,10470859,10470860,10470861,10470862,10470863,10470864,10470865,10470866,10470867,10470868,10470869,10470870,10470871,10470872,10470873,10470874,10470875) 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'