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(8559475,8559476,3899594,8560283,8067948,8617860,3235945,7073126,3233878,3233998,3924234,8555270,8540856,8540857,3231764,8540858,8540871,10864834,10864835,8611425,10282807,10862987,10845914,6677536,6677537,6677538,6677539,6677540,6677541,6677542,6677543,6677544,6677545,6677546,6677547,6677548,6677549,6677550,6677551,6677552,6677553,6677554,6677555,6677556,6677557,6677558,6677559,6677560,6677561,6677562,6677563,6677564,6677565,6677566,6677567,6677568,6677569,6677570,6677571,6677572,6677573,6677574,6677575,6677576,6677577,6677578,6677579,6677580,6677581,6677582,6677583,6677584,6677585,6677586,6677587,6677588,6677589,6677590,6677591,6677592,6677593,6677594,6677595,6677596,6677597,6677598,6677599,6677600,6677601,6677602,6677603,6677604,6677605,6677606,6677607,6677608,6677609,6677610,6677611,6677612,6677613,10940025,10565878,10565879,10565880,10565881,10565882,10565883,10565884,10565885,10565886,10565887,10565888,10565889,10565890,10565891,10565892,7023537,8066146,10516685,10516686,9171144,9171148,10418156,10418157,10124090,10124091,10874927,10156164,10156635,10891356,10157713,10545803,10545804,10549980,10549981,10549982,10508537,10507599,10507600,10507601,10507602,10507603,10507604,10480990,10478343) 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>