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(8574619,8574620,8574623,10940525,10940526,10868643,10868644,10951288,8068612,8068613,8068614,8068615,3899263,8066589,8066590,8066591,8066592,8066593,8066594,8066595,8066596,8066597,8066598,8066599,8066600,8066601,8066602,8066603,8066604,8066605,8066606,8613841,3924504,3924505,3924506,3924507,3924508,7155643,7155644,7155645,7155646,7155647,7155648,10979794,10979795,10979796,10979797,10979798,10979799,10979800,10979801,10979802,10979803,10979804,10979805,10979806,10979807,10979808,10979809,10979810,10979811,10979812,10979813,10979814,10979815,10979816,10979817,10979818,10979819,10979820,10979821,10979822,10979823,10979824,10979825,10979826,10979827,10979828,10979829,10979830,10979831,10979832,10979833,10979834,10979835,10979836,10979837,10979838,10979839,10979840,10979841,10979842,10979843,10979844,10979845,10979846,10979847,10979848,10979849,10979850,10979851,10979852,10979853,10979854,10979855,10979856,10979857,10979858,10979859,10979860,10979861,10979862,10979863,10979864,10979865,10979866,10979867,10979868,10979869,10979870,10979871,11016581,10915708,10926168,10621444,10426919,10426920,8853411,8853412,8853413,8853414,8853415,8853416,8851181,9179359,9179360,9179361,9179362,8851250,8851251,8851421,7057829,7057830,7057831,8851530,8851531,6676495,6676496,6676497,6676498,6676499,6676500,6676501,9914502,9914503,9914504,9914505,9914506,9914507,9914508,10120509,10120510,8567275,8567276,8567277,7056660,7056661,7056662,7056663,7056664,7056665,7056666,7056667,7056668,7056669,8850730,8850732,8850733,8850734,8850755,8850756,8850757,8850821,8552322,8552323,8552324,8552325,8552326,8552327,8552328,8850855,8552329,8851001,6672691,4972242,4972243,4972244,8593952,8593953,7000949,10169015,10169016,10169017,10169018,10169019,10169020,10169021,10169022,10169023,10169024,10169025,10169026,10169027,10169028,10169029,10898068,10898069,10898070,10898071,10898072,10898073,10949433,10949434,10949435,10949436,10949437,10949438,10949439,10177991,10571232,10574469,10649701,10573698,10573699,10573700,10573701,10421124,10421125,10480890) 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>