- - Select Company - - View all SELECT client_infoen.clientname_short, client_info.code FROM client_infoen, client_info where client_info.status='A' and client_infoen.clientid in (select clientid from function1 where function1.status='Y') and client_infoen.clientid = client_info.clientid order by clientname_shortAGILE PROPERTY (03383)AIR CHINA (00753)AMBER ENERGY (00090)ANTA SPORTS (02020)ARTEL GROUP (00931)ARTINI (00789)BEIJING ENT (00392)BIOSINO BIO-TEC (08247)BJ PROPERTIES (00925)BLOOMAGE BIOTEC (00963)BRIGHTOIL (00933)BURWILL (00024)BYD COMPANY (01211)C HIGHPRECISION (00591)C PUBLIC HEALTH (08116)CDAYENONFER (00661)CENTURY LEGEND (00079)CH ALL ACCESS (00633)CH AUTOMATION (00569)CH FIN LEASING (02312)CH FORTUNE GP (00290)CHALCO (02600)CHAOWEI POWER (00951)CHINA COAL (01898)CHINA COMM CONS (01800)CHINA COSCO (01919)CHINA EB INT'L (00257)CHINA ENERGINE (01185)CHINA ENERGY (00228)CHINA FORESTRY (00930)CHINA GREEN (00904)CHINA MOTION (00989)CHINA ORIENTAL (00581)CHINA RAIL CONS (01186)CHINA STARCH (03838)CHINA UNICOM (00762)CHINA WATER (00855)CHINA XLX FERT (01866)CHINAVTM MINING (00893)CHINESE EST H (00127)CHU KONG PIPE (01938)CHU KONG SHIP (00560)CINDA INTL HLDG (00111)CITIC BANK (00998)CLEAR MEDIA (00100)CM BANK (03968)CMOC (03993)CNOOC (00883)COFCO PACKAGING (00906)COME SURE GROUP (00794)COSCO PACIFIC (01199)COSTIN NEW MAT (02228)CT HOLDINGS (01008)DIGITAL CHINA (00861)EFORCE HOLDINGS (00943)FAR EAST GLOBAL (00830)FORTE (02337)FRANSHION PPT (00817)FUSHAN ENERGY (00639)FUTONG TECH (00465)GCL-POLY ENERGY (03800)GLOBAL BIO-CHEM (00809)GLOBAL SWEET (03889)HAO TIAN RES GP (00474)HENRY GROUP (00859)HKC (HOLDINGS) (00190)HONTEX INT'L (00946)HUA HAN (00587)HUABAO INTL (00336)HUADIAN POWER (01071)IMERCHANTS (08009)JACKIN INT'L (00630)KING STONE ENGY (00663)KINGWELL GROUP (01195)LI NING (02331)LITTLE SHEEP (00968)LO'S ENVIRO-PRO (00309)LONKING (03339)LUKS GROUP (VN) (00366)MEDIACHINA CORP (00419)MENGNIU DAIRY (02319)MIN RESOURCES (01208)MOBI DEV (00947)NEWAY GROUP (00055)NEWTIMES ENERGY (00166)NORSTAR (02339)PACIFIC ANDES (01174)PEAK SPORT (01968)PING AN (02318)PROSPERITY INTL (00803)PROSTEN TECH (08026)QJY MEDIA (02366)RAYMOND IND (00229)RCG (00802)ROYALE FURN (01198)RUINIAN (02010)SA SA INT'L (00178)SCUD GROUP (01399)SHANGHAI PRIME (02345)SHENGLI PIPE (01080)SHENGUAN HLDGS (00829)SHINEWAY PHARM (02877)SIJIA GROUP (01863)SIM TECH (02000)SINGYES SOLAR (00750)SINO DRAGON-NEW (00395)SINOFERT (00297)SINOPEC CORP (00386)SINOPHARM (01099)SINOREF HLDGS (01020)SINOTRUK (03808)SKYWORTH DIGITAL (00751)SMARTONE TELE (00315)SOUND GLOBAL (00967)SOUNDWILL HOLD (00878)SUNDART INT'L (02288)SUSTAIN FOREST (00723)TAK SING ALLI (00126)TC INTERCONNECT (00515)TCC INT'L HOLD (01136)TENCENT (00700)TIANNENG POWER (00819)TONTINE WINES (00389)TPV TECHNOLOGY (00903)TRAVELSKY TECH (00696)TSC OFFSHORE (00206)VODONE (00082)WARDERLY (00607)WASION GROUP (03393)WATER INDUSTRY (01129)WEIQIAO TEXTILE (02698)WELLING HOLDING (00382)WINFAIR INV (00287)WING LEE HOLD (00876)XINYI GLASS (00868)XTEP INT'L (01368)YARDWAY (00646)YINGDE GASES (02168)YOUYUAN HLDGS (02268)YURUN FOOD (01068)YUZHOU PPT (01628)ZHONGAN REALEST (00672)