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(8630784,10861587,3228908,10950646,10849389,8631829,8631831,10862665,10849985,10860105,10860106,10860109,10860551,10861051,8594641,8594651,8595143,10858850,10859288,10859318,10859327,10859394,10859428,10860049,10860050,10860051,10860094,10860095,10865154,10865178,10857668,8627233,8627236,8627257,8627273,8627282,10865945,10866050,8624758,8624759,8624760,8624763,7198525,8625241,8625242,8625374,8625375,10864152,7199669,7199670,7199671,7199672,7199673,7199704,7199712,7199713,7199714,10864762,10864763,10864822,3923640,3923641,8906575,8906579,8906580,8906799,10838932,10838933,7197654,7197657,7197664,7197667,7197668,10617047,10617164,8905509,8905807,8905826,8905827,10620121,10425582,10615603,10615654,10615658,10425910,8633230,10615960,10615961,10616060,10426356,10616242,8611288,10616844,10616848,10616866,10427110,10611298,10614301,10611764,10611802,10611819,8851132,8851149,8851170,8851280,10609151,10609152,8851339,10609194,10609195,10609243,10609262,10612344,10612431,10612467,10612473,10612572,10612604,10612606,10612607,10612675,10612685,10612691,10609713,10612746,10612767,10612825,10612904,10612912,10612914,10612915,10612945,10609978,10610054,10613187,8567072,8567073,10613508,10613509,10613662,10613673,10610676,10613694,6673527,6673556,6673803,9169676,9169677,9169678,9169679,9169680,6674169,9912194,6674195,6674281,9912371,9912372,9912373,9912493,9912517,9912740,9912812,8850617,8850920,8850941,8850978,6672563,10416284,10418466,10418473,10418492,9910828,10418033,10418078,10418079,10419114,10418146,10419197,10468947,10471116,6670760,8550160,8550161,6671918,976521,976522,976548,10470694,10470696,10470704,8848108,10427663,10888688,10888839,10888844,10888888,10888933,10888982,10889002,10889003,10889004,10889008,10889009,10884195,10899571,10889591,10884933,10875011,10890022,10875047,10890094,10890106,10890108,10890111,10890112,10890113,10890115,10890117,10890118,10890119,10890121,10890122,10890123,10890124,10890125,10885526,10885580,10885624,10885626,10885955,10162224,10162225,10897016,10887021,10897049,10882077,10897079,10897080,10897092,10887157,10602445,10647389,10603221,10607437,10607600,10508472,10508473,10508474,10508522,10508523,10508025,10413383,10407448,10413754,10413759,10413769,10413793,10413844,10413849,10413864,10413895,10412268,10414441,10414442,10414443,10414444,10414485,10414487,10414494,10414496,10414498,10414500,10415064) 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>