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(10845819,10845820,11014773,7068242,10988944,7076307,10848680,9215245,9215246,8569898,10976754,10976762,10976763,10976764,10976765,10976766,9215912,8622221,10868803,10974633,10974634,10974635,10974636,10974689,10974690,10974691,10974692,10974693,10974694,10974695,10974696,10974697,10974698,11039839,10962150,7067668,7067669,7067670,11011713,10960120,8559388,8595267,3899203,3899204,10999726,8619119,10961132,10961222,10961324,10961325,10961466,7065798,7065799,7065800,11013556,11013557,11013558,11010645,11011383,11011478,11011479,11011480,11011481,8908064,3925522,3925528,7069226,7198761,10101376,10101377,3926802,10841281,10841282,10841286,11045837,11045838,8613221,10838401,8906828,3924165,3924344,7157706,7157707,10982169,10982170,10982171,10982187,10982188,10982228,11047321,11005664,11005665,11005666,11005694,11005715,11005716,11005717,11005735,7155599,8612439,8579108,8576176,8570164,11004202,11004266,11004267,11004322,11004513,11004514,11004539,8540434,11004740,11004741,11004742,11004743,9217738,11004814,11004815,11004816,11004898,8611162,3231815,3231816,3231838,3231858,3231859,3231873,3231874,3231875,3231885,3231892,3231893,9915704,10611701,6666136,6666137,10566098,10566099,10566110,10566111,10609387,9171867,10120711,10610300,3654036,9180866,9180867,9180868,9180869,10125831,9177671,9177672,9177673,9177674,8592820,9177687,9177688,9177689,8849789,8849834,8850428,8850429,8850430,8850431,8850432,8850433,8850434,8850435,9913043,10516962,10116798,9910845,9177268,6666509,6666510,8916740,9167134,8916989,10123860,9191693,8550885,8550886,6474134,9191844,9191846,9199899,8917760,9168183,9168184,6672502,6672503,10628512,10904110,10884194,10170225,10170226,10170227,10170232,10170233,10170250,10170251,10170252,10170253,10170254,10170268,10170269,10170270,10170273,10170275,10170276,10170277,10899419,10628925,10884695,10890201,10880214,10890289,10912694,10912695,10183980,10183981,10882977,10630045,10176939,10896332,10881547,10881550,10168228,10168229,10168230,10168231,10168232,10168233,10168234,10168235,10892324,10892325,10566112,10579450,10579451,10579452,10579453,10567519,10607537,10547829,10547830,10547831,10547832,10546005,10546038,10546063,10546064,10524339,10534381,10544467,10544468,10544469,10480953,10480954,10480955,10480956,10493109,10478517,10406945) 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>