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(9214765,10939798,10939799,8621376,8621596,10863208,10863209,8561023,10929398,10961968,10961969,3227763,8629994,3227767,8573543,7067432,7067433,7067434,7067435,7067436,7067437,7067438,7075544,7075545,7075745,10843051,10843052,10843053,7201635,7064401,11012224,11012225,11012226,3899168,3899169,3899170,3899171,10103965,8595498,8065964,8066073,8066078,10867965,10933251,10857293,10865386,10865387,3927683,10943105,8835119,10102868,10840384,10840385,10840386,10840387,10840645,10840646,10840747,8557178,7199779,7199780,10856835,11048616,11048617,3927138,10853265,10853266,10853267,10853268,8612984,10968159,10968160,3924093,8555088,8555089,8555090,8555229,10619562,10619563,10619564,10619565,10619566,10619567,10619568,10619569,10619570,10619571,10619572,10619573,10619574,10619575,8541571,8541572,8541573,8612563,11045475,11045476,11045477,11045478,11045479,11045480,11045481,11045482,11045483,11045484,11045485,10620005,8609895,8609896,10615224,10964894,10964895,10964896,10964897,10964898,10964899,10964900,10964901,10964902,10964903,10964904,10964905,10964906,10964907,10964908,10964909,10964910,10964911,10964912,10964913,10964914,10964915,10964916,10964917,10964918,10964919,10964920,10964921,10964922,3581950,10965737,10965738,10965739,10921607,10965995,10965996,10965997,10965998,10966252,10966253,10966254,10966255,10966256,10966257,10966258,10992585,10992586,10992587,10992588,10992589,10992590,7027038,8864207,9173795,10122157,7057476,10119616,7025123,9211917,8566675,8862892,8862893,7026205,3653795,9220570,9220571,9220572,9220573,7026399,7026595,7018641,9197082,9173134,8567709,7026864,8853038,7022978,8592735,8592736,7055994,7055995,7055996,7055997,7055998,7055999,7056000,7056104,9209976,9186057,7023724,4975118,7023922,9186361,9186362,9186363,6674657,7024334,9912973,8552246,8552247,8552248,8552249,8552250,8552251,8552252,8552253,8552254,8552255,8552256,8552257,8552258,8552259,8552260,8552261,8552262,8552263,8552264,8552265,8552266,8552267,8552268,8552269,8552270,8552271,10119486,10427770,7022074,10418685,10418686,4971194,4971195,4971196,4971197,4971198,4971199,4971200,4971201,4971202,4971203,4971204,4971205,4971206,7020053,4971326,9174688,9174689,9174690,9174691,9174692,9174693,9174694,9174695,9174696,9174697,9174698,9174699,9174700,9174701,9174702,9174703,9174704,7020581,6667161,6667162,9175333,9175334,9175367,6667447,9175516,9175605,9199903,9208021,9208022,976028,976029,7021868,9200228,9200229,9200230,9200231,9200232,9200233,9200234,9200235,9200236,9200237,9200238,10903715,10903716,10909385,10909386,10909387,10909388,10909389,10163609,10163610,10163835,10892933,10892934,10892935,10892936,10913241,10913242,10913243,10905764,10172048,10172049,10172050,10172051,10172052,10631675,10631706,10608612,10608613,10568925,10568926,10568927,10568928,10568929,10568930,10568931,10568932,10568933,10568934,10568935,10587171,10587172,10650854,10650855,10650856,10650857,10604040,10651365,10651366,10651367,10651368,10651369,10651370,10648578,10648579,10579653,10579654,10529557,10529558,10529559,10529560,10529561,10529562,10529563,10529564,10529565,10529566,10529567,10529568,10529569,10529570,10529571,10529572,10529573,10529574,10529575,10529576,10529577,10529578,10529579,10529580,10529867,10545975,10545976,10545977,10545978,10521998,10538416,10538418,10554547,10528595,10522770,10522771,10522772,10522773,10532952,10498734,10498735,10409451,10409452,10409453,8562513,10411750,10412056,8563177,10476820,10476821,10476822) 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>