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(8569823,8569824,8569825,8569826,8569827,8569828,8569829,10940507,8569879,8569882,7066334,10847330,10437566,8632496,8632503,10498049,10498050,10498051,10498052,10498053,10498054,10498055,10498056,10498085,10498086,10498087,10498088,10498089,10498090,10498097,10498098,10498099,8591544,8591545,8591546,8591547,8068464,8068465,8068466,8068467,8068472,8068491,8068492,8620640,8835498,10104058,8066465,8066466,8066467,8066487,8066488,10932940,10942777,8626997,11037114,11037115,11037116,3927902,4430166,10842369,10842371,7068977,7068978,7068979,7068980,7069010,8555992,8564806,7070858,10837717,8906867,8613788,8613789,3924442,3924443,10838816,8541543,10992876,8541811,8541812,8541813,8541816,8541817,8542111,8542149,10993599,10993600,10993601,10993602,3581988,8540714,10979051,10979052,10979053,10979054,10426855,10426856,8541093,8541094,8541095,8541116,8541141,8541253,8577960,8577972,10922450,9205332,9205333,9205334,9166138,9166141,9166145,9166146,9214182,10120422,10120423,6676466,8567249,8567250,8567251,8863482,8863483,8863484,8863485,3654171,8863486,3654172,8863487,3654173,8863488,3654174,8863489,3654175,3654176,3654177,8863493,8863494,8863504,8863505,8863506,8863507,8863508,8863509,8863515,10513398,4974703,4974704,4974730,4974731,4974732,4974733,9169921,10126211,10126218,10126219,9170161,9170171,9170172,7056493,7056494,9170627,9170628,9170629,9170630,9170631,9170632,9170640,9179065,9179066,9179067,9179095,9179096,9179097,9179098,9179099,9179100,10124775,6681072,6681073,9209148,8568870,8568871,8568910,8568911,8568912,10471565,9175058,9175059,4972113,4972117,4972123,9183473,9183474,8550937,8550938,8593824,8593834,8593835,8593836,8593837,8593838,10884135,10884136,8069019,8069020,8069026,8069027,8069028,8069031,8069032,8069035,8069130,8069131,8069133,8069136,10897772,10897773,10897780,10897781,10897798,10184094,10184095,10184096,10184097,10949347,10949348,10949349,10949350,10949351,10949352,10949353,10949354,10949355,10949356,10949357,10949358,10949359,10949376,10949377,10949378,10580335,10580336,8562366,8562367,10473721,10479949,10479950,10714931) 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>