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(7076001,7076002,10962695,8838591,11015032,11015033,11041373,3229152,7068757,7068758,11041645,11041646,11015687,11015688,11015689,11015690,11015691,11015692,11015693,11015694,11015695,11015696,11015697,11015698,11015699,10849684,11016276,11016277,11016278,11016279,11016280,11016316,11016317,10977320,10862989,10844775,11013772,7075208,11040035,11040112,11040201,8620500,11014509,11014510,11014511,11014512,10858261,7201265,7201293,8911148,8911552,8911553,11012364,11012365,11012366,11012378,11038535,11038630,11038631,11012837,10859538,8560342,10104568,10104852,8629521,7073890,10866002,8835237,8835238,10102916,11011487,10998533,11037551,11037552,8615064,10855638,8565035,10942276,11019677,10623407,8613426,8613427,8613428,8613429,10920027,10920028,10920029,7197828,10966716,7156381,10850952,10850953,10850954,10850955,10850956,10850957,10850973,10850974,10850975,10850976,10850977,10926237,10926238,3231132,10851073,10848565,10952745,10917012,9189311,8568102,10611351,7059886,9173909,9173910,9173911,9173912,8853763,8853764,8853765,8853766,8853770,8853771,8853772,8853773,8853774,8853775,8853776,8853777,8853785,8853786,8853787,8853788,8853789,8853790,8853791,8853792,8853793,3655292,3655293,3655294,3655295,9214201,9913559,9187385,8542603,8542604,7057960,9211802,8851940,8851941,9212264,8852127,8852131,9189113,6677448,9193347,9193348,10125554,989946,989950,4974423,9193598,10125884,10125885,10125886,8592986,8592987,8849707,9177963,9177964,9177965,7023673,8850185,8850351,7024668,10518940,10518941,10518942,10518943,10518944,10518945,10518946,10518947,10518948,10518949,10518950,10518951,10518952,10518953,10518954,9171197,10416554,8864948,8854952,6679420,3963598,9191293,9191294,6679522,9175556,9175563,9207665,9207753,9199767,9207860,6668154,8593538,10179735,10179736,10159791,10159792,10159793,10159794,10159795,10159796,10159797,10159798,10159799,10159800,10159801,10179801,10159802,10179802,10159803,10159804,10159805,10159806,10159807,10159808,10159809,10159810,8069149,10170920,10915453,10915454,10915455,10915456,10915457,10877576,10882832,10163892,10163893,10163894,7001125,10913355,10913360,10179444,10179445,10181669,10896439,10177546,10177547,10177548,10177764,10177765,10177793,10631297,10631821,10882345,10173390,10173391,10173392,10173393,10173394,10173395,10173396,10173397,10601269,10601270,10601271,10584205,10584206,10587457,10587458,10587459,10587460,10650733,10650734,10650735,10650736,10650737,10650738,10650739,10650740,10650741,10570092,10588392,10588393,10588394,10588395,10588396,10588397,10588398,10588399,10654609,10654610,10648745,10648746,10651856,10523671,10407232,8562751,10496852,10496853,10410798,10412803) 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>