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(7068040,7068094,7068221,4970670,4970675,7068495,7068498,7068521,4971081,7065834,7065836,10933337,7066106,10437271,7066344,7066348,10437521,7066784,7066825,7066882,7066883,7066884,8067931,7067408,6000119,10931548,7064197,7064198,10931826,10931828,10931829,10931830,10931834,10931836,10931837,7064733,7064735,7064760,7064761,7064771,7064822,7064856,7064863,7064878,7064892,7064911,7064912,7064926,7064947,7064977,7064983,7064984,7064985,7064986,7065004,10932955,10932957,10932959,7065557,10942605,10943257,8970230,8071680,8071685,8071689,8071693,8071696,8071697,8071698,8071699,8071700,8071701,8071715,8071724,8071731,8071737,8071738,8071745,8071750,8071754,8071758,8071761,8071762,8071763,8071764,8071765,8071766,8071780,8071789,8071796,8071802,8071803,8071810,8071815,8071819,8071824,8071826,8071827,8071828,8071829,8071830,8071831,8071845,8071854,8071861,8071867,8071868,8071875,8071880,8071884,8071888,8071891,8071892,8071893,8071894,8071895,8071896,8071910,8071919,8071926,8071932,8071933,8071940,8071945,8071949,8071953,8071956,8071957,8071958,8071959,8071960,8071961,8071975,8071984,8071991,8071997,8071998,8072005,8072010,8072014,8072018,8072021,8072022,8072023,8072024,8072025,8072026,8072040,8072049,8072056,8072062,8072063,8072070,8072075,8072079,8072083,8072086,8072087,8072088,8072089,8072090,8072091,8072105,8072114,8072121,8072127,8072128,8072135,8072140,8072144,8072148,8072151,8072152,8072153,8072154,8072155,8072156,8072170,8072179,8072186,8072192,8072193,10941057,10941060,8072200,8072205,8072209,8072213,8072216,8072217,8072218,8072219,8072220,8072221,8072235,8072244,8072251,8072257,8072258,8072265,8072270,8072274,8072278,8072281,8072282,8072283,8072284,8072285,8072286,10941262,10945101,10941689,10941734,8073171,8073209,10942100,8073293,8860345,8860346,8860347,8860559,8860635,10623063,10928652,8070168,10623481,10623482,10623492,10623493,10623508,8070234,8070314,8070319,10623711,10623712,10623724,10623725,10623726,10623727,10623728,10623729,10623730,10623769,10623770,10624134,8070909,8070910,10624552,10624553,10624632,10624633,8071514,8071523,8071533,8071539,8071540,8071547,8071552,8071556,8071560,8071563,8071564,8071565,8071566,8071567,8071568,8071569,8071585,8071594,8071601,8071607,8071608,8071615,8071620,8071624,8071628,8071631,8071632,8071633,8071634,8071635,8071636,8071650,8071659,8071666,8071672,8071673,10622217,10622224,10622225,10622235,10927886,10622431,10922949,10622441,10927987,10927988,10622508,10928029,10928301,10620081,10620108,10620117,10620118,10620208,10620297,10620298,10620301,10620303,10926128,10620718,10620783,10620784,10620785,10620786,10620787,10620788,10620789,10620790,10620921,10620922,10621036,10621037,10922210,10922211,10922212,10922213,10922214,10922215,10922216,10922217,10565144,10565155,10565158,10614048,10565319,10559332,10559333,10559384,10559385,10559386,10559396,10559426,10559609,10614496,10614499,10614500,10614502,10614503,10614504,10614548,10559704,10559705,10559706,10559710,10559712,10559715,10559716,10559717,10559722,10559723,10559724,10559725,10559726,10559743,10559744,10614857,10611969,10612013,10612025,10612050,10612104,10612105,10612135,10612381,10563565,10563566,10563570,10612909,10612916,10612936,10612940,10612941,10612987,10612988,10612989,10613133,10613135,10613147,10558298,10613148,10558299,10613149,10558300,10558303,10558304,10613172,10613214,10613220,10613221,10558453,10613334,10613341,10613369,10613391,10613394,10613434,10613498,10613529,10613547,10613565,10613733,10613736,10613750,10564989,10613882,10613883,10613884,10613885,10613886,10613887,10613888,10613889,10613890,10613891,10613892,10613893,10613894,10613895,10613896,10613897,10613898,10613899,10613900,10613901,10613902,10613903,10613904,10613905,10613906,10613907,10613908,10613909,10613910,10613911,10613912,10613913,10613914,10613915,10613916,10613917,10613918,10613919,10613920,10613921,10517143,10517144,10513373,10513377,10513378,10513379,10513380,10513554,10513555,10513619,10513620,10513622,10517803,10517804,10517807,10517808,10513975,10514015,10514017,10514037,10514038,10514090,10514091,10514092,10514093,10514364,10514408,10514409,10514410,10514411,10514412,10514413,10514414,10514415,10514416,10514417,10514418,10514419,10514420,10514421,10514422,10514423,10514424,10514425,10514426,10514427,10514428,10514429,10514430,10514431,10514432,10514433,10514434,10512530,10512562,10512563,10512564,10512565,10518655,10518656,10518657,10518658,10518659,10518660,10518661,10518662,10518663,10514666,10514667,10514668,10514669,10518673,10518674,10518675,10518676,10518677,10518678,10518679,10518680,10518681,10518697,10518700,10518702,10518708,10514833,10514834,10512852,10514964,10514965,10514966,10514967,10514968,10514969,10514970,10514971,10514976,10514980,10514983,10514986,10514987,10514988,10514989,10514992,10514993,10514994,10514995,10514996,10514997,10514998,10514999,10515000,10515001,10515002,10515010,10515013,10515019,10515020,10515021,10515022,10515028,10515029,10515030,10515031,10515032,10515039,10515040,10515041,10515042,10515043,10515044,10515047,10515048,10515049,10515050,10515051,10515052,10515053,10515054,10515059,10515072,10515087,10515088,10515089,10515090,10515091,10515092,10515093,10515094,10515095,10515096,10515097,10417223,10417225,10416255,10416256,10416257,10417296,10417297,10417298,10417300,10419307,10417318,10417319,10417320,10417321,10417322,10417323,10417324,10417325,10417326,10417327,10417331,10416348,10416349,10416350,10416351,10416352,10416353,10416354,10416355,10416356,10416357,10416358,10416359,10416360,10416361,10416362,10416363,10416369,10417394,10417395,10417396,10417397,10417398,10417399,10416400,10417400,10417401,10417402,10417406,10417407,10417408,10417410,10417411,10417412,10417413,10417414,10417415,10417416,10417417,10417418,10417419,10417420,10417421,10417422,10417423,10417424,10416429,10416430,10416431,10416432,10416434,10419455,10419468,10419471,10419472,10419473,10419477,10419479,10419480,10419483,10419484,10419485,10419486,10419487,10419488,10419489,10419490,10419493,10419494,10419495,10419496,10419497,10419499,10419500,10419501,10419502,10419504,10419505,10419506,10419507,10419509,10419510,10419511,10419512,10419515,10419516,10419517,10419518,10419519,10419522,10419523,10419524,10419525,10419526,10419527,10419528,10419529,10419530,10419531,10419532,10419533,10419534,10419535,10419536,10419537,10419555,10419680,10419690,10419704,10419721,10419724,10419726,10419728,10419730,10419732,10419736,10419737,10419741,10416806,10419807,10416810,10419818,10419821,10419822,10419888,10419890,10419891,10419892,10419893,10419898,10419907,10420043,10420044,10418048,10417053,10417054,10417055,10417057,10417058,10417059,10417060,10417061,10417062,10417063,10417064,10417065,10417066,10417067,10417068,10417069,10417070,10417071,10417073,10417074,10417075,10417076,10417078,10417079,10417080,10417081,10417082,10417083,10420084,10417084,10420085,10417085,10420086,10417086,10420087,10417087,10420090,10417091,10417092,10420093,10417093,10417094,10417096,10420097,10417097,10417098,10417100,10417102,10417103,10417104,10417105,10417107,10417108,10418109,10418110,10417110,10417112,10417116,10417119,10417120,10417121,10417122,10417124,10417126,10417128,10417130,10417131,10417132,10417133,10417134,10417135,10417136,10417137,10417138,10417139,10417140,10417141,10417142,10418143,10417143,10418144,10417144,10417145,10417147,10417149,10417150,10417151,10417152,10417153,10417156,10417157,10417159,10417212,10420218,10417218,10420219,10417219,10466954,10467069,10467070,10467093,10467101,10467103,10467104,10467111,10467112,10467116,10467117,10467122,10467125,10467136,10467143,10467146,10467147,10467149,10467152,10467153,10467154,10467156,10467157,10467158,10471171,10471173,10467174,10467408,10467435,10467436,10467439,10467457,10467458,10467459,10467474,10467475,10465681,10465686,10465687,10465700,10465707,10465712,10465737,10465738,10465771,10465772,10465773,10465774,10465775,10465777,10465778,10465779,10465781,10465782,10465785,10465786,10465787,10465790,10465791,10465793,10465797,10465798,10465801,10467803,10465803,10465806,10465807,10465812,10465814,10465815,10465820,10465842,10465843,10465844,10465848,10465849,10465852,10465853,10465855,10465857,10465861,10465875,10465876,10463877,10465878,10465879,10463883,10465884,10463884,10465885,10465886,10465891,10465892,10465893,10463903,10463904,10463905,10465908,10463911,10463912,10465913,10463913,10465914,10463915,10465916,10463916,10465917,10463917,10463918,10465920,10465921,10463926,10469950,10463997,10463998,10464041,10464045,10464047,10466211,10466214,10466232,10466240,10466313,10466314,10466315,10466316,10466317,10466320,10466326,10466328,10466336,10466337,10466338,10466339,10466344,10466346,10466347,10466349,10466350,10466354,10466358,10466359,10464427) 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'