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(8569665,10950943,10847434,10847435,10847436,10847439,10847440,8560891,8560897,7201185,7201688,7201894,7201895,7201896,7201897,7201898,10844486,7200617,8910568,8910569,8910570,8910571,8910572,8910573,10943255,10943256,10842653,7201171,10100074,10100075,10839970,10839972,10839978,10839979,10839991,10840245,10840246,10841195,8557588,3924294,3924911,10839652,10622927,10622928,10622929,10622930,10622931,10622932,10951624,10951924,8633269,9189724,9189725,9189726,9189735,8864462,10611830,10611831,10611832,10611833,10611834,10611835,10612272,8862501,9171979,9196355,9196356,9196357,9196358,9196359,9196360,9196361,9196362,9196363,3653660,3653664,3653665,3653666,10558297,10558298,10558299,10558300,10610310,10610311,10610312,9173206,9173207,9169655,9168511,9208726,6666675,6666676,6666677,6666678,6666679,6666680,6666681,6666688,6666689,6666690,6666691,6666692,6666693,6666694,6678965,6678966,9208094,9208095,9160267,10628149,10628150,10174928,10174929,10910023,10910024,10171816,10891891,10626719,10608389,10585703) 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'