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(7067854,7076067,7076101,4970450,7068138,7068139,7068140,7068141,7068142,7068143,7068144,7068145,7068146,7068147,7076147,7068148,7068149,7068150,7068151,7068152,7068153,7068154,7068155,7068156,7068157,7068158,10198413,10198414,10198415,10198416,10943723,7068261,7068262,7068263,7068264,7068265,7068266,7068267,7068268,7068269,7068270,7068271,7068272,7068273,10198512,7068274,7068275,7068276,7068277,7068278,7068279,7068280,7068281,4970738,4970858,10198765,4970873,4970874,4970893,4970894,4970895,4970896,4970897,4970898,4970899,4970900,4970901,4970902,4970903,4970904,4970905,4970906,4970907,4970908,4970909,4970910,4970911,4970912,4970913,4970914,4970915,10198909,10198910,10198911,10198912,10198913,10198914,10198915,10198916,8569654,10198917,10198918,10198919,10198920,10198921,10198922,10198923,10198924,10198925,10198926,10198927,10198928,10198929,10198930,10198931,10198932,10198933,10198934,10198935,10198936,10198937,10198938,10198939,10198940,10944271,10944281,10944285,8569752,8569753,4971144,4971145,4971146,4971147,4971148,4971149,4971150,4971151,7073980,7074047,7074151,10199397,10199398,10199399,10199400,10199401,10199402,10437205,10199500,10199501,7066389,10437351,10437398,7074493,7074511,7074613,10199858,7074623,7074633,10437584,7074784,10437746,7074831,7066853,7066854,7066885,7066896,4969282,4969283,4969284,7074961,7074962,7066988,8067978,8067979,8067980,8067981,8067982,10197267,10197371,10197372,10197383,10197384,10197385,10197386,10197387,10197421,10197422,10197423,10197424,10197425,10197426,10197427,10197428,7067238,7067239,7067246,7075258,10197501,7067264,7067271,7067299,10197559,10197560,10197561,10197562,10197563,10197569,10197570,10197571,10197572,10197573,10197574,10197575,10197576,10197577,10197578,10197623,10197624,10197625,10197632,10197733,10197831,7075622,7067740,7071967,7071968,7064076,7072089,7072090,7072091,7072149,10931634,7064200,7064201,7064202,7064203,7064204,7064205,7064206,7064207,7064208,7064209,7064210,7064211,7072212,7072213,10931851,7072481,7072488,7072557,7072589,10932047,10932097,7072661,10932102,10932103,7072664,7072696,7072697,10932139,10932167,7072747,7072751,7072756,7072791,10196067,10932599,10932644,10932645,10932646,10932649,10196476,10932686,10932693,10932694,10932737,10932846,10932944,7073585,7073588,10933042,7073669,10942561,8861035,8861036,8861037,7071155,7071204,7071205,7071206,7071207,7071208,7071209,7071210,7071211,10942970,10942971,10943140,10943147,10943152,10943180,7071529,8861481,10194916,7071692,7071699,7071760,7071761,10931202,8071710,8071775,8071840,8071905,8071970,8072035,10944706,8072100,8072165,10944841,7069363,8072230,10944923,8072306,10944985,10945023,10941327,8072592,8072602,8072612,8072618,8072625,8072635,8072658,8072659,8072660,8072661,8072662,8072833,8072834,8072835,8072836,8072837,8072838,8072839,8072840,7070092,8073097,10942066,10942067,10942068,10942069,10942070,10942071,10942072,8860343,8860390,10942256,10942257,8860483,10942309,8860503,8860504,8860505,8860558,8860561,8860563,8860565,10617999,10618000,10618001,10618019,10190133,10923581,10923630,10618248,10618249,10623315,10923843,10923844,10923845,10623409,10618453,10618454,10618455,10618456,10618457,10618458,10618459,10618460,10618461,10618462,10618463,10618464,10618465,10618466,10618467,10618468,10618469,10618470,10618471,10618472,10618473,10618474,10618475,10618476,10623507,10190612,10924071,10924072,10924073,10924074,10924075,10924076,10618828,10618829,10618884,10618885,10618886,10618887,10618888,10924448,10924449,10924450,10924451,10924452,10924453,10924454,10924455,10924456,10924457,10924458,10924459,10924460,10924461,10924462,10924463,10924464,10924465,10924466,10924467,10924771,10619337,10619338,10619339,10619340,10619341,10619342,10619343,10619344,10619347,8071077,8071108,8071109,8071110,8071111,8071285,10624583,8071297,8071371,8071376,8071377,8071405,8071434,8071455,8071497,8071502,8071509,8071580,8071645,10617035,10922615,10922686,10622283,10622284,10622285,10622286,10622287,10622288,10622289,10622290,10622291,10622292,10622293,10622294,10622295,10622296,10622297,10622298,10622299,10622300,10622301,10622302,10622303,10622304,10927926,10927927,10927928,10617486,10617488,10617497,10617498,10617499,10617500,10617502,10617503,10617504,10617505,10928208,8569827,10620108,10615178,8570030,8570031,8570034,8570035,8570036,10615222,10920742,10920743,10920744,8570151,10620338,10920852,10920853,10920854,10615393,10920913,10920958,10920959,10920960,8570295,8570338,10921039,10921040,10921041,10926096,10615599,10615625,10926160,10926173,10615668,10926185,10926200,10926201,10921235,10921236,10921237,10921238,10926243,10921254,10921255,10926280,10921336,10615827,10921337,10921338,10930646,10930844,10930845,10930846,10930853,10930892,10930949,10921649,10921650,10921651,10930971,10921725,10921726,10921727,10921728,10188356,10921780,10921781,10921782,10921783,10921784,10921785,10921786,10921787,10921788,10921789,10921790,10921791,10921792,10921793,10921794,10921795,10921878,10921879,10921880,10921881,10921882,10188572,10188573,10922091,10922093,10188687,10188834,10188835,10188836,10188837,10188838,10188839,10188840,10188841,10188842,10188843,10188844,10188845,10188846,10188847,10188848,10616859,10616860,10616955,10565349,10614247,10614575,10614710,8864589,10566067,10566068,10566069,10566070,8861897,10612059,10612082,10612083,8861968,10557310,10557311,10557312,10557313,10557314,10563384,8862130,10612277,10557475,10612344,10557503,10563540,10612520,10612524,10612525,10612551,10612659,10612675,10612841,10612907,8862839,8862853,8862859,10613060,8862945,8862983,8863031,8863041,10558459,10558460,10558461,10558462,10558463,10558464,10558465,10558480,10558481,10558482,10558483,10558484,10558485,10613336,10558486,10558487,10558488,10558489,10558490,10558491,10558492,10558493,10558494,10558495,10558496,10561525,10561526,10561553,8863317,10564618,10564619,10564620,10564621,8863357,10564650,10564651,10564652,10564703,10564704,10564705,10564706,10564707,10564708,10564709,10564710,10564711,10564758,10564759,10564760,10564761,10564762,10564763,10564764,10564765,8863536,8863538,8863554,10513149,10513203,10513204,10511214,10511215,10511216,10511217,10513217,10511218,10513218,10511234,10511236,10513248,10511252,10511253,10511373,10511379,10511380,10511381,10511382,4974428,4974429,4974432,10513402,10515544,10515545,10511548,4974671,4974672,4974675,4974681,4974682,4974683,4974824,10513822,10513828,10511850,10511879,10511880,10511881,10511882,10511883,10511884,10511885,10511886,10511887,10511888,10511889,10511890,10511891,10511892,10513907,10513908,10513917,10513983,10514013,10514014,10512069,4975170,10516201,4975270,4975271,4975272,10516292,10516293,10516384,10516385,10516386,10516388,10516389,10516390,10516391,10516392,10516393,10516394,10516395,10516396,10514562,2809395,10516624,10516625,10516626,10516686,8861634,10518976,10518977,10518978,10518979,10518980,10518981,10518982,10518990,10518991,10518992,10518993,10518994,10518995,10518996,10518997,10518998,10518999,10519000,10417296,10417297,10417298,10417300,10416302,10416303,10416304,10417331,10416343,10416348,10416351,10416352,10416353,10416354,10416355,10416369,10417509,10416555,10419577,10419578,10419579,10419580,4973580,4973581,4973589,4973590,4973597,4973598,10419671,10419672,10419703,10417733,10418759,4973735,10419821,10419822,10417103,10417104,10417131,10417132,10417133,10417134,10418160,10418161,10419207,4974144,4974145,4974146,4974147,4971152,4971153,4971154,4971155,4971156,4971157,4971158,4971159,4971160,4971161,4971162,4971163,10467104,10467122,10467136,10467143,10467146,4971609,4971610,10471488,10471489,10471560,10467633,10469720,10469721,10469722,10465739,10465740,10465741,10465742,10465743,10465744,10465745,10465746,10465747,10465773,10465774,10465775,10465778,10465779,10465782,10469797,10469798,10465798,10469799,10465855,10465878,10465879,10465886,10465892,10465893,10463905,10463915,10463916,10463917,10463918,10464041,10464045,10466313,10466314,10466315,10470316,10466316,10466317,10466320,10466337,10466338,10466339,10466377,10466393,10466399,10466400,10466425,10466426,10470479,10468818,10468819,10627971,10627972,10627980,10628047,10628048,10628049,10628106,10628107,10628108,10628109,10628110,10628111,10628112,10628113,10628114,10628115,10628330,10628696,10628923,10628924,10629506,10629507,10629508,10629509,10629510,10629511,10629512,10629900,10629910,10629911,10626968,10626969,10626970,10626971,10626972,10627105,10627106,10627107,10627108,10627109,10627110,10627111,10627112,10627205,10627413,10627550,10627552,10627573,10627758,10627959,10626117,10626118,10626119,10626444,10626535,10626536,10626537,10626538,10626539,10626540,10626541,10568566,10568567,10568568,10568610,10568611,10568612) 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'