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

GLOBAL MEMBER DIRECTORY
PRINT		|	SORT BY FIRM/COMPANY

REGIONAL MEMBER DIRECTORY

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

Al Kamel Law Office|Egypt    Industry: Legal Services   Contact: Shahira Khaled   Email: send an Email   Address: Al Kamel Law Building   17 Nabil El Wakad Street, Dokki   Giza Egypt   Phone: +202 37615271   Fax: +202 37615272				Nabulsi & Associates|Jordan    Industry: Legal Services   Contact: Rand Hannun   Email: send an Email   Address: Riyadh Center, 3rd Circle   35116 Amman Jordan   Phone: +962 6 4654411   Fax: +962 6 4657555
Abdullah Kh. Al-Ayoub & Associates|Kuwait    Industry: Legal Services   Contact: Abdullah Kh. Al-Ayoub   Email: send an Email   Address: Souk Al-Kabir Building, Block 'B'   9th Floor, Fahed Al Salem Street   13018 Safat Kuwait   Phone: +965 22464321   Fax: +965 22434711				Beirut Law Firm|Lebanon    Industry: Legal Services   Contact: Charbel Abi-Antoun   Email: send an Email   Address: 345 Bikfaya Mainway   1201 Antelias Lebanon   Phone: 9614444139   Fax: 9614444239
Afridi & Angell|United Arab Emirates    Industry: Legal Services   Contact: Bashir Ahmed   Email: send an Email   Address: Emirates Towers Offices, Level 35   Sheikh Zayed Road   P.O. Box 9371 Dubai United Arab Emirates   Phone: +971 4 330 3900   Fax: +971 4 330 3800