Cigna International Health Insurance

International Car Insurance

Moving overseas? Get international car insurance quotes from reputable insurance companies with products tailored to meet the unique needs of expats.

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

Clements Worldwide

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

Moving-OverseasYou're Not Too Old To Live Abroad

Who doesn't want to get out there and see the world? So many of us put off the prospect of moving overseas until later in life, and that shouldn't keep you from considering retiring abroad.

Who doesn't want to get out there and see the world? So many of us put off the prospect of moving overseas until later in life, and that shouldn't keep you from considering retiring abroad....

Expats-in-PortugalLisbon, 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.

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 h...

Expats-in-ThailandChiang 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.

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 rea...

Retirement-In-San-Isidro-de-HerediaAn Expat Shares What it's Like Retiring in San Isidro de Heredia, Costa Rica

Why retire in San Isidro de Heredia, Costa Rica? Can you live on $1,000 or $2,000 a month? How difficult is it if you aren't fluent in Spanish when you first arrive? A retiree who arrived in Costa Rica a month ago answers these and other questions.

Why retire in San Isidro de Heredia, Costa Rica? Can you live on $1,000 or $2,000 a month? How difficult is it if you aren't fluent in Spanish when you first arrive? A retiree who arrived in Costa ...

Moving-To-PortoAn Expat Talks about Moving to Porto, Portugal

An expat talks about moving to Porto, Portugal - moving costs, renting a condo, the lower cost of living in Porto and more.

An expat talks about moving to Porto, Portugal - moving costs, renting a condo, the lower cost of living in Porto and more....

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /rgall.cfm
Time Stamp 16-Jul-20 01:35 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.37
Host Name 172.69.63.37


Execution Time

Total Time Avg Time Count Template
76 ms 76 ms 1 top level /home/www/html/rgall.cfm
16 ms 16 ms 1 /home/www/html/navtop_rdesign5.cfm
6 ms 6 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
4 ms 4 ms 1 /home/www/html/navcontentbox.cfm
4 ms 4 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/navmeta_rdesign4.cfm
1 ms 1 ms 2 /home/www/html/rewritereport.cfm
1 ms 1 ms 1 /var/www/expatexchange.com/expat/datasources.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/constants.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 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
81 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 @ 13:35:45.045
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 13:35:45.045
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getcatname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rgall.cfm @ 13:35:45.045
	Select *
	From Categories
	Where categoryid = 95 
getbidders (Datasource=expert, Time=4ms, Records=0) in /home/www/html/rgall.cfm @ 13:35:45.045
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-15 13:35:45'}
    and fromdate <{ts '2020-07-16 13:35:45'}
	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 @ 13:35:45.045
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 13:35:45.045
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 159 
getcities (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 13:35:45.045
	Select *
	From citynetworks
	Where networkID = 159
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 13:35:45.045
  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 @ 13:35:45.045
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-04-16"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 13:35:45.045
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-07-16 00:00:00.000"
and logtime < "2020-07-16 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 13:35:45.045
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-07-09"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheckallnetworks (Datasource=expert, Time=5ms, Records=153) in /home/www/html/navtop_rdesign5.cfm @ 13:35:45.045
	SELECT *
	From contentcountcountry, Networks
	where contentcountcountry.networkid = Networks.networkid
contentcheckallnetworks (Datasource=expert, Time=4ms, Records=153) in /home/www/html/navtop_rdesign5.cfm @ 13:35:45.045
	SELECT *
	From contentcountcountry, Networks
	where contentcountcountry.networkid = Networks.networkid
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 13:35:45.045
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eebanner")
	and weight = 10
    and toDate > "2020-07-15"
    and fromDate < "2020-07-16"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 13:35:45.045
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getaffiliates (Datasource=expert, Time=3ms, Records=0) in /home/www/html/rgall.cfm @ 13:35:45.045
	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-15 13:35:45'}
    and fromdate <{ts '2020-07-16 13:35:45'}
	Order by Resources.resourcename
getcatname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rgall.cfm @ 13:35:45.045
	Select *
	From Categories
	Where categoryid = 95 
UpdateImpressions (Datasource=expert, Time=4ms, Records=1) in /home/www/html/rgall.cfm @ 13:35:45.045
  UPDATE Categories
  SET rgallimpressions = rgallimpressions + 1
  Where categoryid = 95 
getlistingsglobal (Datasource=expert, Time=4ms, Records=1) in /home/www/html/rgall.cfm @ 13:35:45.045
	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.eventdate, Resources.description, Resources.homepage, Resources.directlink, Resources.includelink, Resources.globalnotallcountries, 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-15 13:35:45'}
   	 and fromdate <{ts '2020-07-16 13:35:45'}
   	 and Resources.resourceID <> '10736'
        and Resources.resourceID <> '10683'
	AND (resourcePlacement.networkID = '159' or Resources.globalnotallcountries = 'y')
	AND resourcePlacement.resourceID = Resources.resourceID
     
	Order by Resources.resourcename
	
getlistings (Datasource=expert, Time=4ms, Records=0) in /home/www/html/rgall.cfm @ 13:35:45.045
	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.eventdate, Resources.description, Resources.homepage, Resources.directlink, 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 <> 'bonusonly'
    and Resources.bid <> 'yes'
    and todate > {ts '2020-07-15 13:35:45'}
    and fromdate <{ts '2020-07-16 13:35:45'}
	AND resourcePlacement.networkID <> '159'
	AND resourcePlacement.resourceID = Resources.resourceID
	Order by Resources.resourcename
gettaxgeneral (Datasource=expert, Time=32ms, Records=0) in /home/www/html/rgall.cfm @ 13:35:45.045
	Select *
	From articles
	Where type = 3
   	and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
   	and articles.category = 95
    and publishdate <{ts '2020-07-16 13:35:45'}
    ORDER by publishdate desc 
checkrptarticles (Datasource=reports, Time=0ms, Records=0, Cached Query) in /home/www/html/navcontentbox.cfm @ 13:35:45.045
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-16"
     
         and rptarticlenetworks.networkid = 159 
    ORDER by rptarticles.rptarticleID desc
    
gettaxgeneral2 (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navcontentbox.cfm @ 13:35:45.045
	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-16"  
    ORDER by articles.articleID desc  
checkretirefeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 13:35:45.045
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:35:45.045
		Select summary, hiimg 
		FROM answers
         where answerid = 76511
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 13:35:45.045
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:35:45.045
		Select summary, hiimg 
		FROM answers
         where answerid = 76515
         and summary <> ''
GetCountryList (Datasource=expert, Time=1ms, Records=96, Cached Query) in /home/www/html/navsidesbottom_rdesign5.cfm @ 13:35:45.045
  SELECT networkname, frmid, networkid, location1, location2, location3, location4, location5, shortname
  FROM mostcountries
  order by networkname


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
REMOTE_ADDR=172.69.63.37
REMOTE_HOST=172.69.63.37
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=32013319
cftoken=29575941
sessionid=IBEXPATEXCHANGE.COM_32013319_29575941
urltoken=CFID=32013319&CFTOKEN=29575941
URL Parameters:
categoryID=95
Debug Rendering Time: 10 ms