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(3229025,10950727,10950728,10950729,10929913,10939409,10939410,10939411,10939412,10939413,10939414,7201181,7201182,7201190,7201191,8627991,8627992,8627993,8627994,8627995,8627996,8627997,8627998,8627999,8628000,8628001,8628002,8628003,8628004,8628005,8628006,8628007,8628008,8628009,8628010,8628011,8628012,8628013,8628014,8628015,8628016,8628017,8628018,8628019,8628020,8628021,8628022,8628023,8628024,8628025,8628026,8628027,8628028,8628029,8628030,8628194,10859651,10859652,10859653,10859654,10859655,10859656,10859657,10859658,10859659,10859660,10859661,10859662,10859663,10859664,10859665,10859666,10859667,10859668,10859669,10859670,10859671,10859672,10859673,10859674,10859675,10859676,10859677,10859678,10859679,10859680,10859681,10859682,10859683,10859684,10859685,10859686,10859687,10859688,10859689,10859690,10859691,10859692,10859693,10859694,10859695,10859696,10859697,10859698,10859699,10859700,10859701,7201170,7201171,7201172,7201173,7201174,7201175,7201176,7201177,7201178,7201179,7201180,11048411,11048412,8906024,3923527,10838836,10838837,8905549,8905550,8905551,8905552,8905553,8905554,10615557,10426341,8611358,8611359,8611405,10614068,8851893,8851894,8851895,8851896,8851897,8851898,8851899,8851900,8851901,8851902,8851903,8851904,8851905,8566648,10612996,10612997,10612998,10612999,10613000,10613001,10613002,10613003,10613004,10613005,10613006,10613007,10613008,10613009,10613010,10613011,10613012,10613013,10613014,10613015,10613016,8852382,9169475,10118031,10118032,10118033,10118034,10118035,10118177,9912428,9912429,9912430,9168331,9168742,9168743,9168744,9168745,9168746,9168747,9168748,9168749,9168750,9168751,8550053,8550054,10885419,10885420,10885421,10885422,10885423,10885424,10885425,10885426,10885427,10885428,10885429,10885430,10885431,10885432,10885433,10885434,10885435,10885436,10885437,10885438,10885439,10885440,10877491,10162025,10162026,10162027,10162028,10602694,10647510,10604387,10508441,10508442,10508443,10508444,10508445,10486267,10486268,10486269,10486270,10486271,10486272,10486273,10486274,10486275,10486276,10486277,10486278,10486279,10486280,10486281,10486282,10486283,10486284,10486285,10486286,10486287,10486288,10486289,10486290,10486291,10486292,10486293,10486294,10486295,10486296,10486297,10486298,10486299,10414082,10414083,10414084,10414085,10414086,10414087,10414088,10414089,10414090,10414091,10414092,10414093,10414094,10414095,10414096,10414097,10414098,10414099,10414100,10414101,10414102,10414103,10414104,10414105,10414106,10414107,10414108,10414109,10414110,10414111,10414112,10414113,10414114,10414115,10414116,10414117,10414118,10414119,10414120,10414121,10414122,10414123,10414124,10414125,10414126,10414127,10414128,10414129) 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>