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(3229207,10862253,10862254,10862255,10862256,10862653,8583952,10862912,10862913,10862914,10860550,10860551,10860552,10860553,10860554,10860555,10860556,10860557,10860558,10860559,10860560,10860561,10860562,10860563,10860564,10860565,10860566,10860567,10860568,10860569,10860570,10860571,10860572,10860573,10860574,10860575,10860576,10860577,7201578,7201579,7201580,7201581,7201582,8595070,8595159,8595160,8595161,8595162,8065833,8065834,8065835,7201110,7198888,7198889,7198890,7198891,8564677,3923556,3923557,10623959,10854323,8905113,8905715,8905716,10614997,10614998,3581859,10615581,3231076,10426356,10426357,8540606,8611380,10714153,8566674,8852002,8852003,10610334,10613646,10613647,10613648,10613649,10613650,10613651,10613652,10613653,10613654,10613655,10613656,10613657,10613658,10613659,10613660,10613661,10613662,10613663,10613664,10613665,10613666,10613667,10613668,10613669,10613670,10613671,10613672,10613673,10613674,10613675,10613676,10613677,10613678,10613679,10613680,10613681,10613682,10613683,10613684,10613685,10613686,10613687,10613688,10613689,10613690,10613691,10613692,10613693,10613694,10613695,10613696,10613697,10613698,10613699,10613700,10613701,10613702,10613703,10613704,10613705,10613706,10613707,10613708,10613709,10613710,10613711,10613712,10613713,10613714,10613715,10613716,10613717,10613718,10613719,10613720,10613721,10613722,10613723,10613724,10613725,10613726,6673509,6673510,6673639,6673640,6673641,6673642,6673643,6673644,6673645,6673646,9169870,9169871,10118132,10118133,10118134,10118135,10118299,10118300,10118301,10118435,8850094,9912590,9912591,9912592,9912593,9912594,9912595,9912596,9912597,9912598,9912599,9912600,9912601,9912602,9912603,9912604,9912605,9912606,9912607,9912608,9912609,9912610,9912611,9912612,9912613,9912614,9912615,9912616,9912617,9912618,9912619,9912620,9912621,9912622,9912623,9912943,9912944,9912945,10416482,10416483,10416484,10416485,10416486,10416487,10416488,9168956,9168957,9168958,9168959,9168960,9168961,9168962,9168963,9168964,10469255,10469256,10469257,10469258,10469259,10469260,10469261,10469262,10469263,10469264,10469265,10469266,10469267,10469268,976520,976521,976522,976523,976524,976525,976526,976527,10884477,10884478,10884552,10887906,10887907,10887908,10883392,10885909,10885910,10885911,10885912,10885913,10885914,10885915,10885916,10885917,10885918,10885919,10885920,10885921,10885922,10885923,10885924,10885925,10885926,10885927,10885928,10885929,10885930,10885931,10885932,10885933,10885934,10885935,10885936,10885937,10885938,10885939,10885940,10885941,10885942,10885943,10885944,10885945,10885946,10885947,10885948,10885949,10885950,10885951,10162073,10162074,10162075,10162076,10162077,10162078,10162079,10647532,10647533,10647534,10647595,10508041,10483195,10483197,10494377,10414827) 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>