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(10448118,10846232,10846233,10846234,3229281,9215541,7074237,7074238,8584061,8584062,8584063,7074684,10872687,8620430,8620431,8620432,8620433,8620434,8620435,8620436,10929936,10872969,10872970,10872971,7067758,7067759,8620716,7201225,7201229,11037674,11037675,11037676,11037677,7201238,10858295,7201283,10858875,10866900,10866901,8559713,10843535,7202126,7202131,7202133,7202134,3899392,3899393,7202140,3899394,3899395,7202148,7202150,7202152,7202157,7202159,7202161,7202162,7202174,7202196,7202197,7202205,7202206,7202267,8628724,8628726,10859752,8629140,7200578,8627328,8627329,8627330,8625062,8625063,8625064,8625065,8625066,8625067,8625068,8625069,8625070,8625071,7198726,7198731,10996227,7199032,8625534,8625535,8625538,8625551,8625552,8625556,8625559,8625565,8625568,8625631,8625632,8625635,8625637,8625640,8625641,8625656,8625657,8625658,8625660,8625661,8625662,8625663,8625664,8625665,8625666,8625669,8625671,8625672,8625673,8625675,8625676,8625697,8625698,8625699,8625700,8625701,8625707,8625710,8625711,8625713,8625714,8625716,8625717,8625718,8909130,8625719,8625735,8625738,8625740,8625741,8625742,8625743,8625744,8625745,8625746,8625747,8625749,8625750,8625751,8625752,8625753,8625763,8625764,8625765,8625768,8625793,8625795,8625797,8625799,8625802,8625803,8625805,8625807,8625810,8625811,8625812,8625815,8625816,8625818,8625819,8625820,8625821,8625822,8625823,8625825,8625827,8625829,8625830,8625832,8625834,8625835,8625838,8625839,11035989,11035990,8557328,8557416,10865098,3233670,3233696,7196684,8070774,3234499,8907227,10855163,10617356,10617357,10617358,10617359,10617360,10617425,10617428,10617429,10617439,10617440,10617441,10951692,10460951,10850805,3230998,10922010,10922011,10922012,10922013,8611711,10427241,10610983,8567849,3654926,9166044,9166045,9166046,9166047,8851763,9204831,7026632,8567638,6677355,10610904,10117904,7056162,10512726,10512727,10512728,10512729,10512730,10512753,8850826,9171070,9171071,9171072,8851024,10418398,10418399,10418402,6673023,10419780,10419781,8854685,8854686,8854746,8854753,6667545,9191564,10464257,9176023,9176025,8917806,8551315,8917807,10890159,10887503,10630102,10905640,10905641,10905642,10905643,10905644,10905645,10905646,10905647,10905648,10905649,10905650,10905651,10905652,10905653,10905654,10905655,10905656,10905657,10905658,10905659,10905676,10905691,10625754,10886285,10886286,10886287,10886288,10172419,10886580,10911831,10911832,10911833,10911834,10589898,10589899,10589900,10653260,10651308,10579496,10604510,10522136,10546150,10546151,10546152,10546153,10546154,10546209,10546279,10544495,10544496,10544497,10544498,10544499,10544500,10544501,10544502,10544503,10544504,10544505,10544506,10544507,10544529,10423637,10423789,10423790,10423791,10413393,10486342,10486343,10486344,10486345,10486346,10408035,10414188,10495016,10487040,10476425,10476427,10476428,10476429,10412829,10412830,10412832,10495593,10495594,10407144) 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>