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(10861858,10861859,10861882,10861891,10863008,10863009,8595035,8595036,10865780,11048365,3923393,10853740,10853741,10853781,10853782,10853790,10853791,10853816,10853829,10853857,10853862,10853863,10853914,10853916,10853917,10853923,10853924,10853925,10853926,10853928,10853931,10853962,10853967,10853968,10853969,10853971,10853975,10853978,10853982,10853989,10853990,10853996,10853997,10854009,10854010,10854014,10854018,10854019,10854020,10854022,10854023,10854024,10854025,10854026,10854027,10854028,10854029,10854030,10854031,10854032,10854033,10854035,10854036,10854038,10854039,10854040,10854041,10854042,10854043,10854045,10854048,10854049,10854106,10854109,10854112,10854121,10854126,10854127,10854128,10854129,10854130,10854131,10854134,10854136,10854143,10854145,10854146,10854147,10854148,10854151,10854152,10854153,10854154,10854156,10854157,10854158,10854159,10854160,10854163,10854170,10854171,10854172,10854175,10854178,10854180,10854181,10854183,10854184,10854196,10854200,10854203,10854205,10854226,10854227,8904932,10609432,10609452,10609662,10609673,9911616,9911641,9911657,9911658,9911740,8850083,9912823,6672571,6672583,10416569,10416570,10416571,10416572,10416573,10416574,10416575,10416576,10415697,10415703,10415704,10415715,10415716,10418993,10117445,9167686,9167750,9167752,10882495,10882557,10882614,10882615,10882616,10882666,10601472,10409754,10409755,10409763,10409764,10409766,10409767,10409769,10409771,10409780,10409782,10409783,10409784,10409785,10409791,10409792,10409793,10409794,10409795,10409796,10409797,10409798,10409799,10409801,10409802,10409803,10409804,10409805,10409806,10409807,10409808,10409809,10409811,10409813,10409814,10409820,10409821,10409822,10409823,10409828,10409829,10409830,10409832,10409834,10409835,10409836,10409837,10409838,10409839,10409840,10409841,10409842,10409843,10409844,10409845,10409846,10409847,10409848,10409849,10409850,10409852,10409853,10409854,10409856,10409857,10409858,10409859,10409860,10409861,10409863,10409864,10409865,10409866,10409867,10409868,10409903,10409904,10409905,10409906,10409907,10409908,10409909,10409910,10409911,10409912,10409915,10409916,10409917,10409918,10409919,10409920,10409921,10409922,10409923,10409924,10409927,10409930,10409931,10409932,10409933,10409934,10409936,10409937,10409938,10409939,10409940,10409941,10409942,10409943,10409944,10409945,10409946,10409947,10409948,10409949,10409950,10409951,10409952,10409953,10409954,10409955,10409964,10409965,10409966,10409968,10409969,10409970,10409971,10409989,10409990) 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>