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(10858789,10858790,10858791,10858792,10858794,10858795,10858798,10858799,10858801,10858802,10858803,10858805,10858806,10858807,10858808,10859175,10859177,10859178,10859179,10859180,10859181,10859183,10859184,10859185,10859186,10859187,10856081,10856082,7200179,7200536,10855416,10855439,10866396,10866398,10866400,10866401,10866403,10866404,10866405,10866406,10866407,10866408,10866409,10866410,10866411,10866412,10866413,10866414,10866415,10866416,10866417,10866418,10866419,10866453,10866454,10866455,10866456,10866457,10866458,10866459,10866460,10866461,10866462,10866463,10866464,10866465,10866466,8906871,8906872,8860328,8860360,8860361,8860362,8860448,8860449,10190092,10425932,10851968,10615987,8631548,10862271,10862281,10862298,10862623,10614772,10614779,10614781,10614782,10614783,10614784,10614791,10614795,10614801,10614804,10614805,10614806,10614808,10614813,10614815,10614858,10614859,10612342,10612408,10612409,10612410,10612500,10612521,10612522,10612523,10612542,10612546,10612559,10612562,10612624,10612650,10612657,10612675,10612877,10612878,8852321,9912876,9912878,10419398,10419399,10419403,10419427,10419428,10419429,10419430,10419431,10419432,10419433,10419434,10419435,10419436,10469695,10469697,10469700,10469703,10469708,10469711,10469715,10469717,10469721,10469724,10469727,10469731,10469734,10469736,10469738,10469741,10469748,10469749,10469754,10469757,10469760,10469764,10469773,10469778,10469781,10469784,10469789,10469792,10469795,10469798,10469801,10469804,10469808,10469811,10469814,10469818,10469821,10469827,10469828,10469829,10469833,10890117,10890118,10611802,10609094,10609818,10609819,10610270,10610271,10610296,10610318,10610319,10604405,10610466,10604645,10604654,10604658,10604670,10604676,10604681,10604682,10610937,10610939,10610940,10508198,10508350,10415948,10415958,10415976,10508025,10413350,10413351,10413352,10413353,10413354,10413355,10413658,10413659,10413661,10413663,10413664,10413665,10413666,10413667,10413668,10413669,10413670,10413671,10410590,10410614,10411213,10411214) 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>