Haiti
Forum Haiti
Guide Healthcare in
Haiti

Home Haiti Forum Haiti Guide Haiti Resources Real Estate Healthcare in Haiti

Haiti: International Car Insurance

Get car insurance quotes for Haiti from reputable insurance companies with products tailored to meet the unique needs of expats in Haiti.

Interested in being included in this section. Contact us to discuss partnership opportunities.

Clements Worldwide

Clements provide access to International auto insurance providing physical damage cover with Excess Liability protection. Since coverage is borderless, you are in safe hands no matter where you are in the world.

Learn More Get a Quote

Lisbon, Portugal

Lisbon is the capital and largest city in Portugal, which is one of the most popular countries for expats in Europe. You'll find basic information to help you get acquainted with Lisbon and what it has to offer.

Chiang Mai, Thailand

Expats share what it's like living in Chiang Mai and why they move there. With its large expat community of missionaries, retirees, expat families and teachers, Chiang Mai is attractive for many reasons: its size, friendly people, low cost of living and good healthcare.

Other Links

Our Story Our Team Contact Us Submit an Article Advertising Travel Warnings

Debugging Information

ColdFusion Server Enterprise	9,0,2,282541
Template	/rgall.cfm
Time Stamp	03-Jul-20 06:56 PM
Locale	English (US)
User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP	162.158.78.108
Host Name	162.158.78.108

Execution Time

Total Time	Avg Time	Count	Template
53 ms	53 ms	1	/home/www/html/rgall.cfm
21 ms	21 ms	1	/home/www/html/navsidesbottom_rdesign5.cfm
20 ms	20 ms	1	/home/www/html/navcontentbox.cfm
20 ms	20 ms	1	/home/www/html/navrightmidcolumn_rdesign5.cfm
8 ms	8 ms	1	/home/www/html/navtop_rdesign5.cfm
4 ms	4 ms	1	/home/www/html/Application.cfm
2 ms	2 ms	1	/home/www/html/navleader_rdesign5.cfm
2 ms	2 ms	1	/home/www/html/navmeta_rdesign4.cfm
1 ms	1 ms	1	/home/www/html/constants.cfm
1 ms	1 ms	1	/var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
0 ms	0 ms	1	/home/www/html/bottommobilenav_rdesign5.cfm
0 ms	0 ms	1	/home/www/html/bottomnav_rdesign5.cfm
0 ms	0 ms	1	/home/www/html/leftnav_rdesign5.cfm
0 ms	0 ms	2	/home/www/html/navinjection.cfm
0 ms	0 ms	2	/home/www/html/rewritearticle.cfm
0 ms	0 ms	1	/var/www/expatexchange.com/expat/datasources.cfm
0 ms	0 ms	1	/var/www/expatexchange.com/expat/ibkey.cfm
1 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
58 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm @ 18:56:02.002

  SELECT * FROM genset 
WHERE dbname = "ee"

UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 18:56:02.002

      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'

getcatname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rgall.cfm @ 18:56:02.002

	Select *
	From Categories
	Where categoryid = 95

getbidders (Datasource=expert, Time=4ms, Records=0) in /home/www/html/rgall.cfm @ 18:56:02.002

Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.eventdate, Resources.description, Resources.homepage, Resources.directlink, Resources.includelink, Resources.photo, Resources.phototype, Resources.quotebutton, Resources.usefullrewriteurl, Resources.fullrewriteurl
    From Resources, resourcePlacement, resourceCats
    WHERE 95 = resourceCats.categoryID 
	AND resourceCats.resourceID = Resources.resourceID 
	AND Resources.type <> 'hold'
	AND Resources.type <> 'guide'
	and Resources.type  <> 'local'
	and Resources.type  <> 'free'
	and Resources.type  <> 'affiliate'
	and Resources.type  <> 'locaff'
	and Resources.type <> 'bonusonly'
   and Resources.bid = 'yes'
    and todate > {ts '2020-07-02 18:56:02'}
    and fromdate <{ts '2020-07-03 18:56:02'}
	AND resourcePlacement.networkID = '159'
	AND resourcePlacement.resourceID = Resources.resourceID
	Order by Resources.resourcename

GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 18:56:02.002

	Select *
	From Networks
	where isCity = 'country'
	order by networkname

getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 18:56:02.002

	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 50

getcities (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 18:56:02.002

	Select *
	From citynetworks
	Where networkID = 50
	and status <> 'hold'
	ORDER by city

GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 18:56:02.002

  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname

checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 18:56:02.002

SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
and logtime > "2020-04-03"
and param1 = 'aw'
ORDER BY logtime DESC

checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 18:56:02.002

SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
and logtime > "2020-07-03 00:00:00.000"
and logtime < "2020-07-03 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC

checklogdynamicpre (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 18:56:02.002

SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
and logtime > "2020-06-26"
and param1 = 'awdyn'
ORDER BY logtime DESC

contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 18:56:02.002

	SELECT *
	From contentcountcountry
	Where networkid = 50

gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 18:56:02.002

	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-02"
    and fromDate < "2020-07-03"

UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 18:56:02.002

  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862

getaffiliates (Datasource=expert, Time=5ms, Records=0) in /home/www/html/rgall.cfm @ 18:56:02.002

	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.eventdate, Resources.description, Resources.homepage, Resources.contactname, Resources.email, Resources.phone, Resources.fax, Resources.street, Resources.city, Resources.state_prov, Resources.zip, Resources.country, Resources.longdescription, Resources.photo, Resources.site, Resources.directlink, Resources.includelink, Resources.photo, Resources.phototype, Resources.quotebutton, Resources.usefullrewriteurl, Resources.fullrewriteurl
    From Resources, resourceCats
    WHERE 95 = resourceCats.categoryID 
	and resourceCats.resourceID = Resources.resourceID 
	and Resources.type = 'affiliate'
    and Resources.bid <> 'yes'
    and todate > {ts '2020-07-02 18:56:02'}
    and fromdate <{ts '2020-07-03 18:56:02'}
	Order by Resources.resourcename

getcatname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rgall.cfm @ 18:56:02.002

	Select *
	From Categories
	Where categoryid = 95

UpdateImpressions (Datasource=expert, Time=2ms, Records=1) in /home/www/html/rgall.cfm @ 18:56:02.002

  UPDATE Categories
  SET rgnetimpressions = rgnetimpressions + 1
  Where categoryid = 95

getlistings (Datasource=expert, Time=4ms, Records=1) in /home/www/html/rgall.cfm @ 18:56:02.002

	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.eventdate, Resources.description, Resources.homepage, Resources.directlink, Resources.includelink, Resources.photo, Resources.phototype, Resources.quotebutton, Resources.usefullrewriteurl, Resources.fullrewriteurl, resourceCats.categoryorder
    From Resources, resourcePlacement, resourceCats
    WHERE 95 = resourceCats.categoryID 
	AND resourceCats.resourceID = Resources.resourceID 
	AND Resources.type <> 'hold'
	AND Resources.type <> 'guide'
	AND Resources.type <> 'local'
	AND Resources.type <> 'free'
	and Resources.type <> 'bonusonly'
    and Resources.bid <> 'yes'
    and todate > {ts '2020-07-02 18:56:02'}
    and fromdate <{ts '2020-07-03 18:56:02'}
	AND (50 = resourcePlacement.networkID OR resourcePlacement.networkID = '159')
	AND resourcePlacement.resourceID = Resources.resourceID
    
	Order by Resources.resourcename

gettaxgeneral (Datasource=expert, Time=6ms, Records=1) in /home/www/html/rgall.cfm @ 18:56:02.002

	Select *
	From articles, articlePlacement
	Where type = 3
   	and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
   	and articlePlacement.networkid = 50
   	and articles.articleid = articlePlacement.articleid
    and publishdate <{ts '2020-07-03 18:56:02'}
    ORDER by publishdate desc

checkrptarticles (Datasource=reports, Time=4ms, Records=0) in /home/www/html/navcontentbox.cfm @ 18:56:02.002

		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-03"
     
         and rptarticlenetworks.networkid = 50 
    ORDER by rptarticles.rptarticleID asc

gettaxgeneral2 (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 18:56:02.002

	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 50 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-03"

    ORDER by articles.articleID asc

checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 18:56:02.002

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 50 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC

checkmovingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 18:56:02.002

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 50 
          and date > '2013-04-01'
		order by date DESC

gettaxgeneral2 (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navcontentbox.cfm @ 18:56:02.002

	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles 
	Where hitopic <> ''
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-03"  
    ORDER by articles.articleID desc

Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/rgall.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.expatexchange.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/home/www/html/rgall.cfm
QUERY_STRING=categoryID=95&networkID=50
REMOTE_ADDR=162.158.78.108
REMOTE_HOST=162.158.78.108
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rgall.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=

Session Variables:
cfid=30975497
cftoken=27099166
sessionid=IBEXPATEXCHANGE.COM_30975497_27099166
urltoken=CFID=30975497&CFTOKEN=27099166

URL Parameters:
categoryID=95
networkID=50

Debug Rendering Time: 10 ms