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(10871831,7076143,8618937,8595884,8595956,8596098,8596244,10844384,10844385,10844393,10104819,10844515,10844699,10844700,7075184,7075186,8617977,8617978,8617979,8617980,8617981,8617982,8617983,10247074,10247075,10247076,10247077,10247078,10247082,10247083,10273306,10273307,10840367,10840368,10840369,10840370,10840374,10221691,10840843,10222868,3234887,10246560,10839813,10943420,8541900,8541908,8541913,8541916,8541988,8542081,8542095,8542097,8542102,8612909,3924018,3924019,10867355,10867356,3231192,8540673,8540731,8540833,8541012,8541068,8541069,8541390,8541393,8541400,8541408,8541409,8541516,8541610,8541719,8612118,10228798,8620457,8620458,8620459,8620461,8620462,8620464,8620465,10925859,10925860,10925861,10925862,8838240,10239765,10239766,10201143,10846293,10846294,8839039,9215456,10847021,10559234,10559235,10559236,10559237,10559238,10559239,10559240,10559241,10559242,10559243,10559244,10559245,10559246,10559247,10559248,10559249,10559250,10559251,10559252,10559253,10559254,10559255,10559256,10559257,10559258,10559259,10559260,10559261,10559262,10559263,10559264,10559265,10559266,10559267,10559268,10559269,10559270,10559271,10559272,10559273,10559274,10559275,10559276,10559277,10559278,10559279,10559280,10559281,10559282,10559283,10559284,10559285,10559286,10559287,10559288,10559289,9165716,9213754,9197917,8864470,9214007,9214008,9214009,9214012,9214036,9198261,9187464,9187510,9187546,9187547,10557643,10557646,10557647,9211885,9212325,9196457,9196458,9196459,9196463,9196763,9196765,9196766,9196768,9196769,9196770,9196771,9196772,9196773,9196774,9196775,9196776,9196779,9196780,9196781,9196784,10121074,10121075,10121076,10121077,9204901,9204902,9204903,9204904,9204905,9204907,9204908,9204909,9204910,9204911,9169436,9193505,9193736,9193737,10517634,10517635,10516956,10516957,10516958,10516959,10516960,10516961,10516963,9187288,9176316,10125232,9185127,3655637,9174624,9174625,9174626,9198904,9175034,9183338,10123545,8917090,9191530,9175799,8917521,8917522,8917523,8917812,8917814,8917815,8917816,9192225,8594205,10875284,10158789,10158790,10158792,10158793,10154004,10154005,10154006,10154007,7001275,10908303,10911275,10162417,10582534,10582561,10521171,10521172,10521173,10521174,10521175,10521176,10521271,10522157,10522158,10522159,10534196,10520944,10520945,10520946,10423135,10477380) 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>