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(7076123,10870546,10870548,10870550,8630918,10848691,10848692,10989090,10848693,10848694,10861921,3229106,3229107,7065941,7066107,7066108,7066109,7066110,8631857,10964450,10860854,10860855,10860856,10860857,10860858,10860859,10860860,10860861,10860862,10860863,10860864,8627617,8627618,8627619,8627620,8627621,8627622,8627623,8627624,8627629,8627634,7201335,7201336,7201666,8628104,8628105,8628106,8628107,8628109,8628110,8628111,8628112,8628113,8628115,8628116,8628117,8595164,10866857,8911629,7064735,7064856,10867147,10867148,10867150,10867153,10867155,10867157,10867160,10867162,10867165,10867168,10867171,7202444,10867537,10867539,10867541,10867543,10867547,10867548,10844218,10844220,10844222,8572755,10857270,10857271,10857272,10857273,10857274,11036681,3927747,7200602,8558355,7200787,10857955,10857956,10857966,10857967,10102837,10866029,8624523,8624593,7198369,10839904,10863545,3235798,10840164,7198740,7198772,7199012,7199013,7069926,8625628,8625629,8625630,7070567,8626321,8626324,8626332,8626334,10856979,10856980,8626339,8626342,8626344,8626346,8626396,8626397,8626398,11045714,11045715,11045716,3923564,10967936,10967937,11006989,8906635,10968572,10968573,10968574,10838919,3234588,3234589,10838923,7197622,7197662,8907492,8634467,3232264,10852212,10852213,10852214,10852215,10852216,10852217,10852218,10852219,10852220,3232382,8612420,8612421,8612422,8612423,8905771,10951663,8632702,8632703,8632704,8632798,10848385,10848386,10620792,10620793,8633326,8633342,8633548,8610740,3231797,8611342,9211553,10612381,8566684,8852021,7017886,7017887,9212309,9212310,9212311,9212312,9212313,9172327,9196462,9196463,9196464,8567056,8852462,10613406,10610479,10610480,10610481,9205233,10613949,10613950,10613951,10613952,10613953,10613954,10117525,9911802,10118608,10118609,9912658,10518704,10518705,10518706,10518707,10518708,991355,991356,4973162,10415576,10419734,9169060,9169061,10419996,10419998,10420001,10420002,10420003,10420005,10420007,10420010,10420012,10420013,10417078,9185251,10419189,10469358,10469359,10469360,10467430,8854898,9175258,9175259,9207297,10467883,10123859,976585,9167988,10628524,10884079,10884082,10889585,10889776,10883042,10627665,10903291,10903292,10883429,10172027,10172028,10891385,10891386,10886480,10886481,10886482,10886483,10886484,10886485,10886486,10886487,10886488,10626143,10626144,10187807,10882082,10631911,10601174,10580441,10580442,10580443,10580444,10580445,10580446,10598754,10598755,10590304,10590305,10590306,10647394,10647559,10647560,10647561,10647562,10651656,10651657,10529443,10527021,10420316,10420318,10420321,10420325,10425076,10425078,10485877,10485878,10485879,10411839,10411840,10412542,10412543,10412553,10412554,10406958,10406959,10406960,10406961,10414990,10414991,10414992) 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>