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(8630719,7076290,11041169,3228944,10861943,10868258,10950842,10950875,8632132,8632170,8632171,8632172,3229976,8632319,8632320,8632321,8632322,10869299,8629709,8629965,8630204,10870069,10870096,10870097,10939439,10870115,10870116,10861172,10861173,10861174,10861175,10861176,10861177,10861178,10861179,10861180,7201299,7201461,7201462,7201463,10867022,10867023,10867024,10867025,10867026,10867027,10867038,10867039,10867046,10867047,10867048,10867049,10867050,10867051,10867052,10867059,10867060,10867061,10867062,10867063,10867064,10867382,10867383,10867384,10867385,10867386,10867387,10867388,10867389,10867390,10867391,10867392,10867393,10867394,10867395,10867396,10867397,10867398,10867399,10867400,10867401,10867402,10867403,10867404,10867405,10867406,10867407,10867408,10867412,10867413,10867414,10867415,10867416,10867417,10867418,10867419,10867420,10867421,10867422,10867423,8619117,10859650,10961140,10961193,7200560,8626961,7200561,8626989,11037170,11037179,11037180,4430168,3238242,10858116,8624664,10839812,8624772,8615709,10941765,10840959,10856669,10101649,11010523,11010524,11010525,10857166,10857167,10857168,10857169,10857170,10857171,10857172,10857173,10857174,10857175,10857176,10857177,10857178,10857179,11046901,10839204,8624496,8624497,8624503,8624504,8624505,8624507,11044672,8612121,8612652,10619973,10620114,8632767,8632768,3230763,10850676,8633192,8633193,8633228,10930637,10991416,8540433,10426288,10930884,10991691,10991692,8541003,10992239,8541258,8541260,10616794,10616795,10616842,8611712,8611713,8611714,8611715,10616906,8611716,8611717,8611724,7057465,9211521,9211522,10612380,10612407,10609443,10609444,7058151,10609707,10609990,8852318,8852323,9914854,9914855,8849355,8849356,8849357,8592748,10117873,8849892,6674625,9912797,9186789,10512663,10512664,10512665,10512666,10512667,10512668,10512669,10512670,10512671,10512672,10512673,10512674,10512675,9171049,9171054,10517012,10517013,10517014,10517015,10517016,10517017,10517018,10517019,10517025,10517026,10517027,7014206,7014207,10419908,10419909,10419910,10419911,10419912,10419913,10419924,10419925,10419932,10419933,10419934,10419935,10419936,10419937,10419938,10419945,10419946,10419947,10419948,10419949,10419950,10420173,10420174,10420175,10420176,10420177,10420178,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420192,10420193,10420194,10420195,10420196,10420197,10420198,10420199,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10420213,10420214,10420215,6666464,9198928,8550089,8917758,10888902,10632301,10627724,10627725,10627726,10627727,10630084,10630104,10900695,10167045,10167046,10167048,10167050,10167056,10167059,10167128,10167154,10167170,10167194,10167195,10167196,10167197,10167212,10167325,10167329,10167337,10167348,10167353,10887195,10602248,10603510,10579807,10579808,10528134,10528135,10528136,10528137,10528179,10528180,10546434,10524840,10551007,10421503,10508537,10420856,10507756,10407937,10411981,10411982,10411983,10411984,10411985,10411986,10411987,10411988,10411989,10411990,10411991,10411992,10411993,10411994,10482010,10474011,10482020,10482021,10482022,10415157,10415158,10415159,10415160) 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>