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(10939594,7068181,3229088,8583235,4968187,10849850,10938478,8573305,3227606,3227607,3227608,3227609,3227610,8594789,8594790,7064542,7064543,7064544,7064545,7064546,7064547,7064548,7064549,7064550,7064551,7064552,7064553,10104037,10857375,8064729,8064730,8064731,8064732,3235778,8556314,7200144,7196255,7196256,10618263,10618264,7196556,7196557,7196558,7196559,7196560,7196561,7196562,7196563,7196564,7196565,7196566,7196567,7196568,7196569,7196570,7196571,7196572,8554365,3232888,10837226,3922919,3922920,10954392,10954393,10954394,10954395,10954396,10954397,10954398,8905963,8905964,10850944,10850945,10850946,10850947,10850948,10850949,10850950,10850951,10850952,10850953,10850954,10850955,10850956,10850957,10850958,10850959,10850960,10850961,10850962,10850963,10850964,10850965,10850966,10850967,10850968,10850969,10850970,10850971,10850972,10850973,10850974,10850975,10850976,10850977,10850978,10850979,10850980,10850981,10850982,10850983,10850984,10850985,10850986,10850987,10850988,10850989,10850990,10850991,10850992,10850993,10850994,10850995,10850996,10850997,10850998,10850999,10851000,10851001,10851002,10851003,10851004,10851005,10851006,10851007,10851008,10851009,10851010,10851011,10851012,10851013,10851014,10851015,10851016,10851017,10851018,10851019,10851020,10851021,10851022,10851023,10851024,10851025,10851026,10851027,10851028,10851029,10851030,10851031,10851032,10851033,10851034,10851035,10851036,10851037,10851038,7154551,8904483,8904484,8904485,8904486,8904487,8904488,10122053,10122059,10611729,10611730,10611854,10612364,6676012,6676013,6676027,6676035,6676036,6676040,6676042,6676043,6676044,6676045,10612543,9205270,9205272,9205273,9205275,9205281,9205282,9205284,7015376,7015377,7015378,7015379,7015380,7015381,7015382,7015383,7015384,7015385,7015386,7015387,8849707,8849708,8849709,8849710,8849711,8849712,9161952,9161953,9161954,9161955,9161956,9161957,10118234,10516128,10516129,10516130,10516131,10516132,10118598,8552235,6675197,6675198,6675199,6675200,6675201,6675202,6675203,6675205,6675206,6675207,6675211,6675212,6675213,6675219,6675220,6675221,6675225,6675227,6675228,6675230,6675231,6675238,6675239,6675240,6675245,6675246,6675247,6675251,6675252,6675253,6675254,6675256,6675257,6675259,6675262,6675263,6675264,6675266,6675267,6675270,6675271,6675272,6675273,6675274,6675275,6675276,6675277,6675278,6675279,6675280,6675281,6675284,6675286,6675287,6675288,6675289,6675290,6675291,6675292,6675296,6675299,6675301,6675302,6675303,6675306,6675311,6675312,6675313,6675315,6675316,6675318,6675322,6675352,6675361,6675373,6675374,6675375,6675391,6675392,6675404,6675431,6675432,6675438,6675439,6675475,6675479,9168302,9910899,9910900,6673108,6670855,10464189,10464190,10464191,10464192,10464193,10464194,10464195,10464196,10464197,10464198,10464199,10464200,10464201,10464202,10464203,10464204,10116240,10116241,10116242,10116243,10116244,10116245,10116246,10116247,10946563,10946564,10946565,10890000,10877494,10877495,10877496,10877497,10877498,10877499,10877500,10877501,10877502,10877503,10877504,10877505,10877506,10877507,10877508,7000698,10877509,10877510,10877511,10877512,10877513,10877514,10877515,10877516,10877517,10877518,10877519,10877520,10877521,10877522,10877523,10877524,10877525,10877526,10877527,10887957,10888274,10888317,10161940,10644510,10644511,10644512,10644513,10647601,10606922,10604388,10604389,10604390,10604391,10604392,10604393,10604394,10604395,10604396,10604397,10604398,10604399,10604400,10604401,10604402,10604403,10604404,10604405,10604406,10604407,10604408,10604409,10604410,10604411,10604412,10604413,10508316,10498500,10407358,10408143,10408144,10408145,10408146,10408147,10408148,10408149,10408150,10408151,10408152,10408153,10408154,10408155,10408156,10714578) 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>