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(7065968,3229980,8626970,8626971,8626972,8626973,8626974,8626975,8626985,7200635,10101504,10101552,10856949,3237337,10618277,10618324,10838942,7197605,7197606,7197607,7197608,7197609,7197610,7197611,7197612,7197613,7197614,7197615,7197616,7197617,7197618,7197619,7197620,7197621,7197622,7197623,7197624,7197625,7197626,7197627,7197628,7197629,7197630,7197631,7197632,7197633,7197634,7197635,7197636,7197637,7197638,7197639,7197640,7197641,7197642,7197643,7197644,7197645,7197646,7197647,7197648,7197649,7197650,7197651,7197652,7197653,7197654,7197655,7197656,7197657,7197658,7197659,7197660,7197661,7197662,7197663,7197664,7197665,7197666,7197667,7197668,7197669,7197670,7197671,7197672,7197673,7197674,7197675,7197676,7197677,7197678,7197679,7197680,7197681,7197682,7197683,7197684,7197685,7197686,7197687,7197688,7197689,7197690,7197691,7197692,7197693,7197694,7197695,7197696,7197697,7197698,7197699,7197700,7197701,7197702,7197703,7197704,7197705,7197706,7197707,7197708,7197709,7197710,7197711,7197712,7197713,7197714,7197715,7197716,7197717,7197718,7197719,7197720,7197721,7197722,7197723,7197724,7197725,7197726,7197727,7197728,7197729,7197730,7197731,7197732,7197733,7197734,7197735,7197736,7197737,7197738,7197739,7197740,7197741,7197742,7197743,7197744,7197745,7197746,7197747,7197769,7197770,7197771,7197772,7197773,7197774,7197775,7197776,7197790,3235061,10617033,10617044,10615117,10615118,10615119,10615120,10615121,10615122,10615123,10615124,10615125,10615126,10615363,8633272,8633273,8633274,8633280,8633281,8633286,8633287,8633288,8633290,8633291,8633295,8633296,10611778,10609239,10609285,10610167,10610168,10613736,10610958,9169316,9169414,10118018,9169897,9210122,9210123,9178433,9168328,6672559,6673142,9169271,8549996,8550058,10469853,10884075,10884076,10889977,10889978,10889979,10889980,10889981,10889982,10889983,10885344,10885345,10887066,10588689,10522840,10505584) 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'