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(10447700,10447701,10447702,8574966,8574967,8583850,8583851,8583852,10868860,10868861,10868865,10929582,10984778,10841963,10841964,10841965,10841966,10841967,10841968,10940729,10940730,8625133,10983502,10983503,10983504,10983505,10983506,10983507,10983508,10983509,10983510,10983511,10983512,10983513,10983514,10983515,10983516,10983517,10983518,10983519,8613992,3924786,3924787,3924788,3924789,3924790,3924791,10622015,10622016,10622017,10622018,10622019,10622020,10622021,10622022,10622023,7155702,7155703,7155704,7155705,7155706,7155707,7155708,7155709,7155710,7155711,7155712,7155713,11006418,11006419,11006420,11006421,11006422,3582085,3582086,8853462,8853463,8853464,8853465,8853466,8853467,8853468,8853469,8853470,8853471,8853472,8853473,8853474,8853475,8853476,8853477,8853478,8853479,8853480,8853481,8853482,8853483,8853484,8853485,8853486,8853487,8853488,8853489,8853490,9181958,9181959,9181960,9181961,9181962,9181963,9181964,9181965,8566577,6676673,6676674,9914739,9914740,9914741,9914742,9914743,9914744,9914745,9914746,9914747,9914748,9914749,9914750,9914751,9914752,9914753,9914754,9914755,9914756,9914757,9914758,9914759,9914760,9914761,8567401,8567439,8567442,8567443,3654272,3654273,3654274,3654275,3654276,9181137,9181138,9181139,9181140,9181141,9181142,9181143,9181144,9181145,9181146,9181147,9181148,9181149,9181150,9181151,9181152,9181153,9181154,8863706,8863707,8863708,8863709,8592846,10427874,10427891,3963420,3963421,4972448,976127,976128,976129,10170483,10170484,10170485,10170486,10170487,10170488,10170489,10170490,10170491,10170492,10170493,10170494,10170495,10170496,10170497,10170498,10170499,10170500,10170501,10170502,10170503,10170504,10170505,10170506,10170507,10170508,10170509,10170510,10170511,10170512,10170513,10170514,10170515,10170516,10170517,10170518,10899507,10170519,10899508,10170520,10899509,10170521,10899510,10170522,10899511,10170523,10899512,10170524,10899513,10899514,10899515,10899516,10899517,10899518,10899519,10899520,10899521,10899522,10899523,10899524,10899525,10899526,10899527,10899528,10899529,10899530,10899531,10899532,10899533,7000967,7000968,10649975,10649976,10649977,10524370,10524371,10524372,10524373,10524374,10524375,10524376,10524377,10524378,10524379,10524380,10524381,10524382,10524383,10524384,10524385,10524386,10524387,10524388,10524389,10524390,10524391,10524780,10524781,10524782,10524783,10524784,10524785,10524786,10524787,10524788,10524789,10524790,10524791,10524792,10524793,10524794,10524795,10524796,10524797,10524798,10524799,10524800,10524801,10524802,10421210,10421211) 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>