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(11015122,11015123,10950742,8622407,10872037,10872051,11013708,11013709,11013710,11013957,10872771,10870000,8620584,10870087,11024897,8627907,8627912,8627913,8627935,10858843,11012481,10104006,7202223,7202228,8628786,8628787,8628788,8628789,11012990,8837143,8837144,8861304,8625166,8625167,8615460,3656333,3656334,3656335,3656336,8625777,8625782,8625785,8625874,8625891,10856612,10856621,10856626,10856627,10856641,10856642,10856643,10856673,10856691,10856692,10856696,10856715,10856716,8834118,8834120,10853272,10853273,10853304,8906189,10918885,10836898,10836899,11005893,11005894,11018930,11018931,11018939,11018940,11018941,11006102,11006231,11006232,8542168,11032435,11032436,3230430,10915755,10915756,10915757,10915758,10915759,10915760,10915761,10915762,10915763,10915764,10915765,10915766,10915767,10915768,10915769,11016869,11016879,11016880,11016881,11016882,11016883,11016884,11016885,11016886,10991011,10991012,10991013,10991014,10850669,10991584,10991585,8541128,8541188,10852046,10852047,9915827,6677913,9214027,9916362,8864777,10611994,9187464,10612633,7058144,7058147,6676784,7058805,10613326,10613520,10613521,10613552,9205108,9205109,9205147,9201642,9201643,9201644,9201645,9201828,10118085,10118086,10118087,9186773,9186774,9186787,9186788,6681048,8848712,9168923,8855134,6679589,6679590,6667697,6667724,6667725,10630063,10630102,10178083,10178084,10178085,10178086,10178087,10178088,10178089,10571233,10571234,10571299,10571300,10571301,10571860,10653302,10569553,10603930,10579792,10604668,10529975,10423240,10423265,10423276,10508308,10508309,10508310,10508377,10508378,10508379,10508380,10508381,10507754,10507755,10421934,10421986,10507993,10507994,10409459,10409460,10409476,10411613,10411624,10411642,10411643,10493576) 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<br>
ERROR: Unknown column 'p.products_specials' in 'order clause'<br>