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(7201604,8595041,8595042,8595043,10859401,10859402,10859403,10859404,10859405,10859406,10859407,10859408,10859409,10859410,10859411,10859412,10859413,10859414,10859415,10859416,10859417,10859418,10859419,10859420,10859421,10859422,10859423,10859424,10859425,10859426,10859427,10859428,10859429,10859430,10859431,5654612,10929257,8573332,8067904,8067916,7201059,8907474,7198341,7198342,7198343,7198344,7198345,7198346,7198347,7198348,7198349,7198350,7198351,3232863,8905524,8905525,8905526,8905527,8905528,8905529,8905530,8905531,8905532,8905967,8612891,8554336,10854005,10854007,10854015,10854105,10854192,10854228,10854229,10854230,10854231,10854232,10854233,10854234,10854235,10854236,10854237,10854238,10854239,10854241,10854242,10854243,10854244,10854245,10854246,10854247,10854248,10854249,10854250,10854251,10854252,10838829,10863837,10863840,8611399,10862814,10862820,10863208,10863209,10863210,10863211,10863212,10863213,10863214,10863215,10863216,10620073,10620074,10615276,10615277,10615278,10615279,10615280,10615281,10615282,10615283,10615284,10615285,10615286,10615287,10615288,10950689,10950690,10950691,10950721,10714141,8851870,8851871,8851872,10612824,10612825,10612826,10612827,10612828,10612829,10612830,10612831,10612832,10612833,10612834,10612835,10612836,10612837,10612838,10612839,10612840,10612841,10612842,10612843,10612844,10612845,10612846,10612847,10612848,10612849,10612850,10612851,10612852,10612853,10612854,10612855,10612856,10612857,10612858,10612859,10612860,10612861,10612862,10612863,10612864,10612865,10612866,10612867,10612868,10612869,10612870,10612871,10612872,10612873,10612874,10612875,10612876,10612877,10612878,10612879,10612880,10612881,10612882,8852326,8852327,9169404,9911733,9911735,9911974,10118011,6674111,6674112,6674113,6674114,6674115,6674288,10118346,9912403,9912404,9912405,9912406,9912407,9912408,9912409,9912410,8065830,8850104,10118591,10118592,10417287,10417291,6672589,10416376,10416382,9168692,9168693,9168694,9168695,10416757,10416758,10416759,10416760,10117475,6673492,6673493,6673494,6673495,6673496,6673497,8550157,8550158,8550205,10469932,10469933,10469934,10469935,976417,9167759,9167816,9167817,9167852,10468754,10468755,10468756,10468757,10468758,10468759,10468760,10468761,10468762,10468763,10468764,10468765,10883988,10883989,10883990,10883991,10883992,10883993,10883994,10883995,10883996,10883997,10883998,10883999,10884000,10889720,10885292,10885293,10885294,10885295,10885296,10885297,10885298,10885299,10885300,10885301,10885302,10885303,10885304,10885305,10885306,10890307,10885307,10885308,10885309,10885310,10882671,10882892,10882893,10882894,10887933,10882951,10882957,10888328,10888329,10888330,10888331,10888332,10888333,10888334,10161818,10161819,10162011,10162012,10162013,10647506,10609535,10609621,10609622,10609677,10609835,10609836,10604373,10508291,10508292,10508293,10508294,10409762,10409826,10409827,10409833,10413857,10413858,10413859,10413860,10413861,10413862,10413863,10413864,10413865,10413866,10413867,10413868,10413869,10413870,10413871,10413872,10413873,10413874,10413875,10413876,10413877,10413878,10413879,10413880,10413881,10413882,10413883,10413884,10413885,10413886,10413887,10413888,10413889,10413890,10413891,10413892,10413893,10413894,10413895,10413896,10409900,10409901,10409925,10409926,10409962,10409991,10409992,10409993,10409994,10409995,10409996,10409997,10409998,10409999,10410000,10410001,10410002,10410003,10410004,10410005,10410006,10410007,10410008,10410009,10410010,10410011,10410012,10410013,10410014,10410015,10410016,10410019,10487105,10487106,10487107,10482566) 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>