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(8630632,8630638,8630639,8630640,8630641,8630643,8630649,8630650,8630651,8630652,8630653,8630654,10860242,10860244,10860245,10860246,10860247,10860248,10860249,10860250,8594779,7201720,7201721,7201722,7201723,7201724,7201725,7201726,8628774,9794571,9794572,9794588,10857503,10857504,10857557,10857559,10857560,10857561,10857562,10857563,10857564,8627468,8627477,8627481,8627482,8627483,8627484,8627485,8627486,8627487,8627488,8627489,8627490,8627499,8627500,8627504,8627505,8627513,8627514,8627525,8627526,8627527,10863973,10863979,10863980,10863981,10863982,10863983,10863984,10863985,10863986,10863987,10863988,10864491,10864492,10864493,10864494,8905996,8905997,8905998,8905999,8906000,8906001,8906002,8906003,3923489,3923546,3923547,3923548,3923618,3923621,3923640,3923641,3923642,10854412,10617138,3922823,10615465,3581888,8540594,9165541,7058250,10609875,8852356,8852357,8852358,8852359,8852360,8852361,8852362,8852363,8852364,8852365,8852366,8852367,8852368,8852369,8852370,8852371,10610937,10610939,10610940,10610941,10610942,10117526,9169516,9169517,9169826,9169845,10126077,6674098,6674099,6674100,6674101,6674102,6674103,6674104,9912187,9912815,9912816,9913280,9913281,10417385,10417386,10417387,10417388,10417389,10417390,10417391,10417392,10417393,10417801,10417802,10417803,10417804,6673341,8550018,8550055,8550097,10470077,10470078,10470079,10470080,10470081,976433,9167937,9168093,10888511,10888512,10888513,10888514,10888515,10888516,10889168,10889169,10889170,10889171,10889172,10889173,10889174,10889175,10889176,10889177,10889178,10889179,10889180,10889181,10889182,10889183,10884675,10884764,10874947,10890249,10627296,10627297,10627306,10627315,10888301,10627939,10882238,10631884,10601713,10601714,10410134,10410135) 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>