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(9215271,9215272,9215322,10950303,10950304,8583759,8583760,8583761,8619927,11040218,7075821,7064307,8066203,8066204,7073486,10102384,10102386,10102389,10102390,10102391,11037609,8555926,11035297,3656652,11035916,11035917,11032907,11033508,11033509,8613751,8613752,8905566,10426151,10978644,10978645,8577701,10621717,10621718,10621719,10621720,10621721,10621958,10611055,8853239,6669941,9189909,10611660,8851522,8851525,8851526,8851529,8851532,6676385,6676386,6676387,6676388,6676581,10120573,6676582,10120574,6676583,6676584,6676585,6676586,6676587,9914664,9914665,9914666,10117522,8849830,8849871,8849872,9912434,7056473,7056474,9178688,9178689,9178690,9178691,9160342,8848187,8848188,8848902,8848904,9166876,10467717,10115611,10115612,10115616,8847328,8847604,10883654,10898714,10898717,10898718,10169911,10169912,10169913,10169916,10169917,10169920,10169921,10169922,10169923,10169924,10169925,10169926,10169927,10169928,10169929,10169930,10875011,10174412,10885878,10182440,10182441,10168142,10168143,10168144,10168145,10168146,10168147,10168148,10168149,10168150,10168151,10168152,10168153,10168154,10168155,10168156,10168157,10168158,10168159,10168160,10168161,10168162,10168163,10168164,10168165,10168166,10168167,10168168,10168169,10168170,10168171,10168172,10168173,10168174,10168175,10168176,10168177,10168178,10602046,10577276,10649580,10649581,10649582,10649583,10602661,10602663,10602721,10602731,10545529,10509275,10479561,10479562,10479563) 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'