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(8631474,9215568,8583426,10847279,8632191,11042408,11042409,8632449,8632450,8632451,8632458,8632459,8632460,10990523,10990524,10990525,10990526,10990527,10990528,10990529,8629781,8629804,8629805,7067165,7075475,8630264,10939368,7201240,7201245,7201246,7201249,10843101,10843102,10843103,3899065,3899066,3899067,3899068,3899069,3899070,3899071,3899072,10859124,7202164,7202165,7202166,7202167,7202168,7202169,7202171,7202198,7202199,7202207,7202211,7202212,7202213,7202214,10859542,10844316,8560553,8560554,7073632,7073633,8629312,10868084,10102849,10866056,10866057,10866058,8624696,8624697,11034808,8624855,8624898,10855688,10855704,10840829,10840830,10865003,10942491,10853485,10853486,8554194,7196951,7196952,7196953,7196954,7196955,7196956,10838604,10838605,10838606,10838607,8555547,8624416,8624417,8624418,8624476,10852492,10852591,10852592,10852593,10852594,10852634,10993411,10993412,10993413,10993414,10993415,10993416,10993417,10993418,10993419,10993420,10993421,10853127,10620085,10425591,8633019,8633020,8633192,8633624,10426402,9217803,10926829,8634528,10565156,10611992,10557516,10609392,10612429,8862484,9180063,9180064,10609821,9196339,9212435,9212445,10558288,10613179,10613198,10613209,10610298,9188640,10610429,10610793,8863702,8567715,10517289,9185715,8849972,9186803,9186804,9913317,10418293,7014714,9209060,7014715,7014716,7014717,7014718,7014719,7014720,7014721,7014763,7014764,7014765,7014766,7014767,7014768,7014820,7014821,7014822,7014823,7014824,7014825,7014862,7014863,7014864,7014865,7014866,7014867,7014868,7014869,7014870,7014871,7014872,7014873,7014874,7014875,7014876,7014877,7014878,7014879,7014880,7014881,7014882,9185231,10419201,10419202,10419203,10467225,10467226,10467227,10467228,10467229,10467230,10467231,10467232,10467233,10467234,10467235,10467236,10467237,10467238,9174748,9167265,9167266,9167267,9167268,9167269,9167270,9167271,9167272,9167273,9167274,9167275,9167276,9167277,10467857,10464040,10464041,10464042,10464043,10464044,10464045,10466310,10466311,10466312,10466313,10466314,10466315,10466316,10466317,10466318,10466319,10466320,10466321,10466322,10466323,10466324,10466325,10466326,10466327,10466328,10466329,10466330,10466331,10466332,10466333,10466334,10466335,10466336,10466337,10466338,10466339,10466340,10466341,10466342,9175781,10427620,10908593,10893696,10908231,10881989,10882404,10608598,10591854,10529360,10529361,10529362,10529363,10529364,10529365,10529366,10546720,10546721,10539081,10420705,10424742,10510944,10507099,10409341,10473088,10413623,8563195,10714736,10408960,10409046,10409047,10409048,10409049,10409065) 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>