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(10950370,10950372,9215785,10849661,10844963,10845420,9214343,10962407,10962408,10845573,10930138,7073438,7073720,10102075,11010700,11010701,11010702,11010703,8910590,10866202,11011609,10864067,10996557,10101306,10101558,7156543,10928685,10928686,10928687,10928688,10928689,10928690,10928691,10928692,10928693,10928694,10928695,10618284,10968247,8554591,8907103,10981926,10839439,10839640,8541471,8611880,8541653,10928193,10928194,10620098,10848035,10848036,10848037,10848038,10848039,10848040,10848041,10848042,10850680,10991533,10991534,10991535,10991536,10991537,10991538,10991539,10991540,10991554,8540618,9217879,9217880,8541152,10851987,10851988,10851989,10851990,10851991,10851992,10851993,10851994,10851995,8904782,9189556,9197762,9197763,9197775,9197776,9197777,8864514,9171408,9195919,9195958,9172010,9172011,9172012,9172013,9172014,9212107,10609839,9188212,7058447,7058543,9188528,9188529,9189165,9189166,9189287,9189288,9193548,9185601,9185633,9161754,9193847,10517673,10517674,10517675,9170390,9162419,6674800,6674803,7056924,9187293,10419311,9168495,10116695,10417444,9174841,9199021,9175137,8916886,9199336,9175955,9175956,9176290,10628540,10879846,10879847,10905288,10948421,10910880,10910881,10891236,10876666,10912141,10912142,10601379,10583485,10583486,10583548,10606743,10606744,10606745,10606746,10606747,10606748,10590991,10648834,10529875,10524075,10524076,10522398,10522515,10522516,10538725,10510154,10510155,10510418,10510419,10510420,10510421,10507491,10507492,10509503,10509527,10510544,10510545,10510546,10510547,10510605,10509654,10509817,10509849,10509850,10509851,10509852,10509870,10509871,10509874,10509911,10509937,10509938,10413683,10407942,10408662,10408663,10408664,10408665,10408666,10408667,10408668,10408669,10408670,10407209) 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'