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(10848823,8583099,10849118,10849119,10950690,10849398,10849399,10849400,10849401,10849402,10849403,10849404,10849405,10849406,10849407,10849408,10849409,10849410,10849411,10849412,10849413,10849414,10849415,10849416,10849417,10849418,10849419,10849420,10849421,10849422,10849423,10849424,10849425,10849426,10849427,10849428,10849429,10849430,10849431,10849432,10849433,10849434,10849435,10849436,10849437,10849438,10849439,10849440,10849441,10849442,10849443,10849444,10849445,10849446,10849447,10849448,10849449,10849450,10849451,10849452,10849453,8594663,7064042,3238533,3238534,4967032,5654536,10865543,7200940,7200941,7200942,7200943,7200944,7200945,7200946,7200947,7200948,7200949,7200950,7200951,7200952,7200953,7200954,7200955,7200956,7200957,7200958,7200959,7200960,7200961,7200962,7200963,7200964,7200965,7200966,7200967,7200968,7200969,7200970,7200971,7200972,7200973,7200974,7200975,7200976,7200977,7200978,7200979,7200980,7200981,7200982,7200983,7200984,8565290,8624548,10615274,10991757,10991758,10991759,10991760,8904309,8904310,8904311,8904312,8904313,8904314,8904315,8904316,8904317,8904318,8904319,8904320,8904321,8904322,8904323,8904324,8904325,10852146,10714021,6669949,3962366,6674004,9169898,8551328,8565545,9160355,9910587,9910588,9910589,9910590,9910591,10428052,8848627,8848628,8848629,8848630,8848631,8848632,8848633,8848634,8848635,8848636,8848637,8848638,8848639,8848640,8848641,8848642,8848643,8848644,8848645,8848646,8848647,8848648,8848649,8848650,8848651,8848652,8848653,8848654,8848655,8848656,8848657,8848658,8848659,8848660,8848661,8848662,8848663,8848664,8848665,8848666,8848667,8848668,8848669,8848670,8848671,8848672,8848673,8848674,8848675,8848676,8848677,8848678,8848679,8848680,8848681,8848682,8848683,8848684,8848685,8848686,8848687,8848688,8848689,8848690,10418787,8848691,8848692,8848693,8848694,8848695,8848696,8848697,8848698,9161148,8549545,8549546,8550068,10115634,10115635,7013833,7013834,7013839,7013840,7013841,7013842,7013869,7013870,10884487,10875056,10875057,10875058,10875059,10875060,10875061,10875062,10875063,10875064,10875065,10875066,10875067,10875068,10875069,10875070,10875071,10875072,10875073,10875074,10875075,10875076,10875077,10875078,10875079,10875080,10875081,10875082,10875083,10875084,10875085,10875086,10153866,10887344,10602253,10602254,10602255,10602256,10602257,10602258,10602259,10602260,10602261,10602262,10602263,10602264,10643475,10602265,10602266,10602267,10602268,10602269,10602270,10602271,10602272,10602273,10602274,10602275,10602276,10602277,10602278,10602279,10602280,10602281,10602282,10602283,10602284,10602285,10602286,10602287,10602288,10602289,10602290,10602291,10602292,10602293,10602294,10602295,10602296,10602297,10602298,10602299,10602300,10602301,10602302,10602303,10602304,10602305,10602306,10602307,10602308,10602309,10602310,10602311,10603507,10534203,10538410,10538415,10538497,10486618,10486619,10486620,10486621,10486622,10486623,10486624,10486625,10486626,10486627,10486628,10486629,10486630,10486631,10486632,10486633,10486634,10486635,10486636,10486637,10486638,10486639,10486640,10486641,10486642,10486643,10486644,10486645,10486646,10486647,10486648,10486649,10486650,10486651,10486652,10486653,10486654,10486655,10406996,10406997,10406998,10406999,10407000,10407001,10407002,10407003,10407004,10407005,10407006,10407007,10407008,10407009,10407010,10407011,10407012,10407013,10407014,10407015,10407016,10407017,10407018,10407019,10407020,10407021,10407022,10407023,10407024,10407025,10407026,10407027,10407028,10407029,10407030,10407031,10407032,10407033,10407034,10407035,10407036,10407037,10407038,10407039,10407040,10407041,10407042,10407043,10407044,10407045,10407046,10407047,10407048,10407049) 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>