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(8621447,10963424,10963425,10963426,3229253,4971138,10849587,10849588,3230018,8619825,7075165,8573463,11001269,10845413,7067744,7064071,8911526,8911527,8911528,7072591,7072592,8065932,8065933,8618802,8618803,8065973,8560248,8560249,10867646,3927454,10997870,10997871,8835000,10857858,10839796,10839797,11035308,3926245,3926246,11022763,11022764,11022765,3236515,10856403,11048526,11010610,11010611,11010612,10618865,10618866,10618867,10618868,10618869,10618870,10618871,10619006,10619007,10619008,10619009,10619010,10619011,10619012,10619013,10619014,10619015,11005673,8612724,3230622,10920855,10926028,10926029,10621428,10621429,8611474,8634485,8634486,8634487,8634488,8634489,10565316,10565317,10565479,10565480,10565481,10565482,10565483,10565484,10565485,10565486,10565487,10565488,10565489,10565490,10565491,10565492,10565493,10565494,10565495,10565496,10565497,10565498,10565499,10565500,10565501,10565502,10565503,10565504,10565505,10565506,10565507,10565508,10565509,10565510,10565511,10565512,10565513,10565514,10565515,10565516,10565517,10565518,10565519,10565520,10565521,10565522,10565523,10565524,10565525,10565526,10565527,10565528,10565529,10565530,10565531,10565532,10565533,10565534,10565535,10565536,10611386,10565537,10565538,10565539,10565540,10565541,10611392,10565542,10565543,10565544,10565545,10565546,10565547,10565548,10611438,9173798,10611504,10611506,10611507,10611508,10611559,10611615,10566059,10566066,7019939,8851136,8851203,8851210,8851211,8851212,8851286,8851287,8851371,8851372,8851379,8851380,8851456,8851497,8851498,8851499,9171978,7018004,3653752,7018241,8567260,7018501,7026522,8852959,8853060,10517311,10517312,7023677,7023678,7023679,7023680,7023681,7023682,7023683,7023684,7023685,7023686,7023687,7023688,7023689,7056506,10516614,10516615,10516616,10516617,10516618,8850656,8850657,8850663,8850668,8850669,8850682,8850767,8850768,10119144,8850774,8850775,10512852,8850875,10516875,10516876,8850927,8850943,8850946,8850947,8850948,9179190,9179191,9179192,8851033,8851034,8851038,8851039,8851080,7022014,8918044,7022174,10116823,7022734,10125333,6666626,9199002,9199003,9199004,9199005,9199006,8854894,7021434,10909061,10909062,10909063,10909064,10909065,10909066,10168810,10891617,10891673,10891674,10891675,10891676,10891677,10891678,10891679,10631258,10163246,10163273,10589529,10583674,10547901,10547905,10552206,10552207,10552208,10552209,10552210,10538334,10538335,10546420,10508161,10420397,10509732,10510793,10510794,10509823,10425031,10425032,10425033,8562246,10483045,10483046,10477233,10412442,10476532,10472639,10407164) 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>