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(11014592,11027614,11027615,11027616,11027619,11027620,10873313,10873314,11015157,8621565,8621566,8621567,7074315,7074316,8584048,8619760,11013616,8837463,8837464,8837465,10961944,10961945,10845117,10962077,10962078,10962079,10962080,8910890,11024866,11024867,11024868,11024869,11024870,11024871,11024872,11024873,11024874,11025145,11025150,11025151,11025152,11025153,11012545,11012546,11012547,11012548,3899499,11012977,11012978,11012979,11012980,11012981,11013029,8560364,8619277,8619287,10961207,8619382,8837064,8837134,8837135,11023676,10839681,3925887,11022930,10101591,3236986,3236987,3236988,3236989,3236990,10971285,3927023,3927024,3927025,3927036,11006543,11019644,11019645,8906066,11019731,8554671,10920181,10920182,10624823,11005579,11005580,11005905,11018916,11018917,11018918,11018919,10837200,11006229,10954259,11006264,8542127,8542128,11032429,11019457,11019458,11032490,11032491,11032496,10915749,11016830,11016831,11016832,11016833,11016834,11016835,11016836,11016837,11016838,11016839,11016840,11016841,11016842,11016843,11016844,11017063,11017064,11017065,11017066,11017067,11017076,11017077,11017078,11017079,10952287,9217790,11004857,8904465,10917098,10917099,10917100,10917101,10917102,10917103,10917104,10917105,10917106,10917107,10917108,10917109,10992333,10992334,10992335,10992336,10992337,7059726,7059727,9915818,9915819,9915820,6677945,9916099,6678336,9916359,10125565,4974466,9201630,9201631,4974485,9201632,9161793,9161794,9912106,9912109,6674119,9912225,9202963,9202964,9202965,7024817,7024818,7024819,7024820,7024821,7024822,7024823,7024824,7024825,7024826,7024827,7024828,7024829,7024830,7024831,7024832,7024833,8848394,9176807,10428398,8849057,8849091,8849092,9201292,6678655,8864984,9174537,9174538,9174539,9174540,9174541,6678877,6678932,6678933,6666867,6666868,8550315,976364,10468462,9207939,9207940,9207941,9207942,9207943,9207944,9207945,9207946,9207947,9207948,9207949,10914642,10915110,10892871,10163995,10163996,10888107,10908188,10913336,10911127,10162240,10177350,10187597,10187598,10187680,10187681,10187682,10187683,10187684,10162836,10162837,10162838,10187957,10178065,10178066,10178067,10178068,10877284,10626880,10626881,10571471,10571472,10571848,10571849,10568953,10653074,10584353,10584354,10584355,10584356,10584357,10584358,10584359,10584360,10584361,10584362,10584363,10584364,10587849,10587850,10587851,10575853,10654045,10654106,10604231,10567384,10567385,10567386,10567387,10648798,10648799,10648800,10580038,10580039,10580040,10519852,10519853,10539065,10424003,10424004,10495238,10495239,10495240,10480439,10493626,10493639) 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>