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(11001744,8630787,8630810,8630811,8630890,8630901,8630902,8630903,8630911,8630912,8630913,8630915,8630917,8630918,8630919,8631027,8631070,10459023,3229008,8631471,8631472,8631473,8631474,8631476,8631477,8631478,8631479,8631480,8631481,8631482,8631487,8631490,8631491,8631492,8631496,8631497,8631498,8631502,8631506,8631507,8631508,8583487,8583488,8583489,8631677,8631679,8631859,8067275,8067286,8067292,10459914,10459915,10459917,10459918,10459919,10459921,10459922,10459926,10459927,10459928,10459956,10459957,10459959,10459960,10459961,10459963,10459964,10459968,10459969,10459970,8067396,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,8632241,10460168,10460169,10460170,8632246,8632248,8632252,8632270,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,8632382,8632385,8632386,8632387,10460316,10460317,10460319,10460320,10460321,10460323,10460324,10460328,10460329,10460330,7066766,10460356,10460357,10460359,10460360,10460361,10460363,10460364,10460368,10460369,10460370,8632464,8632466,8632468,8632470,8632471,8632472,8632474,8632475,8632476,8632478,8632480,8632481,8632483,8632485,8632487,8632489,8632490,8632495,8632496,8632497,8632500,8632502,8632503,8632538,8632540,8629585,8629598,8629617,8629618,8629619,8629620,8629621,8629622,8629623,8629626,8629627,8629628,8629631,8629632,8629633,8629670,8629679,8629680,8629681,8067931,8629689,8629690,8629691,8629692,8629693,8067943,8629741,8629742,8629743,8629744,8629745,8629746,7067102,8629747,8629748,8629751,8629754,8629755,8629756,7067134,8629832,8629834,8629836,8629838,8629840,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,8629942,8629945,8629947,8629950,8629953,8629957,8629958,7075578,8630280,8630282,8630283,8630406,8630420,7075776,8630442,8630443,8630445,8630446,8630449,8630451,8630452,9214482,8627581,8627582,8627583,7201200,8627625,8627626,8627627,8627628,7071983,8627630,8627631,8627632,8627633,7201319,7201321,7201384,7201385,8627795,8627796,8627797,8627798,8627799,8627800,8627801,8627802,10842926,10842927,7201432,10960062,8628060,8628061,8628062,8628063,8628064,8628065,8628066,8628067,8628068,8628069,8628070,7064592,8628258,8628283,8628284,8628285,7201977,7064736,7202077,8628521,8628522,8628523,8628524,8628525,8628526,8628527,8628528,8628529,8628530,8628531,8628532,10843709,8628622,8628623,8065957,7064985,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,8629094,8629095,7202695,8629096,8629099,8629164,8629166,8629173,8629174,10104659,8629177,8629178,8629188,8629220,8629221,8629222,8629223,8629224,8629225,8629226,8629227,8629228,8629229,8629230,8629231,8629232,8629233,8629234,8629235,8629236,8629237,8629258,8629303,8629382,8629385,8629386,8629387,8629388,8629389,8629390,7065750,8629522,8629523,8629524,8629525,8629526,8629534,8629559,3237391,3237392,3237393,3237394,3237395,8626749,8626750,8626751,8626752,8626753,8626771,8626825,8626834,8626892,8626893,8626894,8626895,8626896,8626897,8626898,8626899,7200527,7200528,7200529,8626932,8627073,8627085,8627115,7071514,7200903,7200904,7200911,7200912,7200913,7200914,8627315,8627317,8627318,8627320,8627321,8627322,8627530,7071911,8627574,8627575,8627576,8627577,8627578,8627579,8627580,8624681,8624690,7198381,8624814,8624816,7198681,7198683,7198685,7198696,7198697,7198699,8625106,7198710,7198711,7198714,7198716,7198719,7198724,7198725,7198728,7198730,8625135,8625136,8625137,7198742,7198743,7198748,7198749,7198750,7198760,7198762,7198772,7069602,7069606,10100764,3236570,10941948,8626211,8626212,8626217,8626223,8626227,8626228,8626230,8626250,8626254,8626255,8626256,8626326,8626327,8626328,8626338,8626343,8626345,8626347,8626349,8626420,8626446,8626451,8626456,8626462,8626465,8626466,8626467,8626468,8626469,8834368,11045725,7196890,7196891,7196892,3234127,10968398,7197433,7197437,7197446,3234716,7197611,3234957,3234958,8624318,8624319,8624379,8624380,8624389,8624397,8624400,8624417,8624502,8624508,8624512,8624524,8624525,8634615,8634616,8634617,8634677,8634678,8634679,8634680,8634681,8634682,8634683,8634684,8634685,8634686,8541578,11044804,11044807,8634769,11044808,8634770,11044809,11044810,11044811,11044812,11044813,8634899,8634900,8634904,10617322,8634965,10617377,8635015,8635018,8635020,8635021,8635022,10617426,10617427,10617428,10617429,10617430,10617431,10617432,10617433,10617438,10617442,10617443,10617445,10617456,10954313,8542204,8542252,8542254,8632627,8632632,8632702,8632808,10615229,8632862,8632863,8632864,8632866,8632867,8632868,8632869,8632878,8632879,8632881,8632884,10848006,10848007,8632908,8632909,8632910,10615338,10615341,3581902,8633197,8633198,8633202,8633203,8633204,8633205,8633206,8633207,8633208,8633209,8633210,8633211,8633212,8633213,8633214,8633215,8633216,8633217,10615598,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,3582242,10615896,10616005,8540530,8540541,8540542,10616059,8540564,8540566,8540567,8540588,8540590,8540591,8540614,8611003,10616332,10616417,10616426,8634101,8634150,3232023,3232024,10922143,3232025,3232047,8634401,8634402,8634403,8634404,8634405,8634409,8634411,8634412,8634414,8634417,8634441,8634443,8634444,8634445,8634449,8634450,8634451,8634452,8634453,8634454,8634455,8634456,8634457,8634458,8634459,8634460,8634461,8634462,8634463,8634464,8634465,8634466,8634467,8634468,8634469,8634470,8634471,8634472,8634473,8634474,8634475,8634476,8634477,8634478,8634479,8634480,6669823,9173987,6666259,10611969,8565891,8565947,9211551,9211552,9211554,9211555,9211556,9211557,9211560,9211561,9211567,9211568,10609937,9212315,9212319,9212320,9212322,10609988,10613369,10613736,10117516,10117517,10117726,10515422,10515423,6674308,6674327,6674328,6674329,6674330,6674331,10118342,10118374,10118375,8552227,10419494,10418543,10418544,10418545,9193119,9193120,9193121,10122662,10471173,4971471,8549957,9175046,9168121,10883568,10883624,10883627,10883629,10893984,10893985,10893986,10893987,10893988,10175160,10889231,10894377,10890141,10890144,10890145,10890146,10890147,10890158,10890160,10626963,10632166,10883045,7001400,7001401,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,10891654,10891655,10626145,10626300,10626301,10583441,10590270,10590273,10590277,10590285,10590286,10590287,10590288,10590299,10590300,10590301,10590302,10590303,10590309,10579772,10579773,10579774,10579775,10579776,10579777,10529398,10529399,10529409,10529412,10529413,10541443,10541444,10527957,10543042,10425325,10422595,10422596,10422598,10422599,10424885,10424886,10424889,10424890,10409350,10477099,10477100,10409501,10406983,10406984,10406985,10408988,10406992,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'