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(8569574,10950788,7066355,10847149,8575932,7074859,4969294,4969295,4969296,4969297,10988024,8617829,10931559,10843040,10843041,10843042,10843043,8911450,10843310,8595362,10867277,8836759,8560238,8560387,3927739,10943061,11049409,10102865,8614796,10996276,10996281,10996425,10996426,11035958,11035959,10864798,3237008,3237009,3927095,3927096,3927097,3927098,10853730,3234477,10925130,10925131,10925132,10925133,10925134,10925135,8907725,8541603,10850486,10926021,10926336,10616522,8611551,9165461,9165462,9165463,9165464,9165465,9165466,9165467,9165468,9165469,9165470,9165471,9165472,9165473,9165474,9165475,9165476,9165477,9165478,9165479,9165480,9165481,9165482,9165483,9165484,9165485,9165486,9165487,9165488,9165489,9165490,9165491,9165492,9165493,9165494,9165495,9165496,9165497,9189498,9165498,9165499,9165500,10611164,9165501,9165502,9165503,9165504,9165505,9165506,9165507,9165508,9165509,9165510,9165511,9165512,9165513,9165514,9165515,9165516,9165517,9165518,9165519,9165520,9165521,9165522,9165523,9165524,9165525,9165526,9165527,9165528,9165529,9165530,9165531,10122135,10122136,10122137,10122138,9166114,10611807,7057470,7057471,9211389,10609394,10557868,9196221,9196222,3653436,8852901,8849815,8849858,8849859,8849860,9186165,9186166,9186167,9186168,9186169,8850049,10125335,10420104,10418120,6666298,6666299,6666300,6666301,9207871,9207872,9207873,9207876,9207879,9207881,9207882,9208040,9208046,10903678,10159699,10904153,10909966,10909967,10910501,10630103,10162383,10162384,10162385,10162386,10162387,10162388,10162389,10172792,10602191,10653395,10647817,10647818,10647819,10647820,10606952,10606953,10606954,10606955,10606956,10606957,10606958,10606959,10606960,10606961,10606962,10606963,10606964,10606987,10607539,10545754,10545802,10546121,10546122,10544473,10544474,10531001,10531002,10531003,10531004,10531005,10531006,10531007,10531008,10409748,10494900,10494902,10494903) 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>