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(3229285,10863164,8629594,8629595,8067903,3227577,8630338,10858847,10858848,10858918,10859091,10859111,10859112,10859118,9794580,10865510,7200763,7201029,8627481,7201093,10855332,10855335,7198686,10864102,8625499,8625500,8625501,8625502,8625503,10853351,8906913,10838818,10617063,10617064,10617157,10617159,10852526,10622524,10615014,10615097,10615268,10615289,10426279,10615950,10615953,10426415,10426421,10616548,10610998,10610999,8853326,8853327,8853332,10611179,10611339,10611396,10611399,9214174,10614857,10611863,10612131,10612139,10612189,10612207,10612208,10612209,10612210,10612211,10612212,10612213,10612246,10612280,10612284,10612285,10612519,10612586,8851772,10612841,8852025,8852026,8852027,8852029,8852032,8852033,8852034,8852038,10612942,10613344,10613345,10613356,10613357,10613367,10613368,8849371,10118100,6674161,8849783,8849907,9912340,8850032,7016425,7016426,7016427,7016428,7016429,7016430,7016431,7016432,7016433,7016434,7016435,7016436,7016437,7016438,8851044,9910564,9168435,10418468,10418469,10418470,10418476,10416637,10416714,7014456,7014457,7014458,7014459,7014468,7014469,7014478,7014479,7014484,7014485,9168944,976484,10462340,10462342,10462343,10462347,10462392,10462393,10462394,10468480,10468489,10468490,10888991,10884446,10884540,10884890,10625214,10625239,10625240,10625241,10604441,10604459,10604502,10604555,10507771,10507772,10413381,10411417,10411434,10411443,10413444,10411457,10409518,10411523,10411524,10413593,10413613,10413617,10409620,10409622,10407635,10407636,10407637,10407638,10407639,10407640,10407641,10407642,10407643,10409643,10407644,10407645,10407646,10407647,10407649,10407650,10407652,10407653,10407654,10407655,10407656,10407657,10407658,10407659,10407660,10407661,10407662,10407663,10407664,10407665,10407666,10407667,10407668,10407669,10407670,10407671,10407672,10407673,10407674,10407928,10407930,10407932,10408050,10408130,10410514,10410517,10410692,10406939,10408977,10408979,10408990,10415035,10415040,10409076) 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>