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(11002226,11002227,11002228,11002229,11002230,11002231,11002232,11002233,11002234,8631348,8631349,8631350,8631351,8631352,8631353,8631354,8631355,8631356,8631357,8631358,8631359,8631360,8631361,8631362,8631363,8631364,8631365,8631366,8631367,8631368,8631369,8631370,8631371,8631372,8631373,8631374,8631375,8631376,8631377,8631378,8631379,11002471,8575046,11002794,11002795,11002796,11002797,11002798,11003020,10437248,11042295,10460413,8619777,8573290,7075187,7075188,8837763,11040036,11040115,11040172,11040173,11040202,8591853,11027333,11014390,8630444,8630445,8627658,8627659,8627660,8627661,8627662,8627663,8627664,8627665,8627666,8627667,8627668,8627669,8627670,8627671,8627672,8627673,8627674,8627675,8627676,8627677,8627678,8627679,11024796,11024952,11037975,11037988,11038170,11038171,11038172,11038190,11038215,11038303,11038304,11038305,7072755,11038456,11038463,8559744,8559749,11038523,11038540,11038541,11038706,11038707,11038708,11038709,11038710,8572445,11039010,11039012,11039013,11039014,8572530,10932966,10961508,11013560,11013561,11013581,11013590,11013591,7200407,8064652,11037575,11037610,11034690,11034691,11034692,11021731,11021732,11035204,11035205,3236398,10840772,10840773,11023046,11023047,11023577,11019946,8613478,8613479,11033754,11034216,11034217,11034218,7158078,10922520,10922521,10922522,10922523,10966823,10966849,11032040,11032057,8612746,11003683,11003684,11003685,11003686,11003687,11003688,11003689,11003690,10620044,10620045,11003837,8576378,8576394,11016932,11016933,9217412,9217413,9217414,11004693,8577198,8577362,10616225,8577396,8577425,8577446,8577447,8577463,8577464,8577471,8577477,8577490,8577495,8577507,8577524,8577540,10966059,8577567,10966130,10966131,10966132,10966133,10966134,10966135,10966136,10966137,10966138,10966314,10966315,10966457,10966458,10966459,10966460,10966461,10966462,10966463,10966464,8853244,8853673,8853674,10614566,8853757,10611624,8864623,10122337,7025081,9220306,10558562,10558563,7026550,7059069,8853024,8853026,9161515,10125868,10125869,4974619,4974620,4974642,9169846,7056155,7023692,7023818,10516476,10516478,10516479,10516480,10516481,10516484,10516698,10516699,10516700,10516701,10516702,10516703,9210939,9210940,8552502,4973186,8854394,9916962,9916965,7020503,8854697,8854913,8854915,8854950,8855021,8855028,8855030,8855037,8855039,8855043,9175520,9207596,9175638,9175639,9175672,9175673,9191919,10116141,10116142,10116143,10116144,10169707,10169708,10169778,10169806,10169859,10169860,10169911,10169912,10169913,10629120,10629150,10629151,10168832,10163849,10168866,10885512,10905532,10187746,10187747,10187748,10583755,10590621,10590622,10654200,10654201,10654202,10654203,10654204,10604002,10604003,10588687,10586002,10545425,10545426,10545427,10553475,10553502,10545520,10545521,10545522,10545523,10545524,10529735,10529736,10529737,10529738,10529739,10529740,10529741,10529742,10529743,10529744,10529745,10529746,10529747,10529748,10529749,10529750,10529751,10529752,10529753,10529754,10529759,10529764,10529768,10529769,10529770,10529771,10529772,10529773,10529774,10529775,10529776,10529777,10529778,10529792,10529794,10529799,10529800,10529801,10529823,10529824,10529825,10529826,10529827,10522043,10522044,10522045,10522046,10548082,10548083,10548084,10548085,10548086,10544445,10551053,10551054,10551055,10551056,10551057,10551058,10509828,10509829,10509830,10509831,10504869,10504870,10479290,10479291,10479292,10479293,10479294,10479295,10479296,10479297,10479298) 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>