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(10929511,10102501,8835380,8068476,10197911,10197912,10197916,10197917,10197918,10197919,10197924,10197958,10221184,10208186,10208187,10221280,10208335,10208336,10208453,10208454,10208455,10208456,10208495,10208500,10208532,10208562,10208563,10208655,10209146,10209147,10209648,10841845,10102244,8907873,8907874,8907875,8907876,8907877,10220622,10220623,10220624,10220625,10220626,10220627,10220628,10220629,10220630,10220631,10220632,10220633,10220634,10220635,10220636,10220637,10220638,10220639,10220640,10220641,10220642,10220643,10220644,10220645,10220646,10220647,10220648,10220649,10220650,8908164,7069004,7069315,7069316,10219404,10219405,10219406,10219407,10219408,10219409,10219410,10219411,10219412,10219413,10219414,10219415,10219416,10219417,10219418,10219419,10219420,10219421,10219422,10219423,10219424,10219425,10219426,10219427,10219428,10219429,8614066,3582098,10426552,8904360,10426676,10426706,10426744,8583839,10215183,10425566,10216041,10216042,8569876,10620404,8574190,10213937,10213938,10213939,8574453,10930739,8574494,8583480,8583557,10621733,10214866,10214878,10214879,8853178,8853179,8853203,8853204,8853339,8853340,9181609,9181610,9181611,9181612,9181613,9181614,8853486,9181692,6675667,6675671,6675672,6675956,6675957,6675993,6676004,9914072,9914097,8566577,6676523,8566824,8566825,8566826,8566827,8566828,6676652,10120709,10120710,8567104,8567108,8567322,3654111,9180956,9181034,3654256,9181083,8849330,9177996,9177997,9177998,9177999,9178000,6674430,9178315,9178317,10118953,8066478,8066479,7057073,8850936,10427880,8848831,8848833,8848834,10468086,4972435,10468219,10468220,976074,10883603,10899421,10894681,10899685,10894694,10894696,10894697,10894704,10899803,10166702,10166703,10166704,10166705,10166706,10166707,10166708,10166713,10166714,10166715,10166716,10166717,10166718,10166806,10166807,10166808,10166817,10166818,10166819,10166820,10166821,10166863,10166864,10166865,10166866,10166889,10166921,10166924,10162261,10658644,10162706,10162707,10162708,10162709,10162710,10162711,10162712,10162713,10162714,10897182,10897183,10649416,10649417,10649953,10647975,10524422,10524539,10479210,10481223,10479452,10479453,10479454,10479483,10479484,10479485,10479486,10479487,10481629,10463655,10463657,10463658,10463661,10463662,10463663,10463664,10463665,10463666,10463667,10463668,10463669,10463670,10479934,10479935,10481985,10478050,10478051,10497056) 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>