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(10873339,10873363,8574297,10930423,10943628,8838740,8838741,8838742,10458882,10989159,10940192,11041264,10846354,11041291,8621788,10459826,10459830,10459840,10459844,10459848,10459861,10459865,8575639,11042247,8584125,7074664,7074997,7074998,11039988,11039992,7075420,10845178,11040202,11040203,11040204,11040205,11040206,11040207,11040208,11040209,11040210,11040211,8620511,8620517,8620521,10447635,10985836,11038006,10931772,7072461,10986542,10986543,10986544,10986545,10986569,8596111,10961398,10868099,3927439,8558308,10865766,10865767,10865768,7071535,10998404,7069066,3926075,10996748,10841225,10841226,11036233,11023298,11036319,11036326,10997439,11048681,8909928,8909929,8909940,8613306,8613307,8613308,7157227,10924288,10839151,8614293,11044722,11005754,10954113,10954114,8542225,8542261,10425576,10425577,10425578,10425579,10425580,10425581,10425582,10425583,10425584,10425585,3231194,3231195,3231196,3231197,10620875,10620876,3231681,8611319,10922097,8541124,3232187,8541403,9165416,10714032,9189674,9187421,8851332,8851472,9171950,10120186,10120187,9187991,10120188,9187992,10120189,9187993,10120436,10561604,10613618,9205001,10117691,9177506,9202130,9170885,10119198,6672807,6672808,6681019,6681036,6681037,9200842,10418979,10418980,10418981,10428546,9916774,9916775,8854467,8854479,8854480,8855063,8855074,8855089,8855096,9207281,8917222,6680079,10883666,10179991,10904917,10905120,10183914,10167174,10911280,10172349,10631205,10631206,10172751,10172872,10887315,10601258,10589681,10589682,10589683,10589684,10589685,10589686,10586751,10586752,10586753,10586754,10586755,10586756,10586757,10586758,10586763,10586764,10586765,10653274,10587291,10644404,10584964,10584965,10584966,10584967,10584968,10584969,10584970,10584971,10584972,10584973,10584974,10584975,10584976,10604084,10604085,10585409,10582535,10582536,10580036,10580037,10545216,10545217,10545448,10529480,10529483,10529486,10529487,10549596,10549598,10548031,10522201,10522202,10528369,10528371,10545030,10545031,10545032,10545033,10498485,10507624,10424035,10497064,10495538) 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>