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(10848688,10459229,10849386,10849604,8583804,8583807,8583808,8583813,8583814,10849720,10849833,10849834,10460457,11001120,11001129,8595625,11010784,8627524,7069064,7069065,10841654,10841655,10841657,10841659,10841661,10841662,10841663,10841664,10980734,10980735,10980736,10980738,10980739,10980740,10980743,10980744,10980745,10980746,10980749,10980753,10980754,10980756,10980759,10980760,10980764,10980765,10980766,10980767,10980768,10980769,10980770,10980778,10980779,10980780,10980781,10980790,10980791,10980792,10980795,10980799,10980800,10980801,10980802,10980803,3924595,10994951,10617083,8541590,10852544,10852718,10460543,10850727,10850728,10850766,10850785,3582010,8541099,10852044,10852071,9211428,9179612,9179613,9179616,9179618,9179620,9179623,9179624,9179626,9179630,9179631,9179636,9179637,9179638,9179642,9179643,9179648,9179649,9179650,9179651,9179653,9179654,9179657,9179658,9179659,9179660,10120551,10120552,10564385,7056836,7056839,7056840,7056843,7056846,7056849,7056852,7056853,10515087,10515088,10116804,10123474,4972190,4972191,4972192,4972193,4972194,4972195,8550540,8550541,8855272,10898553,10898554,10898555,10898558,10898559,10898561,10898562,10898564,10898565,10898566,10898568,10898569,10898572,10169680,10169681,10169683,10169684,10889902,10588592,10588593,10588594,10588595,10588596,10588597,10588598,10588599,10588600,10588601,10541222,10521295,10521296,10521297,10521298,10521299,10521300,10521301,10521302,10521303,10521304,10521305,10521306,10407342,10407981,10480460,10480468,10480469,10480470,10480471,10406947,10406955,10406992,10407169) 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>