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(8630649,8574502,3229285,10849475,10862793,10862794,10862804,10862805,8632283,8632284,8632287,8632288,8632289,8632290,10844713,10860629,8630293,8627515,10866573,10866574,7201776,10960308,10866932,10866933,10866934,10866935,10866936,8628385,8628386,8628389,10960474,10867203,11000014,8629167,8629168,8629169,8629170,8629171,8629172,8629173,10865572,10865573,10865574,10865575,10865576,10865579,10865584,10865588,10865593,10865596,10865602,10865605,10865607,10865609,10865611,10865613,10865615,10865617,10865619,10865620,10865622,10865629,10857694,8627059,8627146,8627150,8627159,8627163,8627172,8627176,8627184,8627188,8627192,8627202,8627206,10857893,10857932,10857933,10857934,10857935,10857937,10857939,10857941,10857942,10857943,10857944,10857945,10857948,10857950,10857952,10857953,10857954,10857956,10857957,10857958,10857960,10857961,10839675,10839676,8624670,8624672,8624774,8624778,7198380,7198381,7198382,8625503,8625534,8625535,8625538,10856187,8625552,8625560,8625562,8625564,8625565,8625567,8625568,8625575,8625576,8625621,8625622,8625627,8625695,8625774,8625775,8625776,8625783,8625784,8625786,8625787,8625788,8625789,8625791,8625792,8625793,8625794,8625795,8625796,8625797,8625798,8625799,8625800,8625801,8625802,8625803,8625804,8625805,8625806,8625807,8625808,8625809,8625810,8625811,8625812,8625813,8625814,8625815,8625816,8625817,8625818,8625819,8625820,8625821,8625822,8625823,8625824,8625825,8625826,8625827,8625828,8625829,8625830,8625831,8625832,8625833,8625834,8625835,8625838,8625839,8625868,8625877,8625878,8625880,8625893,8625897,8625970,8625974,8625975,8625976,8626013,7196209,7196958,3234552,10839110,7197630,7197633,8907461,8907462,7197725,11008235,10619864,10619866,10836870,3922813,3922814,8632542,10425349,10425350,10425351,10425353,10425356,10425358,10425360,10620186,8632747,10425550,10425570,10425571,10615363,10425586,10425587,11042932,11042933,11042934,8633160,8633204,10426009,10426010,10426016,10615896,10426195,10616044,10616045,10952791,10991865,8634150,8634151,8634152,10610982,10610996,10611423,10611441,10611603,6666004,10611804,8851444,10612916,10613127,8567072,8567073,10613350,10515280,10515281,10515282,10117684,9912057,9912058,9912060,6674280,6674329,9912470,10516142,8850836,8850837,10512852,10427712,10416356,10416357,10416367,10416368,6673064,10418806,10418807,10418808,10418809,10418812,10419813,10419814,10419815,10419816,10419817,10419818,10418824,10418830,10418833,10418835,10418837,10418839,10418841,10418843,10418845,10418847,10418849,10418851,10418853,6673140,10418859,10420038,8549460,10466347,10466406,10462424,10462475,10462486,10462508,10462509,10462537,10462540,10462581,10462617,10462627,10159954,10159956,10159957,10159958,10884097,8068992,10884799,10884800,10899929,10885465,10885468,10153871,10153879,10161604,10885742,10631412,10631413,10631414,10631416,10631419,10631420,10631423,10631425,10631428,10631431,10631433,10631435,10631438,10631439,10631441,10631443,10631444,10167968,10631446,10631448,10631451,10167992,10168007,10168027,10877124,10604146,10548292,10548293,10548298,10548305,10508157,10498250,10498251,10498252,10508407,10507816,10507817,10508105,10412476,10412516,10412517,10412518,10412519,10412521,10412523,10412525,10412526,10412527,10412528,10412529,10412530,10412532,10412534,10412535,10412537,10412539,10412540,10412541,10412543,10412544,10412545,10412547,10412548,10414871) 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>