SELECT dbo.fx_Jurisdiction1(country,stateorprovince) as 'jurisdiction',vmcontactid as contactid,companyname,address1,address2,city,stateorprovince,country, mainphone,mainfax,mainemail, companyid,companytype,ziporpostalzone, vmfirst as firstname,vmlast as lastname,vmmiddle as middlename,vmemail as email,vmphone as directdial1, CASE CompanyId WHEN 10014 THEN 'D.C.' ELSE stateorprovince END AS State FROM wsgCompanies left join VMainContacts on vmcompanyid=companyid where typelisting in ('M') and country<>'demoland' and directory=1 and wsgcompanies.companyid not in (7358,76,9771,8296) and companytype not in ('Insurances') and (wsgcompanies.firmid is null or wsgcompanies.firmid<>7358) and len(address1)>0 and (region=2)
|
| | Industry: | Legal Services | | Contact: | Peter Bartlett | | Email: | send an Email | | Address: | Governor Macquarie Tower | | | Level 40, 1 Farrer Place | | | 2000 Sydney | | | Australia | | Phone: | +61 2 9921 8888 | | Fax: | +61 2 9921 8123 |
| | |
| | Industry: | Legal Services | | Contact: | Mohamed Yusof Bin Shaik Abdul Halim | | Email: | send an Email | | Address: | No. 15, BT Hj Uthman Complex | | | Simpang 13 Jalan Komersial Jaya Setia, Kg. Jaya Setia | | | BB2713 Bandar Seri Begawan | | | Brunei | | Phone: | +673 233 9133 | | Fax: | +673 233 9134/5 |
|
|
| | Industry: | Legal Services | | Contact: | Gavin Nesbitt | | Email: | send an Email | | Address: | Alexandra House | | | 18 Chater Road, 5th Floor | | | HKG Hong Kong | | | China | | Phone: | +852 2825 9211 | | Fax: | +852 2810 0431 |
| | |
| | Industry: | Legal Services | | Contact: | Zhuowei (Joyce) Li | | Email: | send an Email | | Address: | 9F, Office Tower C1, Oriental Plaza, 1 East Chang An Avenue | | | 100738 Beijing | | | China | | Phone: | (86 10) 8525 5500 |
|
|
| | Industry: | Legal Services | | Contact: | Rohit Kochhar | | Email: | send an Email | | Address: | Suite # 1120-21, 11th Floor, Tower-A, DLF Towers, Jasola District Center, Jasola, New Delhi-110025 | | | Jasola District Center | | | 110025 New Delhi | | | India | | Phone: | +91 11 41 11 52 22 | | Fax: | +91 11 40 56 38 13 |
| | |
| | Industry: | Legal Services | | Contact: | Bonnie L. Dixon | | Email: | send an Email | | Address: | Fukoku Seimei Bldg. (Reception: 16F) | | | 2-2-2 Uchisaiwai-cho, Chiyoda-ku | | | 100-0011 Tokyo | | | Japan | | Phone: | +81 3 5501 2111 | | Fax: | +81 3 5501 2211 |
|
|
| | Industry: | Investment Banking | | Contact: | Yukuo Takenaka | | Email: | send an Email | | Address: | Nibancho-Terrace 911 | | | 5-25 Nibancho, Chiyoda-ku | | | 102-0084 Tokyo | | | Japan | | Phone: | +81 (0)3 6268 9681 | | Fax: | +81 (0)3 6268 9684 |
| | |
| | Industry: | Investment Banking | | Contact: | Ryosuke ''Rio'' Funayama | | Email: | send an Email | | Address: | 10th Fl. Marunouchi Trust Tower N., 1-8-1 Marunouchi, Chiyoda-ku | | | 100-0005 Tokyo | | | Japan | | Phone: | +81 3 6212 2510 | | Fax: | +81 3 6212 2520 |
|
|
| | Industry: | Legal Services | | Contact: | Putri Noor Shariza Noordin | | Email: | send an Email | | Address: | Kuala Lumpur Office, 7th Floor, Wisma Hamzah-Kwong Hing | | | No.1, Leboh Ampang | | | 50100 Kuala Lumpur | | | Malaysia | | Phone: | +603 2027 2727 | | Fax: | +603 2078 5625 |
| | |
| | Industry: | Legal Services | | Address: | Level 5, MRDC Haus, Cnr Musgrave Street & Champion Pde | | | . Port Moresby, National Capital District | | | Papua New Guinea | | Phone: | +675 320 3333 | | Fax: | +675 321 3631 |
|
|
| | Industry: | Legal Services | | Contact: | Hector M. De Leon | | Email: | send an Email | | Address: | SyCipLaw Center | | | 105 Paseo de Roxas 1226 Makati City | | | 0 Metro Manila | | | Philippines | | Phone: | +632 8982 3600 | | Fax: | +632 88173570 |
| | |
| | Industry: | Legal Services | | Address: | 6 Battery Road, Level 41 | | | 049909 Singapore | | | Singapore | | Phone: | +65 6534 4877 | | Fax: | +65 6534 4822 |
|
|
| | Industry: | Legal Services | | Contact: | Mark J. Harty | | Email: | send an Email | | Address: | 5F., No. 8, Sec. 5, Sinyi Rd. | | | 110 Taipei | | | Taiwan | | Phone: | +886 2 2729 8000 | | Fax: | +886 2 2722 6677 |
| | |
| | Industry: | Legal Services | | Address: | 34/3 Vivre Langsuan, 4th, 5th, and 6th Floor, Soi Langsuan, Lumpini, Pathumwan, | | | 10330 Bangkok | | | Thailand | | Phone: | +6628381750 | | Fax: | +6628381795 |
|
|
| | Industry: | Legal Services | | Contact: | Diep Hoai Nam | | Email: | send an Email | | Address: | Suite V1201-02, Pacific Place | | | 83B Ly Thuong Kiet Street, Hoan Kiem District | | | 100000 Hanoi | | | Vietnam | | Phone: | + 84 24 3934 5410 | | Fax: | + 84 24 3934 5412 |
| | |