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(8631821,8631900,9216085,9216086,9216087,9216089,9216090,8622508,8622602,8622647,8622648,8609691,8622757,8630324,8630325,8630326,8630357,8627889,8627890,8627891,8627892,8627893,8627894,8627895,8627896,8627897,8627898,8627899,8627900,8627901,8627902,8627903,8627904,8627905,8627906,8627907,8627908,8627909,8627910,8627911,8627912,8627913,8627914,8627915,8627916,8627917,8627918,8627919,8627920,8627921,8627922,8627923,8627924,8627925,8627926,8627927,8627928,8627929,8627930,8627931,8627932,8627933,7201589,8628353,8628354,8628355,8628356,10103964,8629101,8629102,8629103,8629104,8629105,8629106,8629107,8629461,8629462,8629473,8629474,10997793,10997794,8624593,8624749,8624750,8624751,8624752,8624753,8624754,8624755,8624756,8624757,8625444,8625445,8625446,8625447,8625448,8625449,8625450,8625451,8625452,8625453,8625454,8625455,8625485,8625486,8625487,8625488,8070064,8070080,8070116,8624326,8624327,8624328,8624329,8624330,8624331,8624332,8624333,8624334,8624335,8624336,8624337,8624338,8624339,8634919,8634924,8634925,8634939,8634940,8579013,8579014,8579015,8579016,8632751,8632752,8632753,8632754,8632755,8632756,8632757,8632758,8632759,8632760,8632761,8632762,8632763,10848267,10848302,8633449,8633450,8633451,8633452,8633453,8633454,8633455,8633456,8633457,8633458,8633459,8633460,8633461,8633462,8633463,8633464,8633465,8633466,8633467,8633468,8633469,8633470,8633471,8633472,8633473,8633474,8633475,8633476,8633477,8633478,8633479,8633480,8633481,8633482,8633483,8633484,8633485,8633486,8633487,8633488,8633489,8633490,8633491,8633492,8633493,8633494,8633495,8633496,8633497,8633498,8633499,8633509,8633510,8633511,8633512,8633513,8633514,8633515,8633516,8633517,8633518,8633519,8633520,8633521,8633522,8633523,8633524,8633525,8633526,8633527,8633528,8633529,8633530,8633531,8633532,8633533,8633534,8633535,8633536,8633537,8633538,8633539,8633540,8577880,8565887,8566900,8566901,8566902,8566903,3653630,9915163,9913456,9911296,9911360,9911367,9191534,10631894,10631896,10631897,10631898,10631899,10631900,10631901,10631902,10631903,10631904,10631905,10631906,10631907,10631908,10522597) 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>