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(8575260,10847441,10964465,10964466,10964467,10964468,10964469,10964470,8837875,3238537,3238538,7072512,7072513,8618819,5654831,11013390,11013391,11013392,11013393,11013394,11013395,11013396,11013397,11013398,10102098,7071081,4430350,10102887,4430419,4430425,4430433,4430436,4430438,4430453,4430497,3926015,3926016,3926017,11022682,11022683,11022684,11022685,11022686,11022687,11022688,11022689,11022690,3926605,3926700,3926721,10997027,10997028,10997029,3926886,8909644,8909645,8909646,8909647,8909648,8909649,8909650,8909651,8909652,10997337,10997338,10997339,10997340,10997341,10997342,10997343,11010528,11010548,11032748,11045786,11045787,11045788,11045789,11045790,11045791,11045792,11045793,11045794,11045795,8613018,10918725,10918726,8554467,10968242,8554695,11020471,11020472,11020473,11020474,11020475,11020476,10994774,10919728,10919729,10919730,10919731,10919732,10919733,10919734,11005620,11005621,11005622,11005623,11005624,10917586,10917587,10917588,10917589,10917590,10917591,10917592,10917593,10917594,8541870,11019545,11019546,11019547,11019548,11019549,11019550,11019551,11019552,11019553,11019554,11019555,11019557,10918423,10918424,10918425,10918426,10925501,8576876,8576877,8576878,11004492,8540446,9217881,8540887,8541350,11005619,9165413,7059728,9190126,9190127,9187508,9187840,9187841,9187842,9187843,9172030,8851930,9172346,9172354,10610093,9204928,9915203,10517754,10517755,10517756,9169968,9169969,9169970,9169971,9170638,10427697,6680702,6680703,6680704,6681150,6681155,6681322,6678525,6678526,8854180,8854181,8854182,8854183,8854184,8854185,9916688,9916689,8917122,9183805,6680029,6680030,6680031,6680032,9200282,9200283,10179714,10179715,10179716,10179717,10179718,10913778,10913779,10913780,10913781,10913782,10913783,10913784,10913785,10913786,10913787,10913788,10913789,10913790,10913791,10913792,10913793,10908796,10883908,10179948,10175053,10904570,10904571,10904572,10904573,10904574,10904575,10914857,10914858,10914859,10905115,10905116,10913305,10174337,10893366,10893367,10893368,10181717,10891118,10172331,10172332,10172333,10626181,10589896,10590405,10590406,10567348,10567349,10567350,10567351,10567352,10567353,10567360,10546089,10546090,10546091,10546092,10546109,10546110,10546111,10546112,10508170,10483995,10483996) 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>