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(8574575,8574706,10940471,10868594,10868646,10951275,8591209,10497770,10497771,10497772,8068010,8068011,8068012,10497860,8068117,10497999,8068234,8068235,8068236,8068241,8068296,8068305,8068381,8068382,8068383,8068384,8591688,8591689,8591690,8068443,8591773,8591774,8068575,8068576,8068577,8068578,8068623,8068726,8835450,8835483,8066325,8066326,8066327,8066352,8066410,8066542,8066543,8066544,8066624,8066625,8066750,8066751,8066752,8066753,8066754,8066817,10497606,10497607,10497608,10497609,10102406,10102464,8555969,8556076,8556077,8556100,8556124,10841398,10841399,10841400,10980720,10980873,10980885,10981082,10981127,10981256,10981257,10981291,8613858,3924583,10979961,10979962,10979963,10979969,10980431,10980432,10980433,10980434,10980435,3582013,10621260,10621261,10978996,10616459,10978997,10621473,10621505,10621506,10621586,10621603,10621604,10621605,10621606,10621607,10621608,10426826,10621609,10426827,10621644,10979395,10979396,10979482,10979483,9179312,9179313,9179331,9179341,9179342,9179541,9179702,9179807,9914455,6676527,6676546,6676552,8863399,9911543,8592807,9177988,7056561,7056750,7056754,7056755,7056756,7056757,9178931,9178978,9178979,9179003,9179162,9179163,9179164,9179165,9179166,4972089,4972090,4972186,4972187,10898482,10898522,10898709,8593741,8593801,8593895,8593896,8593927,8594047,8594079,10897538,10897704,10897705,10897706,10897867,10897868,10898151,10898152,10898153,10898154,10898155,10898156,10898228,10949402,10649662,10649687,10649769,10649770,10649771,10649825,10649828,10649848,10649849,10649850,10649851,10523807,10523808,10523809,10523810,10523811,10523812,10523813,10523814,10523815,10421094,10421127,10479734,10479735,10479736,10479737,10479738,10479739,10479740,10479741,10479875,10479876,10479877,10479878,10479879,10479880,10479881,10479890,10480126,10480127,10480128,10497204,10497205,10497206,10480264,10480307,10480358,10480359,10480503) 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>