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(10870262,10870264,10870337,10870343,10861535,3228986,8631350,8631351,8631352,8631353,8631354,8631358,8631367,8631368,8631369,8631370,8631372,8631373,8631374,10940374,10849196,11041671,11041672,10847150,10977241,10977242,10862854,8561088,10929506,8620176,8573607,8620497,10962418,10962419,10962420,10962421,10870064,10870141,10870143,6000283,6000284,6000285,6000286,8065087,10842877,10842879,10842885,10842886,10842887,8559171,10103458,8911421,8836010,10858917,10103928,7073297,8619207,8837046,8560523,10971620,10971621,10971622,10971623,10971624,10971625,10971626,10971627,7071015,10971725,10984776,10971813,10971944,10971945,10971946,10971947,10971948,10985010,10985011,10985040,10985041,10985054,10985055,10972059,7071384,10972086,10102555,10959182,10972325,10972326,10972358,10959561,6000194,6000195,6000196,6000197,6000198,6000199,3235593,8615211,10983727,10983728,10101211,10983797,8615980,3236567,3236569,8615986,3236579,10941799,3236612,11035915,11035917,10101428,10841281,10841282,10984262,10984263,10984264,10984265,10984266,10984267,10984268,10984269,10984270,10984271,10984272,10984273,10984274,10984275,10984282,10984284,8626403,10984540,8612787,10923545,11045776,11045777,11045778,11045823,11045824,11045825,11045826,11045827,11045828,11045846,11045860,8613139,11046051,8554610,3924344,11046651,8907433,10982100,11047245,11047246,11047247,11047275,11047323,11047324,11047328,10619891,10622093,8611931,8541717,10837222,10617506,8542168,10615115,10615128,10615129,10615133,10615152,10615153,3230733,10620348,3581928,3581929,10926253,3582191,8633707,8633708,8633709,9217738,8633895,8633896,8633897,8633898,8633899,8633900,8633901,8853130,10611162,10614210,9181565,9181619,9181620,9181621,9181622,9181623,9181624,10559438,7019546,7019547,7019548,7019549,7019550,7019551,7019552,7019553,7019824,7019825,7019826,7019827,7019828,7019829,7019830,7019831,7019832,7019833,9166198,6675601,6675644,9211820,9914083,6676204,9914290,9914323,9914403,8566987,8566988,9196519,9188623,9196758,9196759,8863293,10610676,9197014,9197015,8853103,8853116,9177671,9177672,9177673,9177674,9177704,8592892,9912091,9177896,8849927,8849928,8849929,10513994,10513997,10513998,10513999,7056382,6674433,9186640,9186641,9186642,9186643,7056987,7056988,7057074,7057075,7057076,9186924,9186925,9186926,7024934,9168432,10416417,10415429,9176866,8848735,9176922,9176924,8848795,8848813,8848838,8848863,8864895,10463023,10463025,10463026,10463027,10463035,4971934,10469920,10123568,8847284,8847513,8847566,8550898,10124089,9208034,8848111,10883556,10883619,10883703,10903744,10903896,10903897,10628422,10903977,10174994,8594118,8594155,8594156,8594157,8594167,8594168,8594169,10170601,10170602,10899688,10879847,10170916,10170917,10879906,10879910,10166649,10166650,10166651,10166652,10166653,10166677,10166795,10166910,10876001,10876002,10876003,10167021,10167153,10167154,10896332,10630854,10630855,10896412,10162783,10162784,10162807,10162808,10162809,10162810,10162811,10162821,10162837,10162839,10882298,10907433,10568112,10568113,10568114,10568115,10568116,10568117,10568118,10568119,10568120,10568121,10568122,10568123,10568124,10568125,10568126,10568127,10649404,10649405,10568527,10568528,10568529,10568530,10568531,10568532,10602710,10602715,10602731,10584522,10584523,10584524,10584525,10603697,10606747,10606898,10606924,10607000,10604085,10591722,10601685,10591949,10601009,10568110,10568111,10525193,10525232,10525233,10525234,10525283,10537535,10541677,10541678,10541679,10529970,10530354,10530355,10524418,10524419,10524420,10524421,10524541,10524542,10524543,10524544,10524545,10524546,10524547,10524548,10528769,10540887,10508185,10508186,10508187,10508188,10508189,10506574,10506575,10506576,10421978,10421979,10422011,10422052,10422109,10413438,10479179,10478223,10478226,10478227,10493251,10493252,10493253,10493254,10493255,10493396) 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>