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(10939642,10939643,7068040,7068094,10939876,10939907,10939908,7068221,4970670,4970675,10940094,10940148,7068495,7068498,10940226,10940227,7068521,10940286,10940299,4971081,7065834,7065836,10933337,8066999,8067027,7066106,8067275,8067286,8067292,8067368,8067369,10437271,7066344,7066348,8067523,10437521,7066784,7066825,7066882,7066883,7066884,8067931,7067408,6000119,10931548,7064197,7064198,10931826,10931828,10931829,10931830,10931834,10931836,10931837,8065506,8065694,7064733,7064735,8065823,7064760,7064761,7064771,7064822,7064856,7064863,7064878,8065954,8065958,7064892,7064911,7064912,7064926,7064947,7064977,7064983,7064984,7064985,7064986,7065004,10932955,10932957,10932959,7065557,10942605,8064221,8064222,8064223,10943257,8970230,8071672,8071673,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,3655782,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,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,10610963,10610988,10610989,10565144,10565155,10565158,10611037,10614048,10565319,10559332,10559333,10611186,10559384,10559385,10559386,10559396,10559426,10611338,10611350,10559609,10611479,10614496,10614499,10614500,10614502,10614503,10614504,10611521,10611526,10611539,10611544,10614548,10611551,10559704,10611555,10559705,10559706,10559710,10559712,10611563,10559715,10559716,10559717,10611568,10611571,10559722,10559723,10559724,10559725,10559726,10611578,10559743,10559744,10611641,10611665,10611831,10614857,10611906,10611907,10611908,10611911,10611918,10611923,10611924,10611928,10611932,10611938,10611953,10611969,10612013,10612025,10609036,10612050,10612104,10612105,10612135,10609285,10609287,10609379,10612381,10563565,10563566,10563570,10612909,10612916,10609928,10609929,10612936,10612940,10612941,10609945,10612987,10612988,10612989,10610030,10610060,10610065,10613133,10613135,10613147,10613148,10558298,10558299,10613149,10558300,10558303,10558304,10613172,10613214,10613220,10613221,10558453,10610312,10613334,10613341,10610351,10613369,10613391,10613394,10610418,10613434,10610480,10610481,10613498,10613529,10613547,10613565,10613733,10613736,10613750,10610791,10564989,10613882,10613883,10613884,10613885,10613886,10613887,10613888,10613889,10613890,10613891,10613892,10613893,10613894,10610895,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,10517803,10517804,10517807,10517808,10512530,10512562,10512563,10512564,10512565,10518655,10518656,10518657,10518658,10518659,10518660,10518661,10518662,10518663,10518673,10518674,10518675,10518676,10518677,10518678,10518679,10518680,10518681,10518697,10518700,10518702,10518708,10512852,10415251,10416255,10416256,10416257,10419307,10416348,10416349,10416350,10416351,10416352,10416353,10416354,10416355,10416356,10416357,10416358,10416359,10416360,10416361,10416362,10416363,10415368,10416369,10415371,10416400,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,10415585,10415586,10415597,10415606,10415607,10415675,10419680,10419690,10419704,10419721,10419724,10419726,10415728,10419728,10419730,10419732,10415736,10419736,10419737,10419741,10416806,10419807,10416810,10419818,10419821,10419822,10415835,10415884,10419888,10419890,10419891,10419892,10419893,10419898,10419907,10420043,10420044,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,10417084,10420084,10417085,10420085,10417086,10420086,10417087,10420087,10420090,10417091,10417092,10417093,10420093,10417094,10417096,10417097,10420097,10417098,10417100,10417102,10417103,10417104,10417105,10417107,10417108,10417110,10417112,10417116,10417119,10417120,10417121,10417122,10417124,10417126,10417128,10417130,10417131,10417132,10417133,10417134,10417135,10417136,10417137,10417138,10417139,10417140,10417141,10417142,10417143,10417144,10417145,10417147,10417149,10417150,10417151,10417152,10417153,10417156,10417157,10417159,10417212,10417218,10420218,10417219,10420219,10462890,10462891,10463005,10463011,10463034,10463043,10463044,10463047,10463048,10463053,10463054,10471171,10471173,10463313,10463314,10463394,10463395,10463397,10463429,10463430,10463431,10463432,10463435,10463438,10463554,10463555,10463648,10463653,10463655,10463662,10465681,10465686,10465687,10463691,10465700,10465707,10465712,10463736,10465737,10465738,10463748,10463751,10463752,10463755,10463756,10463757,10463759,10463763,10463764,10463767,10463768,10463770,10463771,10465771,10465772,10465773,10465774,10465775,10465777,10465778,10465779,10463780,10463781,10465781,10465782,10465785,10463786,10465786,10463787,10465787,10463789,10463790,10465790,10465791,10463792,10465793,10463794,10463795,10463797,10465797,10465798,10465801,10465803,10463804,10465806,10465807,10463810,10465812,10463814,10465814,10463815,10465815,10463816,10463818,10465820,10463821,10463822,10463824,10463829,10463831,10465842,10465843,10465844,10465848,10465849,10465852,10465853,10465855,10465857,10465861,10465875,8563199,10463877,8563201,8563202,10463883,10463884,10463903,10463904,10463905,10463911,10463912,10463913,10463915,10463916,10463917,10463918,10463926,8563250,8563251,8563252,10469950,8563299,10463997,10463998,8563358,8563359,8563360,8563361,8563362,8563363,10464041,10464045,10464047,10462314,10462315,10462328,10462329,10462409,10462410,10462411,10462412,10462416,10462419,10464427,10462427,10462428,10462436,10462440,10462442,10462443,10462446,10462447,10462456,10462457,10462472,10462475,10462478,10462479,10462480,10462481,10462484,10462495,10462496,10462497,10462503,10462504,10462505,10462508,10462509,10462514,10462516,10462518,10462520,10462521,10462522,10462525,10462526,10462527,10462528,10462532,10462533,10462536,10462541,10462542,10462543,10462579,10462580,10462583,10462585,10462599,10462615,10462616,10462623,10462624,10462627,10462631,10462724,10462729,10462730) 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'