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(10939611,10939612,8068885,8068886,8068887,10930234,10930235,10930247,10962667,10962676,10845750,10845751,10845752,10845756,10845757,10845761,10845762,10930318,10950294,7073837,7073838,7073839,7073840,7073841,7073849,11041642,10846806,3229636,10437626,10437627,10437628,10437629,7066700,7074899,7074900,7074901,10872386,10872387,3227564,10872442,10872443,8561317,8627467,6000196,6000197,10866206,6000249,6000250,6000251,11011838,11011839,11011840,11011841,11011842,11011843,11011844,11011845,11011846,11011847,11011848,11011849,11011850,11011851,11011852,11011853,11011865,11011866,11011867,11011869,11011870,11012008,7064367,7064371,8559322,8559323,10866766,10866767,8559425,10866768,10866769,10866770,10986293,10858952,10843714,10999659,10999660,10999661,10999662,3899481,8560068,8560069,8560070,8595807,8595808,10867501,8619134,8619135,8837019,3227208,10942704,10942708,10942716,10942717,10943153,10943154,5999930,10100266,10100267,10100274,10100289,10840170,7198747,7069645,10863991,10856126,10864155,10101282,3926878,3926929,3926930,3926931,8073485,7199876,8073486,10857037,10853248,10853249,10853250,10618289,11032843,11032846,11032847,11032848,11032940,11032941,11032942,11032943,11045973,11033073,11033074,11033075,11033076,11033077,11033078,11033079,11033080,11033081,11007142,11007143,11007144,11033284,11033285,8554700,8906865,11033514,11033515,10838774,10838776,11007710,11007711,3234728,11008234,8614497,10855049,10953606,10953607,10953608,10953609,10953610,10953611,10953612,10953613,8552877,8541472,11044998,11044999,11045011,10622902,3230360,10615223,8576431,8570262,8570263,8570264,8570265,10850683,10930525,10952236,3231075,9217392,9217410,3582191,3582192,11004639,11004640,11004641,11004642,11004683,11004684,9217657,9217665,9217666,8540613,8540614,8540780,8540885,8577681,8577712,8577713,10559316,10559317,9189508,6677721,6677722,6677725,6677726,6677727,6677728,6677729,6677730,10614383,6665759,10562654,10562655,10562656,10562657,10562658,10562659,10562660,10562661,10562662,10562663,10562664,10562665,10562666,10562667,10562668,10562669,10562670,9197863,9197864,9197865,9214175,8864704,8542629,8542681,9195899,9211945,9212093,9212109,7058605,9172471,9172472,10558459,10558460,10558461,10558462,10558463,10558464,10558465,10558480,10558481,10558482,10558483,10558484,10558485,10558486,10558487,10558488,10558489,10558490,10558491,10558492,10558493,10558494,10558495,10558496,10613371,8863764,8863765,7059415,7059416,7059417,7059418,7059419,7059420,7059421,7059422,7059423,7059424,9161327,9161480,9193514,9161514,9193515,9161759,10517660,10517661,9193849,10517662,10517663,10517664,10517665,10517666,10517667,10517668,10515776,10515777,10515778,10515779,10515780,10515909,10515910,10515911,10515912,10515913,10515914,10515915,10515916,10515917,9912918,9912920,9912921,9912939,3651947,3651948,3651949,3651950,3651951,3651952,3651953,10119041,9170885,10516907,10513027,10419315,10417396,10428029,10419622,10419623,10419624,10419625,10419626,9198839,9198840,10123303,9191115,6473844,9199619,9199620,9199621,8550895,8550896,8550897,9199820,10124063,9191949,9175957,9191970,8917767,8917768,10470809,10946456,10946457,10174698,10628787,10628806,10629228,10629229,10629230,10629231,10629232,10629233,10629234,10629235,10629247,10629248,10629249,10629250,10629251,10629252,10629253,10629254,10629255,10629256,10170882,10170883,10170884,10170885,10170886,10170887,10170888,10170889,10170890,10889894,10629409,10629410,10629411,10629412,10629413,10629414,10629415,10629416,10900314,10900315,10900316,10900317,10900318,10900319,10900320,10900321,10900322,10900323,10900324,10900325,10900326,10900327,10900328,10912503,10912504,10912515,7000882,10912758,10912759,10178847,10908015,10908016,10908017,10908018,10908019,10179186,10888328,8593458,10903466,10903467,10903468,10903469,10910940,10176978,10176979,10176980,10176981,10176982,10187072,10187073,10187074,10187075,10187076,10187077,10187078,10187079,10177109,10177110,10177111,10177112,10911594,10911618,10911619,10911836,10652862,10590522,10590523,10590524,10581787,10581788,10581789,10581790,10607435,10607436,10607437,10607438,10579757,10601049,10601058,10601059,10601060,10525621,10525622,10525623,10525624,10525625,10525626,10525627,10525628,10525629,10525630,10525631,10525632,10525633,10525634,10525635,10525636,10525637,10525638,10525639,10525640,10525641,10525642,10525643,10525644,10525645,10525646,10525647,10525648,10525649,10525650,10525651,10525652,10525653,10525654,10525655,10525656,10525657,10525658,10525659,10525660,10525661,10525662,10525663,10525664,10525665,10525666,10525667,10525668,10525669,10525670,10525671,10525672,10525673,10525674,10525675,10525676,10525677,10525678,10525679,10525680,10525681,10525682,10525683,10525684,10525685,10525686,10525687,10525688,10525689,10525690,10525691,10525692,10525693,10525694,10525695,10525696,10525697,10525698,10525699,10525700,10525701,10525702,10525703,10525704,10525705,10525706,10525707,10525708,10525709,10525710,10525711,10525712,10525713,10525714,10525715,10525716,10525717,10525718,10525719,10525720,10525721,10525722,10525723,10525724,10525725,10525726,10525727,10525728,10525729,10525730,10525731,10525732,10525733,10525734,10525735,10525736,10525737,10525738,10525739,10525740,10525741,10525742,10525743,10525744,10525745,10525746,10525747,10525748,10525749,10525750,10525751,10525752,10525753,10525754,10525755,10525756,10525757,10525758,10525759,10525760,10525761,10525762,10525763,10525764,10525765,10525766,10525767,10525768,10525769,10525770,10525771,10525772,10525773,10525774,10525775,10525776,10525777,10525778,10525779,10525780,10525781,10525782,10525783,10525784,10525785,10525786,10525787,10525788,10525789,10525790,10525791,10525792,10525793,10525794,10525795,10525796,10525797,10525798,10525799,10525800,10525801,10525802,10525803,10525804,10525805,10525806,10525807,10525808,10525809,10525810,10525811,10525812,10525813,10525814,10525815,10525816,10525817,10525818,10525819,10525820,10525821,10525822,10525823,10525824,10525825,10525826,10525827,10525828,10525829,10525830,10525831,10525832,10525833,10525834,10525835,10525836,10525837,10525838,10525839,10525840,10525841,10525842,10525843,10525844,10525845,10525846,10525847,10525848,10527848,10525849,10525850,10525851,10525852,10525853,10525854,10525855,10525856,10525857,10525858,10525859,10525860,10525861,10525862,10525863,10525864,10525865,10525866,10525867,10525868,10525869,10525870,10525871,10525872,10525873,10525874,10525875,10525876,10525877,10525878,10525879,10525880,10525881,10525882,10525883,10525884,10525885,10525886,10525887,10525888,10525889,10525890,10525891,10525892,10525893,10525894,10525895,10525896,10525897,10525898,10525899,10525900,10525901,10525902,10525903,10525904,10525905,10525906,10525907,10525908,10525909,10525910,10525911,10525912,10525913,10525914,10525915,10525916,10525917,10525918,10525919,10525920,10525921,10525922,10525923,10525924,10525925,10525926,10525927,10525928,10525929,10525930,10525931,10525932,10525933,10525934,10525935,10525936,10525937,10525938,10525939,10525940,10525941,10525942,10525943,10525944,10525945,10525946,10525947,10525948,10525949,10525950,10525951,10525952,10525953,10525954,10525955,10525956,10525957,10525958,10525959,10525960,10525961,10525962,10525963,10525964,10525965,10525966,10525967,10525968,10525969,10525970,10525971,10525972,10525973,10525974,10525975,10525976,10525977,10525978,10525979,10525980,10525981,10525982,10525983,10525984,10525985,10525986,10525987,10525988,10525989,10525990,10525991,10525992,10525993,10525994,10525995,10525996,10525997,10525998,10525999,10526000,10526001,10526002,10526003,10526004,10526005,10526006,10526007,10526008,10526009,10526010,10526011,10526012,10526013,10526014,10526015,10526016,10526017,10526018,10526019,10526020,10526021,10526022,10526023,10526024,10526025,10526026,10526027,10544028,10526028,10544029,10526029,10544030,10526030,10544031,10526031,10544032,10526032,10544033,10526033,10544034,10526034,10544035,10526035,10544036,10526036,10544037,10526037,10544038,10526038,10544039,10526039,10544040,10526040,10544041,10526041,10544042,10526042,10544043,10526043,10544044,10526044,10544045,10526045,10544046,10526046,10544047,10526047,10544048,10526048,10544049,10526049,10544050,10526050,10544051,10526051,10544052,10526052,10544053,10526053,10544054,10526054,10544055,10526055,10544056,10526056,10544057,10526057,10544058,10544059,10544060,10544061,10544062,10544063,10544064,10544065,10544066,10544067,10544068,10544069,10544070,10544071,10533107,10423518,10423523,10423561,10423562,10411239,8562252,10409444,10409445,10409446,10411893,10407944,10410262,10494978,10494979,10494980,10494981,10494982,10476444) 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'