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(8574833,8574834,8574835,8574836,8574837,8574838,8574839,8574840,8574841,8574842,9215318,9215319,10981113,10981114,10981115,10981116,10981117,10981118,10981119,10981120,10981121,10981122,10981123,10981124,10981125,10981126,10981127,10981128,10981129,10981130,10981131,10981132,10981133,10981134,10981135,10981136,10981137,10981138,10981139,10981140,10981141,10981142,10981143,10981144,10981145,10981146,10981147,10981148,10981149,10981150,10981151,10981152,10981153,10981154,10981155,10981156,10981157,10981158,10981159,10981160,10981161,10981162,10981163,10981164,10981165,10981166,10981167,10981168,10981169,10981170,10981171,10981172,10981173,10981174,10981175,10981176,10981177,10981178,10981179,10981180,10981181,10981182,10981183,10981184,10981185,10981186,10981187,10981188,10981189,10981190,10981191,10981192,10981193,10981194,10981195,10981196,10981197,10981198,10981199,10981200,10981201,10981202,10981203,10981204,10981205,10981206,10981207,10981208,10981209,10981210,10981211,10981212,10981213,10981214,10981215,10981216,10981217,10981218,10981219,10981220,10981221,10981222,10981223,10981224,10981225,10981226,10981227,10981228,10981229,10981230,10981231,10981232,10981233,10930765,10621627,10621628,10621629,10621630,10621631,10621632,10621633,10621634,10621635,10621636,10621637,10621638,10621639,10621640,10621641,10621642,10621643,10621644,10621645,10621646,10621647,10621648,9915558,9915559,9915560,6676553,6676554,6676555,6676556,9914565,9914566,9914567,9914568,9914569,9914570,9914571,9914572,9914573,9914574,9914575,9914576,9914577,9914578,8567357,8567358,8567359,8567360,8567361,8567362,8567363,8567364,8567365,8567366,8567367,8567368,8567369,8567370,8567371,8567372,8567373,8567374,8567375,8567376,8567377,8567378,8567379,8567380,8567381,6679011,6679012,6679013,10898669,10898670,10898671,10898672,10898673,10898674,10898675,10898676,10898677,10898678,10169799,10169800,10169801,10169802,10169803,10169804,10169805,10169806,10169807,10169808,10169809,10169810,10169811,10169812,10169813,10169814,10169815,10169816,10169817,10169818,10169819,10169820,10169821,10169822,10169823,10169824,10169825,10169826,10169827,10169828,10169829,10169830,10169831,10169832,10169833,10169834,10169835,10169836,10169837,10169838,10169839,10649844,10649845,10649846,10649847,10649848,10649849,10649850,10649851,10649852,10649853,10649854,10649855,10649856,10649857,10649858,10480539) 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>