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(9214886,9214887,9214888,9214986,9214987,10861747,3228959,10849660,10951064,7066519,7066521,7066522,10871973,10871974,10871975,10871976,10871977,10871978,10871979,10964473,10872327,10844960,10844962,10844997,11001212,10845602,10845606,10845634,10845635,10845636,10845637,10845638,8559177,8618366,8065514,8065515,8618404,8618405,3899190,10986481,8618968,8618971,8618972,8618993,8836868,8836869,7073446,7073447,5654793,8836979,7073685,7073719,3227194,3227195,10942664,11049203,11049204,11037166,7071597,5999949,5999951,5999953,5999959,5999960,5999961,5999962,5999963,5999964,5999965,10943313,5999976,8558674,8558675,8558676,8558677,11011436,8558733,10998482,10998483,10998484,8558756,8970231,8970232,6000129,11011591,11011592,11011593,11011594,11011595,11011596,11011597,10866200,11011598,11011599,11011600,11011601,11011602,11011603,3235604,3235605,3235606,3655783,3655784,7198732,7198766,10840293,11009245,11009246,11009247,11009248,11009249,11009250,11009251,11009252,11009253,11009254,11009255,10855895,10840508,10840513,10864154,10101304,3926657,3926658,3926659,3926662,3926663,3926893,11048437,10853489,10838085,11008222,11008223,3235097,3235249,3235250,3235251,3235252,3235253,3235254,3235255,3235256,3235273,3235274,8541448,8541676,3232853,3232854,3232855,10928190,10928191,11045497,8569936,10850525,10951923,10850679,10952099,10952213,10965374,3231158,3231160,9217525,3231709,8541147,8541151,8541161,8541262,8541264,10562112,10562113,10562114,10562115,8863830,8863831,9915606,10562225,10562226,9189554,10562424,10562425,9189624,9197707,9197708,9197709,9197710,9197711,9197712,9197713,9197714,9197715,9197716,9197717,6665751,9197758,9197759,9197760,9197774,9173776,10562651,10562652,10562653,10614642,8864503,8864504,8864505,8864506,8864509,8864510,8864513,9174192,9174194,9174197,9174206,9174207,8542535,10612210,10612211,10119745,10612212,10612213,9211915,8566540,9212105,9188210,9212259,7058531,7058541,7058542,9188492,9204767,10121038,10121040,10121042,10121045,10121046,10121047,10613735,8863698,10562026,10562027,10562028,10562029,10562030,10562031,10562032,10562033,10562034,10562035,10562036,10562037,10562038,10562039,10562040,10562041,10562042,10562043,10562044,10562045,10562046,10562047,10562048,10562049,10562050,10562051,10562052,10562053,10562054,10562055,10562056,10562057,10562058,10562059,10562060,10562061,10562062,10562063,10562064,10562065,10562066,10562067,10562068,10562069,10562070,10562071,10562072,10562073,10562074,10562075,10562076,10562077,10562078,10562079,10562080,10562081,10562082,10562083,10562084,10562085,10562086,10562087,10562088,10562089,10562090,10562091,10562092,10562093,10562094,10562095,10562096,10562097,10562098,10562099,10562100,10562101,10562102,10562103,10562104,10562105,10562106,10562107,10562108,10562109,10562110,10562111,9193547,9185582,9185583,9185584,9185585,9161752,8592966,8592967,7056172,10515908,10516140,10516141,9170376,9170387,10518616,10512848,10512849,10512850,10512851,10419309,10415604,10415605,10117035,10428310,9182559,6666829,9174887,9175100,9175101,10123648,10123649,10123650,10123651,10123652,10123653,10123654,10123703,10123861,10123862,10123863,10123864,10123865,9175937,8917705,976162,10888711,10893748,10628529,10628530,10884089,10170160,10628841,10628910,10628966,10628967,10628968,10885076,10171209,10880215,10880216,10892517,10163998,10176630,10176631,10176632,10900698,10900699,10176735,10910854,10910855,10910856,10910857,10910877,10172280,10172281,10901461,10912009,10912010,10912011,10912012,10912132,10912133,10912134,10912135,10877222,10652399,10652400,10586597,10652675,10590863,10590864,10591132,10567665,10567666,10567667,10567668,10567669,10567670,10525223,10529874,10527958,10527959,10528020,10528021,10528022,10528023,10528024,10528025,10528026,10528027,10528028,10528029,10528030,10528031,10528032,10528033,10528034,10528035,10528036,10528037,10528038,10522390,10528910,10520927,10520928,10520929,10520930,10510146,10508281,10508282,10508283,10508284,10508285,10423407,10508336,10508337,10423473,10510414,10510415,10508472,10510528,10510529,10510530,10510531,10510532,10510533,10510534,10510535,10510536,10510537,10509606,10509805,10509869,10509881,10509902,10509903,10509904,10509905,10509906,10509907,10509908,10509909,10509910,10423211,10423212,10423213,8562305,8562320,10477119,10477120,10407831,8563133,10715118,10480862,10407208) 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'