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(10871775,10871776,10871777,10871778,10871779,10871780,10871781,5654644,7201366,7201367,10856221,10855245,8554376,10864538,10864539,10864540,10864541,10864542,10864543,10864544,10864545,10864546,10864547,10864548,10864549,10864550,10864551,10864552,10864553,10864554,10864555,10864556,10864557,10864558,10864559,10864560,10864561,10864562,10864563,10864564,10864565,10864566,10864567,10864568,10864569,10864570,10864571,10864572,10864573,10864574,10864575,10864576,10864577,10864578,10864579,10864580,10864581,10864582,10864583,10864584,10864585,10864586,10864618,10864619,10864620,10864621,10864622,10864623,10864624,10864625,10864626,10864627,10864638,10864639,10864721,10864722,10864723,10864724,10864725,10864726,10864727,10864728,7017443,7017444,7017449,7017450,7017455,7017456,7017461,7017462,7017467,7017468,7017473,7017474,7017479,7017480,7017485,7017486,7017491,7017492,7017497,7017498,7017503,7017504,7017509,7017510,10117619,9912308,10118625,7016164,7013953,7013954,7013959,7013960,9168753,10417850,10417851,10417852,10417853,10417854,10417855,10417856,10417857,10417858,10417859,10417860,10417861,10417862,10417863,10417864,10417865,10417866,10417867,10417868,10417869,10417870,10417871,10417872,10417873,10417874,10417875,10417876,10417877,10417878,10417879,10417880,10417881,10417882,10417883,10417884,10417885,10417886,10417887,10417888,10417889,10417890,10417891,10417892,10417893,10417894,10417895,10417896,10417897,10417898,10417899,10417900,10417901,10417929,10417930,10417931,10417932,10417933,10417934,10417935,10417936,10417945,10117334,976411,7013881,7013882,7013887,7013888,7013893,7013894,7013899,7013900,7013905,7013906,7013911,7013912,7013917,7013918,7013923,7013924,7013929,7013930,7013935,7013936,7013941,7013942,7013947,7013948,10890078,10890079,10882420,10611013,10611014,10611015,10591755,10591763,10591765,10591766,10591767,10591768,10591769,10591772,10591780,10591781,10591782,10591783,10591800,10591802,10529335,10541447,10541448,10508228,10508229,10508230,10508231,10507929,10423100,10423101,10423102,10423103,10423104,10423105,10411312,10410430) 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>