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(9214482,11001744,8630810,8630811,8630890,8630901,8630902,8630903,8630912,8630913,8630914,8630915,8630917,8630918,8630919,8631027,8631070,10459023,8839038,3229008,10871048,10871049,10871051,10871052,8631471,8631472,8631473,8631474,8631476,8631477,8631478,8631479,8631480,8631481,8631482,10950606,8583488,8583489,8631677,10849376,10849377,10849378,10849379,10849380,10849381,10849382,10849383,10849384,10849385,10849386,10849387,8067275,8631859,8067286,8067292,8067368,8067369,8067396,10459914,10459915,10459917,10459918,10459919,10459921,10459922,10459926,10459927,10459928,10459956,10459957,10459959,10459960,10459961,10459963,10459964,10459968,10459969,10459970,10459996,10459997,10459999,10460000,10460001,10460003,10460004,10460008,10460009,10460010,10460036,10460037,10460039,10460040,10460041,10460043,10460044,10460048,10460049,10460050,10460076,10460077,10460079,10460080,10460081,10460082,10460084,10460088,10460089,10460090,8632190,10460116,8632191,8632192,10460117,8632193,10460119,10460120,10460121,10460123,10460124,10460128,10460129,10460130,10460156,10460157,10460159,10460160,10460161,10460163,10460164,10460168,10460169,10460170,10460196,10460197,10460199,10460200,10460201,10460203,8622468,10460204,8622469,10460208,10460209,10460210,10460236,10460237,10460239,10460240,10460241,10460243,10460244,10460248,10460249,10460250,10460276,10460277,10460279,10460280,10460281,10460283,10460284,10460288,10460289,10460290,8632385,8632386,8632387,10460316,10460317,10460319,10460320,10460321,10460323,10460324,10460328,10460329,10460330,10460356,10460357,10460359,10460360,10460361,10460363,10460364,10460368,10460369,10460370,8629472,8629522,8629523,8629524,8629525,8629526,8629534,8629559,8629585,8067931,8629598,8067943,8629617,8629618,8629619,8629620,8629621,8629622,8629627,8629670,8629679,8629680,8629681,8629689,8629690,8629691,8629692,8629693,8629741,8629742,8629743,8629744,8629751,8629754,8629755,8629756,8629832,8629834,8629836,8629838,8629840,8629841,8629843,8629849,8629852,8629854,8629856,8629859,8629863,8629865,8629868,8629870,8629873,8629881,8629913,8629915,8629917,8629920,8629921,8629923,8629925,8629930,8629932,8629934,8629936,8629938,8629939,8629942,8561243,8629945,8629947,8629950,8629953,8629957,8630406,8630420,8627530,8627574,8627575,8627576,8627577,8627578,8627579,8627580,8627581,8627582,8627583,8627617,8627618,8627619,8627620,8627621,8627622,8627623,8627624,8627625,8627626,8627627,8627628,8627629,8627630,8627631,8627632,8627633,8627634,7201319,7201321,7201384,7201385,8627795,8627796,8627797,8627798,8627799,8627800,8627801,8627802,7201432,10866538,10960062,8628060,8628061,8628062,8628063,8628064,8628065,8628066,8628067,8628068,8628069,8628070,8628258,7202077,8065957,10843709,8628622,8628623,7064985,8628634,8628724,8628725,7202667,7202683,7202684,7202695,8629164,8629166,8629173,8629174,8629177,8629178,8629188,8629223,8629224,8629225,8629226,8629303,8629382,8629385,8629386,8629387,8629388,8629389,8629390,8626469,8834368,3237391,3237392,3237394,3237395,8626749,8626750,8626751,8626752,8626753,8626771,8626834,8626892,8626893,8626894,8626895,8626896,8626897,8626898,8626899,8626900,8626901,7200527,7200528,7200529,8626932,10958987,10958988,10958989,8627073,8627085,8627115,7071514,7200903,7200904,7200911,7200913,8627315,8627317,8627318,8627320,8627321,8627322,8624502,8624508,8624512,8624524,8624525,8624681,8624690,7198381,8624814,8624816,7198681,7198683,7198685,7198696,7198697,7198699,8625106,7198710,7198714,7198716,7198724,7198725,7198730,8625135,8625136,8625137,7198742,7198743,7198748,7198749,7198750,7198760,7198762,7198770,7198772,7069602,10100764,3236570,10941948,8625879,8626211,8626212,8626217,8626223,8626227,8626230,8626250,8626254,8626323,8626324,8626325,8626326,8626327,8626328,8626329,8626330,8626331,8626332,8626333,8626334,8626335,8626336,8626337,8626338,8626339,8626340,8626341,8626342,8626343,8626344,8626345,8626346,8626347,8626348,8626349,10853141,10853232,10853233,11045725,10853335,3923672,3923673,7196890,7196891,7196892,3234127,10968398,3234554,7197433,7197437,7197446,3234716,3234740,3234741,3234742,3234744,8555278,7197611,3234957,3234958,7197806,7197807,8624318,8624319,8624379,8624389,8624397,8624400,8624417,8634615,8634616,8634617,8634677,8634678,8634679,8634680,8634681,8634682,8634683,8634684,8634685,8634686,8541578,11044804,11044807,8634769,11044808,8634770,11044809,11044810,11044811,11044812,11044813,10617322,10617323,10617324,10617377,10617378,10852524,8634899,8634900,10617403,10617404,8634904,10617405,10617409,10617417,10617422,10617423,10617426,10617427,10617428,10617429,10852571,10617430,10617431,10617434,10617435,10617438,10617445,10617456,8634965,10852643,10954313,8542204,8542252,8542253,8542254,8632480,8632490,8632495,8632496,8632497,8632500,8632502,8632503,8632538,8632540,8632627,8632632,10425386,10425391,10620208,8632808,10425553,10615338,10615341,10425577,8632862,8632863,8632864,8632866,8632867,8632868,8632869,8632878,8632879,8632881,8632884,10848006,10848007,8632908,8632909,8632910,10850648,10850650,10615598,3581902,8633197,8633198,8633202,8633203,8633204,8633205,8633206,8633207,8633208,8633209,8633210,8633211,8633212,8633213,8633214,8633215,8633216,8633217,8633218,8633220,8633221,8633222,8633223,8633224,8633225,8633226,8633227,8633228,8633229,8633230,8633231,8633232,8633233,8633234,8633235,8633236,8633237,8633238,8633239,8633240,8633241,8633272,8633273,8633274,8633275,8633276,8633277,8633278,10848408,10848409,10615896,10616005,3582242,10426339,8540530,8540541,8540542,8540543,8540565,8540566,8540567,8540568,8540569,8540588,8540614,10616332,10616417,10616426,10922143,8634150,3232023,3232024,3232025,3232047,8611468,10851969,8634401,8634402,8634403,8634404,8634405,8634409,8634411,8634412,8634414,8634417,8634443,8634444,8634445,8634451,8634452,8634453,8634455,9173987,6666259,10611969,8565891,8565947,9211551,9211552,9211554,9211555,9211556,9211557,9211560,9211561,9211567,9211568,10609937,10612938,10612939,9212319,9212320,9212322,10609988,10613369,10613736,10117517,8849319,8849320,8849321,8849322,8849323,8849329,8849330,8849332,10117726,8849378,10515422,10515423,9169951,9169952,9169953,6674308,6674328,6674329,6674331,10118342,10118374,10118375,8552227,10119183,9913361,8848124,8848127,8848157,8848195,9910628,8848719,8848725,8848726,8848728,8848730,8848741,8848744,8848756,8848758,8848760,8848761,8848762,8848767,8848782,8848829,8848843,8848845,8848848,8848866,8848877,8848889,8848909,8848911,8848920,9193119,9193120,9193121,10122662,10471173,4971471,9175046,8550266,8847268,8847273,8847274,8563358,8563359,8563360,8563361,8563362,8563363,8847310,8847476,8847478,8847480,8847493,8847496,8847500,8847511,8847514,8847529,8847541,8847542,8847584,8847613,9168121,8847998,8848002,8848003,8848014,8848018,8848021,8848024,8848028,8848033,8848034,8848036,8848037,8848046,8848062,8848067,8848103,8848116,10883568,10883624,10883629,10893984,10893985,10893986,10893987,10893988,10175160,10889231,10894377,10890141,10890144,10890145,10890146,10890147,10890148,10890149,10890154,10890158,10890160,10632166,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,10626145,10626241,10626300,10626301,10602171,10602176,10602182,10602185,10602191,10583441,10602696,10602697,10602700,10602705,10602722,10602723,10602724,10602725,10590270,10590273,10590277,10590278,10590279,10590280,10590285,10590286,10590287,10590288,10590299,10590300,10590301,10590302,10590303,10590304,10590305,10590306,10590309,10590310,10590311,10647703,10603684,10603695,10603696,10604146,10579772,10579773,10579774,10579775,10579776,10579777,10601687,10601688,10601693,10601695,10601697,10601702,10529398,10529399,10529409,10529412,10529413,10541443,10541444,10541445,10549588,10549589,10551823,10551920,10551921,10551936,10551937,10551959,10551960,10550384,10550385,10550386,10550445,10550993,10543042,10425325,10422595,10422596,10422598,10422599,10420629,10424885,10424886,10424889,10424890,8562284,10409350,10477099,10477100,10409501,10406982,10406983,10406984,10406985,10406986,10406987,10408988,10406988,10406989,10406990,10406991,10406992,10406993,10409024,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'