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=8)

GLOBAL MEMBER DIRECTORY
PRINT		|	SORT BY FIRM/COMPANY

REGIONAL MEMBER DIRECTORY

AFRICA | ASIA | CARIBBEAN | CENTRAL AMERICA | EUROPE | MIDDLE EAST | NORTH AMERICA | SOUTH AMERICA

Beccar Varela|Argentina    Industry: Legal Services   Contact: Ramon Ignacio Moyano   Email: send an Email   Address: Edificio Republica, Tucuman 1,   3rd Floor   C1049AAA Buenos Aires Argentina   Phone: +54 11 4379 6800   Fax: +54 11 4379 6860				SMS Buenos Aires|Argentina    Industry: Accounting   Contact: Pablo San Martin   Email: send an Email   Address: Bernardo de Irigoyen 972   C1072AAT Buenos Aires Argentina   Phone: +54 11 5275 8000   Fax: +54 11 4362 4406
C.R. & F. Rojas Abogados|Bolivia    Industry: Legal Services   Contact: Diego Rojas   Email: send an Email   Address: Federico Zuazo 1598   Edif Park Inn, 11th Fl.   La Paz Bolivia   Phone: +591 2 231 3737   Fax: +591 2 237 6380				Veirano Advogados|Brazil    Industry: Legal Services   Contact: Ronaldo Camargo Veirano   Email: send an Email   Address: Av. Bartolomeu Mitre   770 - Leblon   22431-004 Rio de Janeiro Brazil   Phone: +55 21 3824 4747   Fax: +55 21 2262 4247
Carey|Chile    Industry: Legal Services   Contact: Jaime Carey   Email: send an Email   Address: Isidora Goyenechea 2800, Floor 43, Las Condes.   755-0647 Santiago Chile   Phone: +56 2 2928 2200   Fax: +56 2 2928 2228				Brigard Urrutia|Colombia    Industry: Legal Services   Contact: Jaime Robledo Vasquez   Email: send an Email   Address: Calle 70 Bis # 4 - 41, Bogota D.C.   Calle 6 norte # 1 - 42, Cali / Carrera 53 # 80 - 198, Barranquilla   110231 Bogota Colombia   Phone: +57 60 1 346 20 11   Fax: +57 60 1 310 06 09
Bustamante Fabara|Ecuador    Industry: Legal Services   Contact: Josemaria Bustamante   Email: send an Email   Address: Av. Patria E4-69 y Amazonas, Edificio Cofiec   170526 Quito Ecuador   Phone: +593 2 2564 065   Fax: +593 2 2564 069				Vouga Abogados|Paraguay    Industry: Legal Services   Contact: Rodolfo Vouga   Email: send an Email   Address: Av. Peru 505 and Av. Espa�a   Juan de Salazar 657 esq Prof. Ramirez   Asunc��n Paraguay   Phone: +595 21230 100   Fax: +595 21 214 556
Rodrigo, Elias & Medrano Abogados|Peru    Industry: Legal Services   Contact: Juan Diego De Vinatea   Email: send an Email   Address: Av. Pardo y Aliaga 652, San Isidro, Lima 15073.   Suite 8   15074 Lima Peru   Phone: +51 1 619 1900   Fax: +51 1 619 1919				Lim A Po Law Firm|Suriname    Industry: Legal Services   Contact: Hans Rudolf Lim A Po   Email: send an Email   Address: Mr. F.H.R. Lim A Postreet No. 14   PO Box 92   Paramaribo Suriname   Phone: +597 473 514   Fax: +597 475 394
Guyer & Regules|Uruguay    Industry: Legal Services   Contact: Nicolas Herrera   Email: send an Email   Address: Plaza Independencia 811   11100 Montevideo Uruguay   Phone: +598 2902 1515   Fax: +598 2902 5454				Guyer & Regules|Uruguay    Industry: Accounting   Contact: Diego Licio   Email: send an Email   Address: Plaza Independencia 811   11100 Montevideo Uruguay   Phone: +598 2902 1515   Fax: +598 2902 5454
LEGA Abogados|Venezuela    Industry: Legal Services   Contact: Carlos Dominguez   Email: send an Email   Address: Av. Eugenio Mendoza, Torre La Castellana, Piso 7.   1060 Caracas Venezuela   Phone: +58 (0) 212 2772200