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(8628060,8628061,8628062,8628063,8628064,8628065,8628066,8628067,8628068,8628069,8628070,7201711,8628283,8628284,8628285,7201977,7202077,8628521,8628522,8628523,8628524,8628525,8628526,8628527,8628528,8628529,8628530,8628531,8628532,10843709,4970775,8628622,8628623,8628626,8628627,8628634,8628724,8628725,8628729,8628823,8628826,8628832,8628835,8628843,8628844,8628849,8628850,8628855,8628856,8628865,8628866,5654555,8628871,8628872,8628876,8628879,8628882,8628885,8628888,8628890,8628892,8628894,8628898,8628901,8628904,8628907,8628910,8628913,8628916,8628919,8628922,8628925,8628928,8628931,8628934,8628937,8628942,8628945,8628948,8628953,8628954,8628960,8628961,8628966,8628967,8628972,8628973,8628978,8628979,8628984,8628985,8628990,8628991,7202667,7202683,7202684,8629093,8629094,7202695,8629095,8629096,8629099,8629164,8629166,7202769,8629173,8629174,10104659,8629177,8629178,8629188,8629220,8629221,8629222,8629223,8629224,8629225,8629226,8629227,8629228,8629229,8629230,8629231,8629232,8629233,8629234,8629235,8629236,8629237,8629250,8629258,8629303,8629393,8629396,8629439,8629472,8629523,8629525,8629534,8629559,8629585,8629598,8629617,8629618,8629619,8629620,8629621,8629622,8629623,8629626,8629627,8629628,8629631,8629632,8629633,8629670,8629672,8629673,8629741,8629742,8629745,8629746,8629747,8629748,8629754,8629755,8629756,8629832,8629834,8629836,8629838,8629841,8629843,8629849,8629852,8629854,8629856,8629859,8629861,8629862,8629863,8629865,8629868,8629870,8629873,8629877,8629881,8629890,8629913,8629915,8629917,8629920,8629921,8629923,8629925,8629927,8629930,8629932,8629934,8629936,8629938,8629939,7066766,8629942,8629945,8629947,8629950,8629953,8629957,8629958,7200610,8627050,8627052,8627055,8627056,8627057,8627058,8627059,8627060,8627061,8627064,8627065,8627066,8627068,8627072,8627074,8627075,8627083,8627084,8627089,8627090,8627093,8627094,8627099,8627106,8627107,8627108,8627109,8627110,8627112,8627117,8627119,8627120,8627121,8067931,8067943,7067102,7200903,7200904,7067134,7200911,7200912,7200913,8627314,7200914,8627315,8627316,8627317,8627318,8627319,8627320,8627321,8627322,7201080,8627530,8627574,8627575,8627576,8627577,8627578,8627579,7201200,7201319,7075578,7201384,7201385,10842926,10842927,7201432,7201453,7075776,7198681,7198683,7071911,7198685,7198696,7198697,7198699,7198710,7198711,7198714,7198716,7198719,7198724,7198725,7198728,7198730,7198742,7198743,7198748,7198749,7198750,7071983,7198760,7198762,7198770,7198772,10100764,7064592,3236570,10195956,7064736,7064985,7200121,8834368,3237391,3237392,3237393,3237394,3237395,7065750,7200527,7200528,7200529,7197611,3234901,3234902,3234904,3234905,3234906,3234956,3234957,3234958,7197805,7197806,7197807,7071514,10233777,7198381,10194896,10194897,10194898,8071683,8071684,8071685,8071686,8071687,8071692,8071693,8071694,8071695,8071704,8071705,8071707,8541920,8541921,8071748,8071749,8071750,8071751,8071752,8071757,8071758,8071759,8071760,8071769,8071770,8071772,8071813,8071814,8071815,8071816,8071817,8071822,8071823,8071824,8071825,8071834,8071835,8071837,8071878,8071879,8071880,8071881,8071882,8071887,8071888,8071889,8071890,8071899,8071900,8071902,8071943,8071944,8071945,8071946,8071947,8071952,8071953,8071954,8071955,8071964,8071965,8071967,8072008,8072009,8072010,8072011,8072012,8542204,8072017,8072018,8072019,8072020,8072029,8072030,8072032,8542252,8542253,8542254,8072073,8072074,8072075,8072076,8072077,8072082,8072083,8072084,8072085,8072094,8072095,8072097,8072138,8072139,8072140,8072141,8072142,8072147,8072148,8072149,8072150,8072159,8072160,8072162,8542370,8542371,8542372,8072203,8072204,8072205,8072206,8072207,8072212,8072213,8072214,8072215,10283599,8072224,8072225,8072227,8072268,8072269,8072270,8072271,8072272,8072277,8072278,8072279,8072280,8072289,8072290,8072292,7069602,7069606,10283961,4937288,4937289,4937290,4937291,4937292,4937297,4937298,4937299,4937300,4937310,4937311,4937313,4937357,4937358,4937359,4937360,4937361,4937366,4937367,4937368,7196890,4937369,7196891,7196892,4937378,4937379,4937381,4937422,4937423,4937424,4937425,4937426,4937431,4937432,3234127,4937433,4937434,4937443,4937444,4937446,10941948,4937487,4937488,4937489,4937490,4937491,4937496,4937497,4937498,4937499,4937508,4937509,4937511,4937552,4937553,4937554,4937555,4937556,4937561,4937562,4937563,4937564,4937573,4937574,4937576,4937617,4937618,4937619,4937620,4937621,4937626,4937627,4937628,4937629,4937638,4937639,4937641,4937682,4937683,4937684,4937685,4937686,4937691,4937692,4937693,4937694,4937703,4937704,4937706,4937747,4937748,4937749,4937750,4937751,4937756,4937757,4937758,4937759,4937768,4937769,4937771,4937812,4937813,4937814,4937815,4937816,4937821,4937822,4937823,4937824,4937833,4937834,4937836,3234554,4937877,4937878,4937879,4937880,4937881,4937886,4937887,4937888,4937889,4937898,4937899,4937901,8860554,7197433,7197437,7197446,4937942,4937943,4937944,4937945,4937946,4937951,4937952,4937953,4937954,4937963,4937964,4937966,4938007,4938008,4938009,4938010,4938011,4938016,4938017,4938018,4938019,4938028,4938029,4938031,3234740,3234741,3234742,3234743,3234744,10190224,10848408,10848409,10426339,8540530,8540541,8540542,8540543,8540544,8540564,8540565,8540566,8540567,8540568,8540569,8540588,8540589,8540590,8540591,8540592,8540614,8611003,8540781,8540782,3232023,3232024,3232025,3232047,8611468,10282598,10282603,10282604,10282605,10282606,10282607,10282608,10282609,8541578,8071550,8071551,8071552,8071553,8071554,8071559,8071560,8071561,8071562,8071572,8071573,8071575,8071618,8071619,8071620,8071621,8071622,8071627,8071628,8071629,8071630,8071639,8071640,8071642,8622468,8622469,10617322,10617323,10617324,3230164,3230165,3230183,10617377,10617378,10617384,10617403,10617404,10617405,10617409,10617417,10617422,10617423,10617426,10617427,10617428,10617429,10617430,10617431,10617432,10617433,10617434,10617435,10617438,10617442,10617443,10617445,10617456,10425386,10425391,10425553,10425555,10425577,10848006,10848007,10620195,10620196,10620197,10620198,10620199,10620208,10615229,10615338,10615341,10615711,10615896,10616005,10616059,8839038,3229008,10240407,10616332,10616417,10616426,10431549,8583487,8583488,8583489,10616888,6669823,9173987,10614857,6666259,10611969,9211551,9211552,9211554,9211555,9211556,9211557,9211560,9211561,9211567,9211568,10612938,10612939,9212315,9212319,9212320,9212322,9172538,9172545,10613369,10613736,10117516,10117517,6673693,10117726,4974438,4974442,7055775,10515422,10515423,4974522,4974543,9169951,9169952,9169953,6674308,6674309,6674310,6674311,6674312,6674327,6674328,6674329,6674330,6674331,10118342,10118374,10118375,4975237,10119085,8552227,10119183,10419468,10419494,10418543,10418544,10418545,10418546,9193119,9193120,9193121,6673506,10122662,10471173,4971471,4971473,8549916,8549957,8550037,8550038,8550266,9175850,9168100,9168121,10883568,10883624,10883627,10883629,10893984,10893985,10893986,10893987,10893988,10889231,10894377,10155731,10890085,10890141,10890144,10890145,10890146,10890147,10890148,10890149,10890154,10890155,10890158,10890160,10626963,10632166,10883045,7001400,7001401,10883415,10883416,10630023,10630024,10630025,10630026,10630027,10630028,10630029,10630030,10630031,10630032,10630033,10630034,10630035,10630036,10630037,10630038,10630039,10630040,10630041,10630043,10630044,10630045,10630047,10630048,10630049,10630050,10630051,10630052,10630053,10630054,10630055,10630056,10630057,10630058,10630059,10630060,10630061,10630062,10630063,10630064,10630065,10630066,10630067,10630093,10630177,10886057,10886058,10886059,10886060,10881537,10881538,10891654,10891655,10626145,10626241,10887096,10887097,10626724,10626725,10583441,10590270,10590273,10590277,10590278,10590279,10590280,10590285,10590286,10590287,10590288,10590299,10590300,10590301,10590302,10590303,10590304,10590305,10590306,10590309,10590310,10590311,10647703,10579772,10579773,10579774,10579775,10579776,10579777,10579778,10579779,10579780,10579781,10529398,10529399,10529409,10529412,10529413,10541443,10541444,10541445,10527957,10543042,10425325,10423563,10422595,10422596,10422597,10422598,10422599,10420629,10407369,10407370,10477099,10477100,10407925,10406982,10406983,10406984,10406985,10406986,10406987,10408988,10406988,10406989,10406990,10406991,10406992,10406993,10409024,10409025,10487786) 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'