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(10198066,10198067,10250071,10250072,7067891,7067892,7067902,10250331,10250332,10250333,10250334,10250335,10250392,10250393,10250402,10276465,7076229,7076363,7074050,7066396,7066398,7066399,7066401,7066402,7066403,7066405,7066406,7066407,7066408,7066410,7066411,7066414,7066415,7066416,7066417,7066418,7074612,10437578,7074632,7074684,7074728,7066882,7066883,7066884,8068097,8910717,8910830,10236605,10236606,10236607,10236611,10236644,10236676,10236677,10236681,10236682,8835541,8835542,8835543,10223795,8835566,8835598,8068610,8835638,10236892,8068645,8068646,8068647,8068648,8068649,8068650,8835677,8835678,8835685,8835698,8835699,8835711,8835712,8835713,8835714,8068748,8068749,8068750,8068751,8068767,8068768,8068769,8068770,8068771,7072072,10273578,10247974,10247975,10247976,10247977,10247978,10247979,10932386,8565187,10248253,10248254,10248255,10248256,10248257,10248258,10248259,10248260,10248261,10248262,10248263,10248264,10248265,10248266,10248267,10274268,10248268,10248269,10274269,10274270,10248270,10248290,10248291,10248292,10248293,10248294,10248295,10248296,10274541,7073368,7073371,10248694,10932928,10932929,10274758,10274759,10274760,10196764,10274781,10248810,7073636,10274878,10274919,10274920,10274921,10274922,10222992,10222993,10222994,10222995,10222996,10222997,10222998,10222999,10223000,10223001,10223002,10223003,10223004,10223005,8910355,10285096,10285097,10285098,10285099,10285100,10285139,10285140,10194172,10194173,10285216,10285217,10285218,10285219,10285253,10285254,10285255,10285268,10285269,7071069,10285326,10285387,10285405,10285406,10285407,10285408,10285409,10285410,8861149,8908017,8908020,8908023,10943317,10943319,10943327,10943385,10943405,10943414,10231074,10231080,10283125,10283126,10283127,10944408,10231230,10231231,10231232,10231252,10231253,7069018,7069021,7069040,7069049,7069050,7069051,10231302,10231303,10231304,10231307,10231308,10231309,10231310,10231311,7069076,10283638,10283771,7069678,8072554,8072555,8072586,8072587,8072753,8072754,8072755,8072756,8072757,10941791,10941800,10941827,10941860,10941876,8073030,10941921,10941934,10941941,10941986,10942000,10284699,8907078,8860500,10284924,10284925,10284926,10284927,10284928,10284976,10433011,10229172,10229186,10928611,10928612,10229201,10229202,10281209,10216288,10216289,10216290,10216291,10216292,10216293,10216294,10216295,10216296,10216297,10216298,10216299,10216300,10216301,10216302,10216303,10216304,10216305,10216306,10216307,10216308,10216309,10216310,10216311,10216312,10216313,10216314,10216315,10216316,10216317,10216318,10229417,10229418,10229464,10229503,10229686,10229687,10229717,10229718,10229719,10229720,10229721,10229722,10229723,10229724,10229725,10229726,10229727,10229728,10229729,10229730,10229731,10229768,10229769,10229770,10229771,10229772,10229773,10229774,10229775,10229776,10229777,10216809,10433669,10216810,10216811,10216812,10216813,10216814,10216815,10216816,10216817,10216818,10216819,10216820,10216821,10216822,10216823,10216824,10216825,10216826,10216827,10216828,10216829,10216830,10216831,10230020,10217033,10230063,10230092,10230093,10230094,10230095,10230096,10230097,10230098,10230177,10230178,10230179,10230180,10230181,10230182,10204197,10204198,10230270,10230271,10230374,10230526,10230554,10230555,10217559,10217560,10217561,10217562,10217563,10217564,10217565,10217566,10217567,10217568,10217569,10217570,10217571,10230586,10230629,10230726,10230727,10230728,10230729,10230730,10230780,10230781,10230823,10217875,10217876,10217877,10230878,10217878,10217879,10217880,10217881,10217882,10217883,10217884,10217885,10217886,10217887,10217888,10217889,10217890,10217891,10217892,10217893,10230907,10230908,10230909,10204909,10230910,10204910,10230911,10204911,10230912,10204912,10230913,10230914,10230915,10230916,10230917,10230918,10204939,10230940,10204940,10204942,10204943,10204944,10204946,10204950,10230951,10204951,10204952,10204958,10204959,10204960,10204961,10204962,10204963,10204964,10204965,10204966,10204967,10621981,10432011,10922621,10922622,10922623,10617144,10617145,10617146,10617147,10228307,10228308,10228309,10228310,10228311,10228312,10228313,10228314,10228317,10215535,10432543,10215766,10215767,10215768,10215769,10215770,10215771,10215772,10215773,10215774,10215775,10215776,10215777,10202847,10928315,10928316,10215921,10215922,10215923,10215924,10215925,10215926,10213242,10620239,10620240,10620241,10620252,8570198,10200870,10930932,10621424,10621430,10621431,10621535,10621536,10201772,10201773,10201774,10201775,10922436,10922437,9205325,9205326,9205327,9197367,9197368,9197369,9197370,9197371,9197372,9197373,9197374,9197375,9197376,9165414,9165415,7059644,10559320,7059680,9213575,10614243,10614250,9213589,10614268,10559786,10559806,9206077,9198077,10559894,10559895,10559896,10559897,9166157,10560008,10560009,10560010,10560011,10560012,9206288,9179328,9179354,9179355,9179356,9179357,10560262,10560263,10560264,10560265,10612253,10560418,10560419,10560420,9171892,9171957,9171958,10560887,10560888,10560889,10560890,10560891,10560892,10560893,10560894,10560895,10560896,10560897,10560898,10560899,9172173,10561001,10561002,10561003,7058497,7058501,7058851,10558578,9196808,9196809,9196810,9196811,9196812,9196813,9196814,9196815,8863385,8863619,8863628,8863629,9181155,9197241,9197250,9193313,9185335,9185338,10515547,7055923,4974691,4974692,4974693,4974694,4974695,4974696,4974715,4974716,7056053,10517714,10517715,10517716,10517717,9185964,9186033,7056201,7056202,7056203,7056205,7056206,10513873,10513874,10513875,10513876,10513877,10513878,10513879,10513880,10513881,10513882,10513883,10513884,10513885,10513911,10513912,9186116,9186146,9186147,9186163,9186164,4975080,9186227,9186288,9186289,9186290,9186337,9186338,9186339,9186340,7056539,9186374,9186422,7056590,9186432,7056638,7056639,7056640,7056641,7056642,7056643,9170477,7056644,9170478,7056645,7056646,9170480,9170482,9170483,9170485,9170486,9170487,9170489,9170491,9186507,9186613,9186656,9178666,9186681,10516495,9186806,9186810,10516704,10516705,10516706,10514794,10516811,10516812,9203107,9203120,9179193,9179208,9179209,9179210,9179211,9179277,9179278,9179279,9179280,9179281,9176360,9176361,9176363,9176364,9176370,9176371,9176372,9176379,10419388,10419389,10419390,9184491,8918315,8918321,8918323,4973800,4973801,4973802,4973803,4973804,4973805,4973821,4973822,4973823,6666527,9198906,6666970,6666976,6666986,9199078,9175098,9191117,9191118,9191119,10465734,10465735,6667159,4972155,4972156,4972157,4972158,4972177,4972178,4972205,4972224,10469950,4972238,4972248,4972249,9175403,9175495,6667573,6667574,9175804,10468399,10468400,10468401,10468402,10468403,10468404,10468405,10468406,10468407,10468408,10468409,10468422,10470630,9192197,10628451,10628453,10628468,10174099,10174137,10176554,10625214,10173360,10173361,10580525,10566134,10587397,10587398,10587400,10587401,10587402,10587403,10587404,10587405,10566584,10566585,10566586,10566587,10566588,10566589,10566590,10566591,10566647,10566648,10531137,10531138,10531139,10531140,10531141,10531142,10531143,10531144,10531145,10531146,10531147,10531148,10531149,10531150,10531151,10531152,10527385,10531431,10531547,10529705,10529706,10523740,10523741,10531778,10523779,10531779,10523780,10531780,10523781,10523782,10523783,10523784,10529916,10519954,10519955,10519956,10519957,10519958,10531959,10519959,10531960,10531961,10531962,10531963,10531964,10532009,10532010,10532011,10532012,10530060,10530061,10530078,10532088,10532089,10532090,10534253,10534254,10534255,10534256,10534257,10522274,10522275,10522276,10522277,10522278,10522279,10532346,10532347,10522395,10530411,10530412,10530419,10530420,10530438,10530439,10530484,10528521,10528522,10528523,10528524,10528525,10532535,10532536,10532710,10532731,10532732,10532733,10532734,10530762,10530763,10530764,10530765,10530832,10530833,10530834,10530835,10530836,10530837,10530838,10530839,10530840,10522868,10522869,10522870,10522871,10522872,10522873,10522874,10522875,10522876,10522877,10522878,10522879,10522880,10522881,10522882,10522883,10522884,10532885,10522885,10522886,10532914,10532915,10530956,10530972,10530991,10530992,10530993,10530994,10531044,10425272,10425285,10425304,10425321,10420321,10425322,10422077,10422107,10421110,10421111,10421112,10421120,10422129,10473056,10473103,10473937,10474009,10480045,10480046,10480047,10480168,10480169,10480170,10480171,10480172,10480173,10480183,10480184,10480185,10480186,10480187,10480188,10480189,10480190,10480210,10480223,10480233,10480234,10480235,10480240,10480250,10480251,10480252,10480507,10480509,10480510,10480520,10480521,10480522,10480525,10480526,10480527,10480530,10480546,10480547,10480548,10480549,10480550,10480552,10480554,10480555,10480556,10480557,10480559,10480563,10480571) 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'