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(8583517,10860309,10860312,10860313,10860314,10860315,10860323,10860324,10860325,10860327,10860330,10860331,10860332,10860339,10860340,10860341,10860342,10860347,10860361,10860362,10860363,10860364,10860370,10860372,10860373,10860374,10860377,10860381,10860382,10860383,10860385,10860386,10860389,10860390,10860399,10860402,10860404,10860408,10860413,10860414,10860422,10860423,10860436,10860438,10860441,10860442,10860446,10860448,10860453,10860456,10860463,10860466,10860468,10860470,10860472,10860478,10860479,10860480,10860483,10860488,10860490,10860491,10860494,7201614,7201616,7201617,7201618,7202133,7202165,7202168,7202171,5654617,7198781,7198782,7198783,7198784,7198785,7198853,10101528,3923551,10838855,8905662,8905663,8905665,8905686,10616655,8851990,10613391,10613392,10613393,10613394,10613406,10613421,10613431,10613432,10613434,10613435,10613475,10613483,10613498,10613501,10613504,10613505,10613506,10613513,10613514,10613515,10613523,10613524,10613525,10613527,10613528,10613529,10613531,6673563,10117664,9911952,9912531,9912534,9912535,9912536,9912541,9912551,9168905,10469245,10885751,10885763,10885772,10885851,10885852,10885853,10885854,10885855,10885856,10647518,10647527,10414649,10414650,10414651,10414652,10414653,10414661,10414662,10414663,10414664,10414665,10414667,10414668,10414669,10414670,10414673,10414676,10414679,10414680,10414681,10414682,10414685,10414686,10414687,10414688,10414690,10414692,10414693,10414701,10414705,10414709,10414714,10414719,10414720,10414729,10414732,10414733,10414735,10414736,10414738,10414739,10414745,10414747,10414749,10414750,10414751,10414757,10414758,10414759,10414760,10414762,10414766,10414767,10414770,10414771,10414774,10414779) 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>