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(10870440,10861517,8621074,10448308,10963397,10849488,10862781,10862800,8632190,10977443,8609701,8632548,8632555,8619854,8573375,10961928,10961929,8620156,10870048,10870049,10870050,10972988,10972989,11012237,11012238,11012239,11012340,7202024,10843672,8066202,8560561,10984809,10984810,10984811,10984812,10959215,10959219,10943321,10943322,10103012,3925437,8908183,8615088,8615089,8625595,7070090,10983864,10983865,10983866,10983867,10864823,8073495,8073517,7196194,3233400,3233401,10928620,11045768,11045771,11045772,11045773,11045774,11045775,10928631,11045788,11045789,11045790,11045804,11045805,11045806,11045816,11045823,11045824,11045825,11045826,11045827,11045828,11045829,11045830,11045842,11045844,11045849,10853452,11045862,8554554,8554555,8613454,8613574,8906913,3924347,11047004,11047005,8614224,3924829,10622128,10617173,10977880,10977881,8633193,10848466,10848470,3231149,10848495,10848507,10615924,10978662,10978710,10426572,8541206,8541208,9181460,9189502,9189503,3654795,7059796,9213644,8568167,8568168,8568182,8568183,8864216,8864217,10614384,9213733,8568243,9213755,9213766,10611432,10611433,10611434,9181850,9182086,9182087,10122351,9182240,9195377,6675706,7057809,7057810,6675864,7058212,8566564,10120264,7058279,10120321,10120328,9172235,9212348,9212361,9204414,7058666,7058667,9914734,10120774,3654101,8567396,8567653,8567654,10517244,9185626,9177720,7055989,7055990,10126023,10126036,10126037,10126040,10126048,10126049,7023517,9193869,7023549,10126130,10126189,10514058,8850388,8850389,8850458,9178696,6675068,9186902,9186903,8850753,8850754,8850755,8850756,8850757,8850758,6675204,6675205,6675206,6675207,9184314,6672553,6672555,10416345,10415410,10428267,10418147,8569027,8855045,10123469,10462426,10462427,10462428,9200278,10903546,10903547,10903548,10903552,10903553,10903582,10883587,10893728,10884184,10170607,10884651,10170686,10899721,10899722,10899892,10632171,10888282,10908430,10908431,10166870,10166962,10166963,10167040,10182177,10167633,10896705,10896981,10896982,10896983,10896984,10897007,10902051,10902052,10168094,10882288,10882293,10602120,10586481,10602686,10602707,10599278,10599279,10569287,10569288,10569289,10578335,10590462,10590471,10590472,10590484,10590485,10590486,10590487,10590488,10590489,10590490,10590491,10569506,10599787,10599788,10603702,10599963,10576956,10576957,10576958,10576959,10576960,10576961,10576962,10586087,10586088,10533128,10533129,10533130,10533131,10533132,10529449,10529451,10529455,10529456,10529457,10529474,10529506,10529507,10531804,10531805,10529909,10529910,10529911,10529912,10529913,10529914,10529948,10529949,10529950,10529951,10529952,10529953,10529959,10522248,10522249,10530560,10530561,10530562,10532688,10532689,10532719,10528819,10528820,10528821,10506574,10506575,10506576,10508791,10508792,10421971,10421972,10485967,10409599,10486319,10481535,10479569,10481585,10481592,10481593,10481595,10481609,10481823,10481837,10493715,10493716) 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>