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(8574517,8574521,3228908,3228944,3228945,3228959,3229106,3229107,3229108,3229109,3229110,3229111,3229112,3229113,3229114,3229115,3229116,3229117,3229118,3229177,3229178,3229179,3229180,3229181,3229182,3229280,7065986,7065987,7065988,7065989,7065990,7066238,7066267,10849985,10863023,7201202,7201203,7201204,7201205,7201206,7201207,7201208,7201209,7201210,7201211,7201212,7201905,7201906,7201970,7201977,7202683,7202684,7202685,7202686,7202687,7202688,7202689,7202690,7202691,7202692,7202693,7202694,7202695,7202696,7202697,7202698,7202767,3227185,3227206,10857284,10857285,8834762,8834763,7198725,10101486,10101487,3923479,3923480,3923481,3923593,8554309,8554350,8554362,10854258,10854259,10854260,10854261,10838807,10838808,10838925,7197608,7197619,7197621,7197630,7197633,7197635,7197636,7197639,7197640,7197641,7197644,7197649,7197651,7197654,7197657,7197660,7197661,7197663,7197664,7197667,7197668,7197671,7197672,7197674,7197676,7197679,7197681,7197682,7197899,7197900,7197901,7197902,7197903,7197904,7197905,7197906,7197907,7197908,7197909,7197910,7197911,7197912,7197913,8905329,3922823,10620119,10620120,10615258,8540596,10616469,10616470,10616471,10616472,10616473,8611398,9165541,10714129,10611367,10611368,10611369,10611370,10559766,10611708,10611709,10611710,10611711,10611712,10611713,10611714,10611819,10612051,8851565,8851566,8862508,8862509,10610046,8567072,8567073,10610396,10610397,10117821,10117822,10117823,9169750,9912157,9912158,9912159,9912160,6674190,9912217,6674249,6674323,6674326,9178427,8552222,8851012,8851020,9168349,9168510,6673078,6673080,6673105,10471014,10471015,976485,6671918,10468337,10468338,10468339,10468340,9167782,9168284,9168285,9168286,9168287,9168288,9168289,9168290,9168291,9168292,9168293,9168294,10888842,10888843,10888844,10888845,10888846,10888847,10888848,10888849,10888850,10889060,10889323,10889324,10889325,10889326,10889327,10889328,10889329,10889330,10889331,10889332,10889333,10889334,10889335,10889336,10889337,10889338,10889339,10889340,10884518,10884519,10884520,10884521,10884522,10884523,10884524,10884525,10884526,10884527,10884528,10884529,10884597,10884933,10874992,10875004,10875005,10875006,10875007,10875008,10875009,10875010,10875011,10875012,10875014,10875015,10875016,10875017,10875018,10875019,10875020,10875021,10875022,10875023,10875024,10875025,10875026,10875027,10875028,10875032,10875033,10875034,10875035,10875036,10875037,10875038,10875039,10875040,10875041,10875042,10875043,10875044,10875045,10875046,10875047,10875048,10890105,10890106,10890107,10890108,10890109,10890110,10890111,10890112,10890113,10890114,10890115,10890116,10890117,10890118,10890119,10890120,10890121,10890122,10890123,10890124,10890125,10885147,10885148,10890161,10890162,10890173,10890174,10890175,10890208,10890209,10890210,10890211,10890212,10885465,10885468,10885469,10888298,10888309,10885526,10161948,10885955,10881554,10876593,10876600,10897001,10897014,10897040,10897051,10897075,10897115,10897198,10887204,10887217,10882360,10601964,10601983,10601985,10601997,10602005,10602036,10602077,10647430,10647431,10647432,10647433,10647434,10647470,10647471,10601732,10601756,10601760,10601787,10601805,10601910,10601930,10601947,10527750,10522838,10508332,10508333,10508334,10508335,10508408,10508501,10508502,10508503,10507560,10507561,10507562,10508606,10507675,10507676,10507937,10508002,10508009,10508010,10508011,10508012,10508034,10407448,10410020,10410021,10410022,10412047) 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>