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,8583759,8583760,10862690,8619927,7075821,7064307,11038098,8559765,7065208,8066204,10102383,10102387,10102388,8556369,3656652,11035916,11035917,11010294,11010297,11032907,8906485,8906486,8906487,8906489,11033508,11033509,8613752,7197599,7158063,7158064,7158065,7158069,10617193,8553599,10951990,3581874,10426151,10978644,10978645,8904401,8904402,8577701,8611412,10621717,10621718,10621719,10621720,10621721,10621958,8853239,9189909,10611657,10611658,10611660,10611661,8862021,8851522,8851525,8851526,8851529,8851532,8851533,8851534,8851538,6676385,6676386,6676387,6676580,6676581,10120573,6676582,6676583,6676584,6676585,6676586,6676587,9914662,9914663,9914664,9914665,9914666,10613164,10613165,9164983,7059288,10613840,10117522,8849286,8849290,8849291,8849293,8849300,8849830,8849871,8849872,7056473,9178688,9178690,9160341,8848187,8848188,10116590,9208811,8848902,8848903,8848904,8848913,8848917,9193261,9207046,8847328,10470095,8847604,10883654,10898714,10898715,10898716,10898717,10898718,10169911,10169912,10169913,10169914,10169915,10169916,10169917,10169918,10169919,10169920,10169921,10169922,10169923,10169924,10169926,10169927,10169928,10169929,10884509,10879899,10875007,10877612,10877613,10877614,10877615,10877616,10883058,10883112,10888242,10888243,10888244,10168142,10168143,10168144,10168145,10168149,10168150,10168151,10168152,10168153,10168156,10168157,10168158,10168160,10168161,10168162,10168163,10168164,10168165,10168166,10168168,10168169,10168170,10168171,10168172,10168173,10168174,10168175,10168176,10168177,10602046,10602165,10602166,10649581,10649582,10649583,10602661,10602663,10602679,10602680,10602721,10602731,10607566,10604708,10509275,10481246,10481247,10481248,10481249,10481250,10479560,10479561,10479562) 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'