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=5)
|
| | Industry: | Legal Services | | Contact: | Axel Anderl | | Email: | send an Email | | Address: | Universitaetsring 10 | | | 1010 Vienna | | | Austria | | Phone: | +43-1-533 47 95-0 | | Fax: | +43-1-533 47 97 |
| | |
| | Industry: | Legal Services | | Contact: | Lieven Peeters | | Email: | send an Email | | Address: | Havenlaan 86C box 414 Avenue du Port | | | 1000 Brussels | | | Belgium | | Phone: | +32 2 426 14 14 | | Fax: | +32 2 426 20 30 |
|
|
| | Industry: | Legal Services | | Contact: | Borislav Boyanov | | Email: | send an Email | | Address: | 82 Patriarch Evtimii Blv. | | | 1463 Sofia | | | Bulgaria | | Phone: | +359 2 8 055 055 | | Fax: | +359 2 8 055 000 |
| | |
| | Industry: | Legal Services | | Contact: | Eleni K. Chrysostomides | | Email: | send an Email | | Address: | 1 Lampousas Street | | | 1095 Nicosia | | | Cyprus | | Phone: | +357 22 777000 | | Fax: | +357 22 779939 |
|
|
| | Industry: | Legal Services | | Contact: | Martin Solc | | Email: | send an Email | | Address: | Jungmannova 24 | | | Prague | | | Czech Republic | | Phone: | +420 224 103 316 | | Fax: | +420 224 103 234 |
| | |
| | Industry: | Legal Services | | Contact: | Hans Hedegaard | | Email: | send an Email | | Address: | Amerika Plads 37 | | | 2100 Copenhagen | | | Denmark | | Phone: | +45 33 12 11 33 | | Fax: | +45 33 12 00 14 |
|
|
| | Industry: | Legal Services | | Contact: | Gary Assim | | Email: | send an Email | | Address: | 7th Floor, 100 Avebury Boulevard | | | MK9 1FH Milton Keynes | | | England | | Phone: | +44 207 305 5692 | | Fax: | +44 37 0086 3001 |
| | |
| | Industry: | Investment Banking | | Contact: | Simon Ward | | Email: | send an Email | | Address: | Cathedral Place | | | 42-44 Waterloo Street | | | B2 5QB Birmingham | | | England | | Phone: | +44 845 838 1680 |
|
|
| | Industry: | Legal Services | | Contact: | Martin Simovart | | Email: | send an Email | | Address: | P�rnu mnt 15 | | | 10141 Tallinn | | | Estonia | | Phone: | +372 6 651 888 | | Fax: | +372 6 651 899 |
| | |
| | Industry: | Legal Services | | Contact: | Mika St�hlberg | | Email: | send an Email | | Address: | Fabianinkatu 9 | | | 00130 Helsinki | | | Finland | | Phone: | +358 29 000 6200 | | Fax: | +358 29 000 6201 |
|
|
| | Industry: | Legal Services | | Contact: | Yvon Dreano | | Email: | send an Email | | Address: | 11 rue Galilee | | | 75116 Paris | | | France | | Phone: | +33 1 45 05 80 08 | | Fax: | +33 01 47 04 20 41 |
| | |
| | Industry: | Legal Services | | Contact: | Regina Glaser, LL.M. | | Email: | send an Email | | Address: | Georg-Glock-Strasse 4 | | | D - 40474 Duesseldorf | | | Germany | | Phone: | +49 211 600 55 178 | | Fax: | +49 211 600 55 177 |
|
|
| | Industry: | Legal Services | | Contact: | Dorotheos Samoladas | | Email: | send an Email | | Address: | 9 Anagnostopoulou Street | | | 106 73 Athens | | | Greece | | Phone: | +30 210 3670400 | | Fax: | +30 210 3621595 |
| | |
| | Industry: | Legal Services | | Contact: | Andras Szecskay | | Email: | send an Email | | Address: | Kossuth Lajos Sqr. 16-17. III | | | H-1055 Budapest | | | Hungary | | Phone: | +36 1 472 3000 | | Fax: | +36 1 472 3001 |
|
|
| | Industry: | Legal Services | | Contact: | Orn Gunnarsson | | Email: | send an Email | | Address: | Borgartun 26 | | | 105 Reykjavik | | | Iceland | | Phone: | +35 4 590 2600 |
| | |
| | Industry: | Legal Services | | Contact: | Michael Greene | | Email: | send an Email | | Address: | International Financial Services Centre, North Wall Quay | | | D01H104 Dublin | | | Ireland | | Phone: | +353 1 649 2000 | | Fax: | +353 1 649 2649 |
|
|
| | Industry: | Legal Services | | Contact: | Raz Tepper | | Email: | send an Email | | Address: | 146 Menachem Begin Rd. | | | 6492103 Tel Aviv | | | Israel | | Phone: | +972 3 694 4194 |
| | |
| | Industry: | Legal Services | | Contact: | Francesco Gianni | | Email: | send an Email | | Address: | 20, Via delle Quattro Fontane | | | 00184 Rome | | | Italy | | Phone: | +39 06 47 87 51 | | Fax: | +39 06 48 71 10 1 |
|
|
| | Industry: | Legal Services | | Contact: | Filips Klavins | | Email: | send an Email | | Address: | K. Valdemara 62 | | | LV-1013 Riga | | | Latvia | | Phone: | +371 67814848 | | Fax: | +371 67814849 |
| | |
| | Industry: | Legal Services | | Contact: | Alexander Appel, LL.M. | | Email: | send an Email | | Address: | Zollstrasse 2 | | | FL-9490 Vaduz | | | Liechtenstein | | Phone: | +41 44 244 2000 | | Fax: | +41 44 244 2100 |
|
|
| | Industry: | Legal Services | | Contact: | Rolandas Valiunas | | Email: | send an Email | | Address: | Jogailos 9 | | | LT-01116 Vilnius | | | Lithuania | | Phone: | +370 52681888 | | Fax: | +370 52125591 |
| | |
| | Industry: | Legal Services | | Contact: | Guy Harles | | Email: | send an Email | | Address: | 41A, avenue J.F. Kennedy | | | L-2082 Luxembourg | | | Luxembourg | | Phone: | +352 40 78 78 1 | | Fax: | +352 40 78 04 |
|
|
| | Industry: | Legal Services | | Contact: | Kristijan Polenak | | Email: | send an Email | | Address: | Orce Nikolov 98 | | | 1000 Skopje | | | Macedonia | | Phone: | +389 (0)2 3114 737 | | Fax: | +389 (0)2 3120 420 |
| | |
| | Industry: | Legal Services | | Contact: | Joseph Borg Bartolo | | Email: | send an Email | | Address: | Palazzo Pietro Stiges, 103, Strait Street | | | VLT 1436 Valletta | | | Malta | | Phone: | +356 2540 3000 | | Fax: | +356 2540 3300 |
|
|
| | Industry: | Legal Services | | Contact: | Sasha Vujacic | | Email: | send an Email | | Address: | 56/2 Boulevard Ivana Crnojevica | | | 81000 Podgorica | | | Montenegro | | Phone: | + 382 20 229 725 | | Fax: | + 382 20 229 726 |
| | |
| | Industry: | Legal Services | | Contact: | Daan ter Braak | | Email: | send an Email | | Address: | Jachthavenweg 121 | | | 1081 KM Amsterdam | | | Netherlands | | Phone: | +31 20 6789 123 | | Fax: | +31 20 7954 589 |
|
|
| | Industry: | Legal Services | | Contact: | Jan Magne Langseth | | Email: | send an Email | | Address: | P.O. Box 2043 Vika | | | N-0125 Oslo | | | Norway | | Phone: | +47 21 95 55 00 | | Fax: | +47 2195 55 01 |
| | |
| | Industry: | Legal Services | | Contact: | Lukasz Szegda | | Email: | send an Email | | Address: | Aleje Ujazdowskie 10 | | | 00-478 Warsaw | | | Poland | | Phone: | +48 22 437 82 00 | | Fax: | +48 22 437 82 01 |
|
|
| | Industry: | Legal Services | | Contact: | Bruno Ferreira | | Email: | send an Email | | Address: | Av. Fontes Pereira de Melo, 43 | | | Edificio Eurolex | | | 1050-119 Lisbon | | | Portugal | | Phone: | +351 213 197 300 | | Fax: | +351 213 197 400 |
| | |
| | Industry: | Legal Services | | Contact: | Manuela M. Nestor | | Email: | send an Email | | Address: | 201 Barbu Vacarescu St., Globalworth Tower, 18th Floor, District 2 | | | 020276 Bucharest | | | Romania | | Phone: | +40 21 201 12 00 | | Fax: | +40 21 201 12 10 |
|
|
| | Industry: | Legal Services | | Contact: | Alexander Zharskiy | | Email: | send an Email | | Address: | 6nd Floor, 17 Skakovaya Str. | | | 125040 Moscow | | | Russia | | Phone: | +7 495 234 9692 | | Fax: | +7 495 956 3718 |
| | |
| | Industry: | Legal Services | | Contact: | Paul Carlyle | | Email: | send an Email | | Address: | 9 Haymarket Square | | | EH3 8FY Edinburgh | | | Scotland | | Phone: | 0131 228 9900 | | Fax: | +44 0131 228 1222 |
|
|
| | Industry: | Legal Services | | Contact: | Darko Jovanovic | | Email: | send an Email | | Address: | Resavska 23 | | | 11000 Belgrade | | | Serbia | | Phone: | +381 11 3094 200 | | Fax: | +381 11 3094 223 |
| | |
| | Industry: | Legal Services | | Contact: | Katarina Cechova | | Email: | send an Email | | Address: | Staromestska 3 | | | 811 03 Bratislava | | | Slovakia | | Phone: | +421 2 54 41 44 41 | | Fax: | +421 2 54 43 45 98 |
|
|
| | Industry: | Legal Services | | Address: | Hermosilla, 3 | | | 28001 Madrid | | | Spain | | Phone: | +34 91 514 52 00 | | Fax: | +34 91 399 24 08 |
| | |
| | Industry: | Legal Services | | Contact: | Stefan Erhag | | Email: | send an Email | | Address: | Master Samuelsgatan 17 | | | SE-111 84 Stockholm | | | Sweden | | Phone: | +46 8 677 54 00 | | Fax: | +46 8 20 18 84 |
|
|
| | Industry: | Legal Services | | Contact: | Hans Rudolf Tr�eb | | Email: | send an Email | | Address: | Seefeldstrasse 123 | | | P.O. Box 1236 | | | 8034 Zurich | | | Switzerland | | Phone: | +41 58 658 58 58 | | Fax: | +41 58 658 59 59 |
| | |
| | Industry: | Legal Services | | Address: | Ahular Sokak No:15 Etiler | | | 34337 Istanbul | | | Turkey | | Phone: | +90 212 359 5700 | | Fax: | +90 212 359 5757 |
|
|
| | Industry: | Legal Services | | Contact: | Oleksiy Didkovskiy | | Email: | send an Email | | Address: | Leonardo Business Center, 14th Fl. | | | 19-21 Bohdana Khmelnytskoho St. | | | 01054 Kyiv | | | Ukraine | | Phone: | +380 44 230 6000 | | Fax: | +380 44 230 6001 |
| | |