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(10943606,10943609,7076344,7076346,7076347,7076351,8066996,8622732,10931552,3237418,3927886,3927890,10943380,10943384,10943386,10943390,10943391,10943393,8614771,10863333,8625128,10855895,10101421,10101422,7200034,10942430,7200143,7200148,11006624,11006625,11006632,11006633,11006634,11006635,11006687,11006692,11006693,11006695,11006698,11006700,11006703,11006704,11006708,11006709,11006710,11006711,11006712,11006715,11006719,10928609,10928613,10928614,10618316,8613193,10838652,10838654,3234380,3234381,3234383,10838790,11046901,11046904,11046910,11046911,11046915,11046916,11046920,11046925,11046926,11046927,11046931,11046932,11046936,11046937,11046941,11046942,11046943,11046944,11046945,11046946,11046947,11046951,11046952,11046953,11046956,11046957,11046959,11046960,11046961,11046962,11046963,11046964,11046965,11046966,11046967,11046969,11046970,11046971,11046973,11046974,11046975,11046977,11046980,11046981,11046982,11046988,11046989,11046990,11046991,11046994,11046995,11046998,11046999,11047000,10617039,10953991,11045267,11006614,11006615,3230670,10848477,10848479,10848480,10848492,10848494,10848497,10921416,10921418,10921424,10921425,9213772,9213773,9213774,9213775,9213783,9213784,9213797,9213798,9213801,9213802,9213803,9213804,9213805,9213806,9213807,9213808,9213809,9213810,9213812,9213817,9213823,9213830,9213831,9213837,9213839,9213843,9213844,9213851,9213853,9213859,9213862,9213863,9213864,9213867,9213868,9213870,9213872,9213877,9213881,9213882,9213884,9211961,8851979,9196161,9172164,9164772,9164773,9185772,10126137,10126141,10126145,10126146,10126147,10126152,10126156,8593232,8593233,10118294,10118295,9910572,8918318,10416863,10416865,8549903,10463415,4972586,4972587,4972588,10946349,10889282,10890047,10172151,10644273,10644274,10644275,10599454,10599472,10599490,10599498,10599520,10599530,10599533,10599556,10599584,10599593,10599613,10599619,10599635,10599655,10599657,10599662,10599664,10599670,10599673,10599674,10599675,10599689,10599690,10599698,10599705,10599706,10599707,10599711,10599781,10599786,10599789,10599817,10599845,10599846,10599847,10599848,10599850,10599865,10599873,10599874,10599875,10599894,10599897,10599910,10599913,10599914,10599915,10599916,10599917,10599918,10599919,10599920,10599921,10599922,10599923,10599924,10599925,10599926,10599927,10599928,10599929,10599930,10599931,10599932,10599957,10599963,10599964,10599965,10599966,10599967,10599968,10599969,10599970,10599971,10599972,10599973,10599974,10599975,10599976,10599977,10599978,10599979,10599980,10590996,10600030,10600033,10600042,10600043,10600048,10600049,10600053,10600054,10600055,10600056,10600057,10600058,10600059,10600067,10600090,10600097,10600116,10600122,10600124,10600126,10600127,10600130,10600131,10600152,10600169,10600178,10600195,10600199,10600200,10600201,10600202,10600203,10600204,10645398,10425268,10425272) 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>