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(10930422,10988854,10988855,10988856,10988857,10988858,10988860,10988861,10988862,10950409,7068803,10847291,8632549,8632556,9216583,8835451,7064029,7064308,8596079,8596081,10844549,10102825,10840238,7070104,7070472,7070748,8626401,7196369,7196370,7196371,8554248,8613461,3924377,3924378,10992876,8541811,8541812,8541813,8542204,8542205,8542207,8542208,8542209,8542277,8542278,8542279,3233270,10965390,10965391,3231147,3582121,10930749,10930750,8540361,8540433,8540434,8540435,10621113,10426635,10426639,10426751,10426779,10426780,8541008,8541009,8541014,9218159,3232076,7155273,8541258,8541259,8541260,3232172,8541310,9213533,9213549,10611460,9196509,9196516,9196521,9196848,10428745,9185716,8850888,8850889,8850890,8850891,8850892,8850893,8850894,8850895,8850896,8850897,7057414,7057417,4973697,4973751,9209081,9209082,9209083,9209084,9209085,9209086,9209087,9185090,9177132,10463005,10463006,10463007,10463008,10463009,10463010,10463011,10463012,10463013,9182440,4971465,4971951,10123559,10175065,10175097,10884855,10910335,10910336,7001170,7001177,10887992,10903141,10903142,10903143,10171974,10171975,10171976,10172233,10172234,10167634,10168084,10188256,10188257,10598888,10651307,10579783,10530100,10530101,10530102,10532193,10532194,10532195,10532196,10532197,10522504,10522521,10528564,10528565,10528566,10520826,10520827,10520828,10425192,10488197,10479250,10479251,10479252,10479533,10479545,10479546) 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>