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(10943762,4970742,4971073,4971075,4971076,10944282,4971138,4971139,4971140,4971141,4971142,10437426,10437427,10437428,10437540,10437557,10437568,10437600,8067961,8067962,8067963,8067964,8067965,8067966,8067967,8067999,8068000,8068001,8068002,8068003,8068004,8068005,8068006,8068007,8068008,8068009,8068010,8068011,8068012,8068026,8068027,8068028,8068029,8068030,8068031,8068075,8068076,8068077,8068078,8068079,8068080,8068081,8068082,8068083,8068084,8068085,8068143,8068144,8068145,8068146,8068147,8068148,8068149,8068150,8068151,8068152,8068153,8068154,8068155,8068156,8068157,8068158,8068159,8068160,8068161,8068162,8068163,8068164,8068165,8068166,8068167,8068168,8068169,8068170,8068171,8068172,8068256,8068257,8068258,8068259,8068260,8068261,8068262,8068263,8068264,8068265,8068301,8068310,8068311,8068312,8068313,8068314,8068315,8068316,8068317,8068318,8068319,8068320,8068321,8068322,8068323,8068324,8068325,8068326,8068327,8068328,8068329,8068330,8068331,8068332,8068333,8068334,8068399,8068400,8068401,8068402,8068403,8068404,8068405,8068406,8068524,8068525,8068526,8068527,8068528,8068529,8068602,8068603,8068604,8068624,8068625,8068626,8068627,8068628,8068629,8068630,8068631,8068632,8068633,8068634,8068680,8068681,8068682,8068683,8068684,8068685,8068686,8068697,8068698,8068699,8068700,8068701,8068702,8068703,8068715,8068716,8068717,8068746,8068747,8068761,8068762,8068763,8068764,8068765,8068766,10931403,10931529,10931629,10931646,10931656,10931894,8075337,8075338,10931959,10932088,4967033,10932265,10932269,10932292,10932293,10932294,10932295,10932296,10932297,10932298,10932299,10932310,10932376,10932377,10932378,10932379,10932380,10932381,10932382,10932383,10932384,10932385,10932478,10932479,10932480,10932481,10932603,10932680,10932689,10932806,10932807,10932830,10932921,10932922,10932923,10932924,10932949,10932962,10932963,10932979,10933043,10942793,10942897,10942898,10942899,10942928,10942929,10942930,10942931,10942932,10942933,10942934,10942935,10942936,10942937,10942938,10942939,10942940,10942941,10942942,10942943,10942944,10942945,10943049,10943057,10943062,10943064,10943066,10943067,10943069,10943070,10943071,10943135,10943136,10943230,10943249,10940549,10940553,10940554,10940562,10940565,10940723,10940724,10940725,10940726,10940727,10940805,10940806,10940830,10940833,10940840,10940841,10940842,10940843,10940845,10940848,8072441,8072467,8072468,8072673,8072674,8072675,8072676,8072677,10941712,10941744,10941745,10941746,10941747,10941748,10941749,10941750,8073039,8073040,8073041,8073042,8073043,10942096,10942319,10942466,10942497,10942523,10923487,10923488,10923606,10923638,10923639,10923640,10923641,10923642,10923643,10923644,10923645,10923646,10923647,10923648,10923649,10923650,10923651,10923652,10923653,10923654,10923655,10923656,10923657,10923658,10923659,10923660,10923661,10923662,10923663,10923664,10923665,10923666,10923667,10923668,10923669,10923670,10923671,10923672,10923673,10923674,10923675,10923676,10923677,10923678,10923679,10923680,10923681,10923682,10923683,10923684,10923685,10923686,10923687,10923688,10923689,10923690,10923691,10923692,10923693,10923694,10923695,10923696,10923697,10923698,10923699,10923700,10923701,10923702,10923703,10923704,10923705,10923706,10923707,10923708,10923709,10923710,10923711,10923712,10923713,10923714,10923715,10923716,10923717,10923718,10923719,10923720,10923721,10923722,10923723,10923724,10923725,10923726,10923727,10923728,10923729,10923730,10923731,10923732,10923733,10923734,10923735,10923736,10923737,10923738,10923739,10923740,10923741,10923742,10923743,10923744,10923745,10923746,10923747,10923748,10923749,10923750,10923751,10923752,10923753,10923754,10923755,10923756,10923757,10923758,10923759,10923760,10923761,10923762,10923763,10923764,10923765,10923766,10923767,10923768,10923769,10923770,10923771,10923772,10923773,10923774,10923775,10923776,10923777,10923778,10923779,10923780,10923781,10923782,10923783,10923784,10923785,10923786,10923787,10923788,10923789,10923790,10923791,10923792,10923793,10923794,10923795,10923796,10923797,10923798,10923799,10923800,10923801,10923802,10923803,10923804,10923805,10923806,10923807,10923808,10923809,10923810,10923811,10923812,10923813,10923814,10923815,10923816,10923817,10923818,10923819,10923820,10923821,10923822,10923823,10923824,10923825,10923826,10923827,10923828,10923829,10923830,10923831,10923832,10923833,10923834,10623318,10923835,10923836,10923837,10923838,10923839,10923840,10923841,10923842,10923843,10923844,10923845,10923846,10923847,10923848,10923849,10923850,10923851,10923852,10923853,10923854,10923855,10923856,10923857,10923858,10923859,10923860,10923861,10923862,10923863,10923864,10923865,10923866,10923867,10923868,10923869,10923870,10923871,10923872,10923873,10923874,10923875,10923876,10923877,10923878,10923879,10923880,10923881,10923882,10923883,10923884,10923885,10923886,10923887,10923888,10923889,10923890,10923891,10923892,10923893,10923894,10923895,10923896,10923897,10923898,10923899,10923900,10923901,10923902,10923903,10923904,10923905,10923906,10923907,10923908,10923909,10923910,10923911,10923912,10923913,10923914,10923915,10923916,10923917,10923918,10923919,10923920,10923921,10923922,10923923,10923924,10923925,10923926,10923927,10923928,10923929,10623412,10923930,10923931,10923932,10923933,10923934,10923935,10923936,10923937,10923938,10923939,10923940,10923941,10923942,10923943,10923944,10923945,10923946,10923947,10923948,10923949,10923950,10923951,10923952,10923953,10923954,10923955,10923956,10923957,10923958,10923959,10923960,10923961,10923962,10923963,10923964,10923965,10923966,10923967,10923968,10923969,10923970,10923971,10923972,10923973,10923974,10923975,10923976,10923977,10923978,10923979,10923980,10923981,10923982,10923983,10923984,10923985,10923986,10923987,10923988,10923989,10923990,10923991,10923992,10923993,10923994,10923995,10923996,10923997,10923998,10923999,10924000,10924001,10924002,10924003,10924004,10924005,10924006,10924007,10924008,10924009,10924010,10924011,10924012,10924013,10924014,10924015,10924016,10924017,10924018,10924019,10924020,10924021,10924022,10924023,10924024,10924025,10924026,10924027,10924028,10924029,10924030,10924031,10924032,10924033,10924034,10924035,10924036,10924037,10924038,10924039,10924040,10924041,10924042,10924043,10924044,10924045,10924046,10924047,10924048,10924049,10924050,10924051,10924052,10924053,10924054,10924055,10924056,10924057,10924058,10924059,10924060,10924061,10924062,10924063,10924064,10924065,10924066,10924067,10924068,10621977,10621983,10621990,10621991,10621992,10621993,10621994,10621995,10621996,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622008,10622009,10622010,10622011,10622196,10622360,10622361,10622362,10622363,10622364,10622365,10622366,10622367,10622368,10622525,10622526,10619965,10620030,10620031,10620032,10620372,10620373,10620374,10620375,10620376,10620377,10620378,10620411,10620412,10620413,10620654,10620655,10620656,10620657,10620658,10620659,10620660,10621120,10621147,10621148,10621149,10621151,10621152,10621230,10621231,10621232,10621233,10621234,10621235,10621236,10621237,10621238,10621239,10621240,10621241,10621242,10621243,10621244,10621245,10621246,10621258,10621259,10621260,10621261,10621264,10621267,10621268,10621281,10621286,10621292,10621293,10621305,10621306,10621307,10621308,10621309,10621325,10621326,10621327,10621328,10621329,10621330,10621331,10621332,10621333,10621334,10621335,10621336,10621337,10621338,10621339,10621386,10621387,10621388,10621427,10621428,10621429,10621436,10621437,10621438,10621445,10621446,10621447,10621448,10621449,10621450,10621451,10621452,10621493,10621494,10621495,10621496,10621500,10621501,10621529,10621530,10621531,10621532,10621533,10621567,10621568,10621571,10621573,10621574,10621576,10621577,10621581,10621582,10621621,10621622,10621623,10621624,10621625,10621634,10621635,10621636,10621646,10621658,10621659,10621660,10621661,10621662,10621663,10621664,10621665,10621666,10621692,10621693,10621694,10621705,10621706,10621707,10621708,10621709,10621710,10621711,10621712,10621713,10621714,10621715,10621745,10565145,10565316,10565317,10565320,10565321,10565875,10565876,10565931,10565932,10565954,10565955,10565956,10566014,10566059,10566066,10566067,10566068,10566069,10566070,10563517,10564770,10564771,10564772,10564773,10517311,10517312,10517680,10517681,10517682,10517683,10517684,10517725,10517726,10517727,10517728,10517729,10517730,10517731,10517732,10517733,10517734,10517735,10517736,10517737,10517738,10517739,10517740,10517741,10517742,10517743,10517744,10517745,10517746,10517747,10517748,10518075,10518992,10518993,10519082,10519083,10519084,10519085,10519086,10519087,10519088,10419304,10419305,10420143,10420147,10420157,10420158,10420175,10420192,10420204,10471566,10470078) 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'