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(7201310,8627879,8627880,3899092,10858996,10858997,10858998,10858999,10859000,10859001,10859002,10859003,10859004,10859005,10859006,7202655,10857565,10857566,10857567,10857568,10857569,10857570,10857571,10857572,10857573,10857574,10857575,10857576,10857577,10857578,10857579,10857580,10857581,10857582,10857583,10857584,10857585,10857586,10857587,10857588,10857589,10857590,10857591,10857592,10857593,10857594,10857595,10857596,10857597,10857598,10857599,10857600,10101493,8906737,7197960,7197961,7197962,7197963,7197964,7197965,7197966,7197967,7197968,7197969,7197970,7197971,7197972,7197973,7197974,7197975,7197976,7197977,7197978,7197979,7197980,7197981,7197982,7197983,8905339,8905340,10615371,10615859,10615860,10426255,10426256,10426257,10426258,10426259,10426260,10426261,10426262,10426263,10426264,10426265,10426266,10616537,8611333,7155267,10611705,10611706,10611707,10611764,10611801,10611802,10611803,10611804,10611805,10611806,10611807,10611808,10611809,10611810,10611811,10612203,8851577,8851578,8851579,8851580,8851581,8851582,8851583,10612952,10613024,10613025,10613026,10610361,10610415,10117840,10117841,9912043,9912044,9912045,9912046,9169972,9169973,9169974,9169975,9169976,9169977,9169978,9169979,9169980,9912197,9912198,9912207,3285786,9168459,6673153,6673154,8550016,976475,10468361,10468502,10468503,10468504,10884510,10884613,10884614,10884615,10884616,10884617,10884618,10884619,10884620,10884695,10884978,10889996,10888320,10885907,10508173,10508174,10507563,10507804,10413501,10413502,10413503,10413504,10413505,10413506,10413507,10413508,10413509,10412194,10412195,10412196,10412197,10412198,10412199,10412200,10412201,10412202,10412203,10412204,10412205,10412206,10412207,10412208,10412209,10412210,10412211,10412212,10412213,10412214,10412215,10412216,10412217,10412218,10412219,10412220,10412221,10412222,10412223,10412224,10412225,10412226,10412227,10482573,10482574,10482575,10482576,10482577,10482578,10482579,10482580) 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>