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(8559322,8559323,8068885,8068886,8068887,8559425,10858952,10843714,3899481,10198775,10198784,10872386,10872387,8560068,8560069,8560070,10872442,10872443,8595807,8595808,8619134,8619135,7073837,7073838,7073839,7073840,7073841,7073849,10238098,10238099,10238100,10238101,8837019,10251397,10251398,10251399,10251400,10251401,10251402,10251403,10251404,10251405,10251406,10251407,10251408,10251409,10251410,10251411,10251412,10251427,10251428,10251429,10251430,10251433,10251434,3227208,10251586,3227564,10437626,10437627,10437628,10437629,7066700,7074899,7074900,7074901,8627467,10840170,6000196,6000197,6000249,6000250,6000251,7198747,10856126,7064367,7064371,10247621,10101282,3926878,3926929,3926930,3926931,7199876,10857037,10222735,10197051,10942704,10942708,10942716,10942717,8614497,10285398,10855049,10246536,10246537,10246538,10943153,10943154,10100266,10100267,10100274,10100289,5999930,10866206,10853248,10853249,10853250,10283823,10283824,10283827,7069645,10283942,10866766,10866767,10866768,10866769,10866770,8554700,8906865,10838774,10838776,8073485,8073486,10867501,3234728,10850683,10433172,3231075,10618289,10863991,9217392,9217410,3582191,3582192,10864155,9217657,9217665,9217666,8540613,8540614,8540780,8540885,8577681,8577712,8577713,8552877,8541472,10282813,10282814,10282815,10282816,10282829,10243980,10243981,10243982,10243983,10244024,10244025,10189437,10189438,10189439,10189440,10189441,10189442,10189443,10189444,3230360,8576431,10622902,8561317,10615223,8570262,8570263,8570264,8570265,10930234,10930235,10930247,10845750,10845751,10845752,10845756,10845757,10845761,10845762,10930318,10930525,10279170,10188353,10431252,10846806,3229636,10939611,10939612,9189508,10559316,10559317,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,9197863,10562669,9197864,10562670,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,9193849,10517660,10517661,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,10655973,10655974,10655975,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'