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(8838636,3228621,8621333,8621334,4970749,4970751,10944069,10944070,10950382,10940458,10871163,10871164,10950560,10933321,8067294,8067295,8067296,8067297,8575522,8575884,8575885,8575886,10850061,4969589,4969590,4969591,8620306,8837988,8837989,8837990,10930054,10939424,10873188,7072095,7072096,8065188,8065189,8065190,10932106,3899416,10960607,8836509,11026055,11013167,8629193,8629194,8629195,8573025,8573026,8560815,10857300,11049072,11049073,8910323,10959224,10858145,10998581,10998582,10998583,10998584,10998585,8624847,11035842,8626058,7156941,8554811,8613759,8555001,8555280,10995204,10852707,8553791,7156391,10425589,10425590,8633259,10426022,3231081,10921640,10921641,10921642,10921673,10978824,10621226,10621227,10621228,10926744,11005423,8568104,8864388,8864389,3655301,6670317,10119686,10119687,10119689,8862150,8862151,7057970,8863305,6677453,6677454,6677455,9911536,10125582,10515429,10515430,10515431,10515432,8849531,8849532,8849533,8849534,8849535,8849536,8849537,8849538,8849539,8849540,8849541,8849542,8849543,8849544,8849545,8849546,8849547,8849548,8849549,8849550,8849551,8849552,8849553,8849554,8849555,8849556,8849557,8849558,8849559,8849560,8849561,8849562,8849563,8849564,8849565,8849566,8849567,8849568,8849569,8849570,8849571,8849572,8849573,8849574,8849575,8849576,8849577,8849578,8849579,8849580,8849581,8849582,8849583,8849584,8849585,8849586,8849587,8849588,8849589,8849590,8849591,8849592,8849593,8849594,8849595,8849596,8849597,8849598,8849599,8849600,8849601,8849602,8849603,8849604,8849605,8849606,8849607,8849608,8849609,8849610,8849611,8849612,8849613,8849614,8849615,8849616,8849617,8849618,8849619,8849620,8849621,8849622,8849623,8849624,8849625,8849626,8849627,8849628,8849629,8849630,8849631,8849632,8849633,8849634,8849635,8849636,8849637,8849638,8849639,8849640,8849641,8849642,8849643,8849644,8849645,8849646,8849647,8849648,8849649,8849650,8849651,8849652,8849653,8849654,8849655,8849656,8849657,8849658,8849659,8849660,8849661,8849662,8849663,8849664,8849665,8849666,8849667,8849668,8849669,8849670,8849671,8849672,8849673,8849674,8849675,8849676,8849677,8849678,8849679,8849680,8849681,8849682,8849683,8849684,8849685,8849686,8849687,8849688,8849689,8849690,8849691,8849692,8849693,8849694,8849695,8849696,8849697,8849698,8849699,9170162,9170241,8551921,9178883,9208977,9190664,10123017,10123018,8917202,9207707,6672081,10466498,10466499,10116176,10116177,10116178,10116179,9208059,9208067,10159892,10159935,10159936,10159960,10884794,8069166,10170850,10170851,10947859,10947860,10947861,10947862,10947863,10885072,10173506,10173507,10173508,10173509,10173510,10173511,10173512,10173513,10173514,10173515,10173516,10173517,10183527,10183528,10158673,10158674,10158675,10627356,10627357,10627358,10627359,10907874,10907875,10907876,10907877,10907878,10907879,10907880,10907881,10907882,10907883,10171609,10949168,10949930,10646242,10646243,10646244,10646245,10646246,10646247,10646248,10643472,10646585,10646586,10650274,10650275,10650276,10650277,10650890,10650891,10604196,10604197,10604198,10604199,10604200,10604201,10604202,10604203,10604204,10604205,10604206,10604207,10604208,10604209,10604210,10604211,10604212,10604213,10604214,10604215,10607655,10607656,10607657,10607658,10651871,10651872,10543329,10543330,10544437,10544438,10544439,10509339,10422701,10422702,10506668,10423904,10505923,10505924,10505925,10407495,10488212,8562766,8562767,10479609,10412063,8563123,10412715) 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>