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(7076041,9214991,10963244,10963245,10963246,10963424,10963425,10963426,10963468,9215874,9215893,9215894,10849587,10849588,10871608,10951051,10951083,10951084,10850052,10872236,8573455,8573463,8561321,8561322,11001090,11001091,7067743,7067744,9214420,8627617,8627618,8627619,8627620,8627621,8627622,8627623,8627624,8627629,8627634,10842930,11012030,11012031,11012141,11012142,11012143,11012144,11012145,10866783,10866784,7064531,7201790,10843405,3899397,8065932,8065933,10843724,8065973,10867579,10867632,10867646,10867647,8596067,10104611,10859796,10932949,10932950,10844404,3237370,3237371,11010646,7071093,10997807,10997835,10997836,8558222,4430238,10866194,10866208,10995650,10995654,10995655,10839796,10839797,10839798,10863691,8615456,10996397,10840514,10864160,10941688,10864417,8565000,8557297,11048463,8557583,7070730,10857042,7070756,8073491,11010589,11010590,3233383,3233384,3233385,3233386,11032954,11032955,10618300,10618301,10618321,11046008,11046009,11033123,11033124,11007126,11007127,11007128,11007129,11007130,11007131,11007132,3233902,10968248,10618612,11033307,3234048,3234049,3234050,3234051,10618669,10618670,10618671,10618672,10618673,10618674,10618675,10618676,10618677,10618678,3234074,3234075,3234076,3234077,3234078,3234079,3234080,3234081,3234082,3234083,10618857,10618865,10618866,10618867,10618868,10618869,10618870,10618871,10618915,10618916,10618917,10618918,10619006,10619007,10619008,10619009,10619010,10619011,10619012,10619013,10619014,10619015,10619016,10619017,10995118,3235017,10839517,8614702,11008594,8541455,8541456,8541457,11044768,11044769,11044770,8612086,8612116,8542045,10928109,11045470,11045471,8542311,3233335,3233336,3233345,3233349,3233350,10847967,11004089,11004090,3231165,10965456,10991459,10991461,10991462,10991463,10991464,10991465,10991466,10991467,10991483,10991484,10991485,10930826,8540440,10616017,11005101,11005102,8577612,8540992,8577715,8577716,8541153,8541247,7155404,9189649,9189736,9189737,9173798,9173877,10559735,10559736,10559737,6678156,6678157,6678158,6678159,6678160,9214062,8864649,8864650,8864687,9187450,9187490,9195939,9195982,8851922,9212114,9188214,9188215,9188216,9188279,8566848,10613085,9188515,9188516,9188530,9188543,9188556,9188569,9188584,9204768,9204770,9172771,9172831,9915115,9189016,9189019,9915244,9189051,8863615,8852959,8852988,6677372,9189227,9189230,9189231,9189237,9189238,9189242,9189243,9189249,9189255,9189279,9189280,9189290,9185576,9185577,9185578,9185602,9161764,9186165,9162415,10516614,10516615,10516616,10516617,10516618,10119144,10119149,10119162,10119163,10516875,10516876,9913280,10513031,10513032,10513033,10513034,10513035,10513036,10119481,10119482,10419317,10428030,10419641,10419642,10419643,10419644,10419645,10417728,9168815,9193224,10417163,4974117,10122568,6666626,9190650,9190660,9190661,9190662,9190663,9190664,6666869,8854735,9198985,9198992,9198993,9917214,9199058,8854884,8854885,8550342,9175426,9175448,9175450,9175455,10115663,9175552,6671918,10462294,9175757,9183802,9199905,9168107,9176291,10893589,10893590,10893591,10628088,10628844,10905214,10905289,10632088,10627728,10177118,10901434,10891617,10891644,10891645,10891672,10891673,10891674,10891675,10891676,10891677,10891678,10891679,10949850,10173112,10163246,10163254,10163273,10907440,10907441,10646184,10601147,10601148,10601149,10601154,10601155,10568558,10652865,10589972,10589973,10589974,10589975,10589976,10589977,10589978,10589979,10589980,10589981,10589982,10589983,10589984,10589985,10589986,10589987,10589988,10589989,10589990,10589991,10589992,10589993,10589994,10589995,10589996,10589997,10589998,10589999,10590000,10590001,10590121,10590122,10590123,10590124,10607449,10607450,10579793,10579794,10585876,10533127,10539134,10539135,10539136,10539137,10541166,10541167,10541168,10541169,10541170,10541171,10541172,10541173,10541174,10541175,10541176,10541177,10541178,10541179,10541180,10541181,10541182,10541183,10541184,10541185,10541186,10541187,10541188,10541189,10541190,10541191,10541192,10541193,10541194,10541195,10541196,10541197,10541198,10541199,10541200,10541201,10541202,10541203,10541204,10541205,10541206,10541207,10541208,10541209,10541210,10541211,10541212,10541213,10541214,10541215,10541216,10541217,10541218,10541219,10541220,10541221,10537406,10537407,10537410,10537428,10537448,10537449,10537450,10537451,10537471,10537472,10537473,10549690,10521824,10521825,10521826,10521827,10521828,10521829,10521843,10529870,10521914,10521915,10522100,10538310,10538334,10538335,10538407,10538422,10538423,10544452,10544453,10544454,10544455,10544456,10538462,10538472,10538473,10538474,10538487,10538492,10522502,10522503,10522618,10536747,10536757,10538840,10540967,10540968,10540969,10540970,10540971,10540972,10540973,10540974,10540975,10540976,10540977,10540978,10540979,10540980,10540981,10540982,10540983,10540984,10533109,10533110,10508170,10420346,10420389,10420397,10420398,10508475,10507975,8562246,10407486,10477396,10411898,10414218,10476249,10476267,10476281,10476282,10476283,10476284,10476294,10476295,10407164) 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'