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(10870245,7075993,8630673,11001722,8630684,9214744,9214745,7068161,7068253,7068261,7068287,7068295,7068296,7068348,7068352,7068364,10846268,10940153,10940155,3228964,10976290,10940326,3229188,8631486,8631487,8066991,10976754,10976795,10976796,10976797,10976798,10976799,10976800,10976801,10976802,10976803,10976804,10868435,10849458,10849459,7066276,8632438,8632439,8632440,8632453,8632454,8632548,8632550,8632555,10987648,10987649,10987650,10987651,10987655,10987664,10987694,10987695,10987696,10987697,10987698,10987699,10987700,10987701,10987702,8629772,10987829,10987836,10987837,8620157,8573702,8573703,8573704,8573705,8573706,8573707,8573708,8573709,10870062,10870063,10870064,8574014,7075901,8574101,8574102,10972691,10972692,10972806,10972940,10986058,10973111,10986175,7072531,8836066,8836103,10867221,11012780,8066165,8066166,8628836,8628837,11012899,10928844,10971629,10971630,10971631,10971632,10102123,10971726,10971732,10102187,10971784,10984813,10971842,10971900,10971901,10971902,10971952,10971953,10971954,10972003,10972004,10972005,8617291,10972397,8617624,8617648,10959569,3925436,3925438,10940749,8908184,8908185,8908186,8908194,8908195,10969918,10969919,10969920,10969921,10969922,8556308,10970157,10970291,10970292,10970293,10970294,10970295,10970296,10970297,10970298,10970299,10970300,10941347,10941349,10856022,10864191,8625552,10970624,10970625,10970626,7070076,7070088,7070094,10983804,10983806,8625793,8625795,8625797,8625799,8625802,8625803,8625805,8625807,8625810,8625811,8625812,8625815,8625816,8625818,8625819,8625820,8625821,8625822,8625823,8625825,8625827,10983868,8625829,8625830,10983869,8625832,10983924,10970930,10971028,10971029,10971030,10971031,10971032,10971033,10841270,10841273,10841274,7070737,8073496,10971531,11045771,11045776,11045777,11045778,10618162,10853507,8613101,8613221,8613223,8613228,8613251,8613252,8613257,8613261,8613263,8613270,8613276,8613278,8613290,8554402,10968608,3924342,3924352,10968648,10968764,10968765,10968766,10968767,10968768,10968769,10968770,10968771,10968772,10968773,10968774,10968775,10968776,10968777,10968778,10968779,10968780,10968781,10968782,11046825,11046996,11046997,11047060,11047061,11047062,11047063,11047064,11047065,3924785,8555377,11047118,8907502,11047196,11047197,8555475,8555476,8555478,8555479,8555480,8555497,8555524,8555525,8555549,8555556,8555568,8555576,8555708,8555714,8555715,8555716,8555740,8541498,8541713,8612140,8542208,10993467,10993468,10993469,10993470,10993471,10993472,8542378,8542379,10425352,10425577,10920753,10920754,10620299,8632919,10620322,10951936,10850610,10620350,10850613,8633195,10848469,10930728,10991531,10991564,10991565,10991566,10991567,10991568,10991569,10921497,8633757,10426563,10426564,3231873,3231874,3231875,8541106,8541107,3232020,3232021,3232022,3232048,3232049,3232050,3232051,3232067,3232074,3232075,8853219,7059796,9213715,9213740,8853580,10611445,9213838,9213869,9213950,10122179,10611821,10611882,10611883,10611884,10611885,10611886,10611887,10611888,10611889,10611890,10611895,10611902,10611903,10611904,6666255,10611942,10119514,6675647,6675675,6675700,6675701,9913719,6675851,6675852,6675862,6675882,9913884,6675950,8851648,8851651,8851652,8851653,8851654,8851655,8851656,10557665,10120077,10120078,9211892,6676142,6676143,10609917,9188272,10609947,6676687,10120751,8567089,8567090,8863126,6676931,8863261,6676955,9180846,8853103,8853104,8863809,9177311,10517246,10517252,10517253,10517255,10515291,10517294,10517295,10515296,10515297,10515298,10515299,10515300,10515301,10515302,10515303,10515304,9185638,9185642,9185651,9177698,8592993,10126108,10126110,10126111,9186049,9186050,7056223,7056231,7056284,8850392,8850462,6674844,6674845,6674975,6675069,6675105,6675106,8850725,8850738,10514794,10514892,9211257,9211263,9184390,9184391,9184392,9184393,9168394,9184394,9184395,9184396,9184397,9184398,9184399,9184400,9184401,9176511,9176512,6672784,9176601,9176684,9176706,9176746,9176854,9176872,9176880,9176903,9176958,9176959,9176960,9176961,8848789,8848791,8848795,9193124,9193131,9193133,10420056,9193152,9193153,7055450,10463023,4971531,4971532,4971533,8854769,8854770,8854771,8854772,8854773,9183012,9199076,8550417,8550491,8847284,8847285,10470117,8847513,8847516,10116393,8848058,8848060,8848062,9184245,8848072,8848073,10883555,10883556,10883625,10903737,10165038,10165039,10165040,10165041,10165042,10165043,10165044,10165045,10165046,10894147,10884186,10894385,10894386,10894387,10165530,10165531,10165532,10165533,10165534,10165535,10165536,10165537,10894612,10899661,10894715,10894717,10899728,10899753,10894794,10894795,10894796,10894797,10894798,10170866,10171075,10627289,10164204,10164205,10164206,10164207,10164208,10164209,10164210,10164211,10164212,10166566,10166567,10166568,10166569,10166570,10166663,10166664,10166665,10166666,10166667,10166668,10166727,10166742,10166766,10166831,10166857,10885859,10885953,10167226,10167327,10896362,10630856,10901918,10901919,10901920,10163060,10902056,10902062,10183415,10649186,10649187,10649188,10649189,10649190,10649191,10649192,10649193,10649344,10649345,10649411,10601370,10649474,10602711,10602741,10650374,10590506,10590697,10590698,10603842,10604146,10601685,10521269,10521270,10523418,10523419,10523420,10523421,10523422,10523423,10523424,10523425,10523426,10523427,10521570,10521571,10521572,10521573,10521574,10521587,10549667,10549668,10549669,10549670,10549671,10549672,10549673,10549674,10549675,10549676,10549677,10549678,10549679,10549680,10549686,10529915,10529956,10529957,10529970,10532002,10532003,10534206,10524314,10524315,10524316,10528783,10528784,10538924,10529069,10508248,10508305,10505536,10505537,10505538,10508568,10508570,10508572,10506574,10506575,10506576,10508774,10507774,10508807,10421977,10421978,10421979,10507925,10477213,10481546,10481589,10481590,10481591,10481597,10481598,10481603,10481604,10481605,10481606,10481607,10481611,10714844,10478243,10493726,10409071,10493727,10493728,10478737,10478738,10478739,10493819) 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'