Cigna International Health Insurance

Expat Guide to Living Abroad

Whether you're already living abroad or preparing to move overseas, our Expat Guide to Living Overseas can help guide you. For answers to specific questions, use our Country Forums to talk with other expats and retirees already living abroad.

7 Best Places to Live on the Beach in Central America

Want to live on the beach without breaking the bank? Central America is home to dozens of beach towns and cities beloved by expats and global nomads. From Belize down to Panama, we explore 7 of the best places to live on the beach in Central America.

Countries Introduce Global Nomad Visas During Pandemic

Many people are escaping their routines and temporarily moving overseas during the pandemic. These countries are welcoming them with open arms by making it easy for visitors to stay and work remotely for months or even a year.

11 Tips about Healthcare & Health Insurance in Barbados

An overview of healthcare and health insurance in Barbados including finding a doctor, emergency medical care and transport, medical evacuation, expat health insurance options, recommended vaccinations, common diseases in Barbados, quality of hospitals and medical care, having a baby in Barbados and more.

10 Tips for Living in Barbados

Barbados recently introduced the 12 month Barbados Welcome Stamp to enable people to easily live and work on the island for up to 12 months. The online application is probably the easiest and quickest process we've ever seen.

12 Tips for Living in Montreal, Canada

12 Tips for Living in Montreal, Canada

Montreal boasts a rich cultural heritage, numerous employers and food that rivals many of the great cities in the world. Here are several things to know before taking the plunge and moving there, whether you're trying to bolster your career path or looking for unique retirement options.

Blue Sail

Blue Sail

Outdoor covered dining right on the beach, Friendly atmosphere, good food, superberb view and a selection of flavored mojitos and wine. This is a great hangout to get a meal and enjoy the beautiful view at sunset or during the day when the sun is shining on the beach.

Moving to Tokyo, Japan

An expat in Tokyo talks about the high cost of housing, living close to work, property searches and mansion apartments.

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.

Culture Shock in Valencia, Spain

An expat who studied anthropology has adjusted to life in Valencia and talks about his approach to avoiding culture shock.

Culture Shock in Comitan, CHIAPAS, Mexico

An expat, who traveled to Mexico to take a 30 day course for teaching ESL, fell in love with Mexico, was offered a job and made the move.

Living in Huatulco, Mexico

An expat in Huatulco talks about living in this remote part of Mexico, which is a 7 hour drive from the nearest city. He cautions anyone considering a move to be realistic about whether or not they can handle the isolation and remoteness.

Living in Ao Nang (Krabi), Thailand

Can you move to Thailand without a job? Is it easy to work remotely? An expat in Ao Nang answer these questions and has a lot more advice about living in Thailand.

Dream vs Reality of Living in Salinas, Ecuador

An expat in Ecuador talks about what she had expected life to be like vs. the reality of living in Salinas. She enjoys like in Salinas and appreciates the family-oriented culture, the beautiful weather and running her own business. Salinas has a small town feel where everybody knows what's going on in your life, but the positive side of that is that 15 people jump in and help if you are sick or need help.

Retirement in Bocas del Toro, Panama

A expat in Panama talks about what it's like being retired in Bocas del Toro - adapting to island time, building a home on Isla Solarte, the friendly people in Bocas, the lower cost of living, the new hospital and challenges traveling in and out of Bocas.

Additional Articles
The 9 Best Islands for Expats and Global Nomads

Does life have you dreaming of moving to an island and living a simpler life? Explore island life from the Caribbean to the Pacific.

You'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.

10 Best Places to Live in Liguria, Italy

Liguria, Italy, also known as the Italian Riviera, is a stunning coastal region spanning from Tuscany to the French border. In Liguria you will find mild temperatures and a relaxed lifestyle. If you're thinking about moving here, our list of the 10 best places to live in Liguria is based upon expat advice and recommendations.

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.

Living in Belize: Building a New Home in Belize

Author Gary Peterson talks about the ins and outs of building a home in Belize and introduces his new book about the subject.

7 Best Places to Live in Piedmont, Italy

Piedmont (in Italian: Piemonte) is an expansive region in Northern Italy that borders Switzerland and France. This is a region of great variety - you will find everything from small hilltop towns to cosmopolitan cities set against the snow-capped Alps. If you're thinking about moving to Piedmont, check out our list of the 7 best places to live in Piedmont, which is based upon advice and recommendations from expats already there.

1 2  3  4  5  6  of 106  pages > >>

Cigna Expat Health InsuranceExpatriate Health Insurance

Get a quote for expat health insurance from our partner, Cigna Global Health.
Get a Quote

Expats-in-Barbados10 Tips for Living in Barbados

Barbados recently introduced the 12 month Barbados Welcome Stamp to enable people to easily live and work on the island for up to 12 months. The online application is probably the easiest and quickest process we've ever seen.

Barbados recently introduced the 12 month Barbados Welcome Stamp to enable people to easily live and work on the island for up to 12 months. The online application is probably the easiest and quickes...

Healthcare-in-Barbados11 Tips about Healthcare & Health Insurance in Barbados

An overview of healthcare and health insurance in Barbados including finding a doctor, emergency medical care and transport, medical evacuation, expat health insurance options, recommended vaccinations, common diseases in Barbados, quality of hospitals and medical care, having a baby in Barbados and more.

An overview of healthcare and health insurance in Barbados including finding a doctor, emergency medical care and transport, medical evacuation, expat health insurance options, recommended vaccination...

Retirement-In-Clapham-RidgeAn Expat Shares What it's Like Retiring in Clapham Ridge, Barbados

An expat talks about what it's like living in Barbados. He appreciates the good quality of life, active expat community, beautiful weather and friendly Barbadians.

An expat talks about what it's like living in Barbados. He appreciates the good quality of life, active expat community, beautiful weather and friendly Barbadians....

Moving-To-San-PedroAn Expat Talks about Moving to San Pedro, Belize

An expat talks about moving to San Pedro, Belize on Ambergris Caye. For $400 per month she lives steps from the beach on the outskirts of town.

An expat talks about moving to San Pedro, Belize on Ambergris Caye. For $400 per month she lives steps from the beach on the outskirts of town....

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /expatguide.cfm
Time Stamp 07-Aug-20 08:13 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.177
Host Name 172.69.63.177


Execution Time

Total Time Avg Time Count Template
546 ms 546 ms 1 /home/www/html/expatguide.cfm
20 ms 20 ms 1 /home/www/html/navtop_rdesign5.cfm
6 ms 6 ms 1 /home/www/html/Application.cfm
5 ms 5 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navcontentbox.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 0 ms 170 /home/www/html/rewritecityname.cfm
1 ms 0 ms 170 /home/www/html/rewriteqoptionsctry.cfm
1 ms 0 ms 170 /home/www/html/rewritereport.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/eetr/rewriterealtorlink.cfm
0 ms 0 ms 3 /home/www/html/eetr/rewritetipheading.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 1 /home/www/html/navpagingbottom_rdesign4.cfm
0 ms 0 ms 12 /home/www/html/rewritearticle.cfm
0 ms 0 ms 8 /home/www/html/rewritereportheading.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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
554 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 @ 20:13:18.018
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 20:13:18.018
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 20:13:18.018
	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 @ 20:13:18.018
	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 @ 20:13:18.018
	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 @ 20:13:18.018
  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
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 20:13:18.018
	Select *
	From Networks
	Where networkID = 159 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 20:13:18.018
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.177'
and logtime > "2020-05-08"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 20:13:18.018
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.177'
and logtime > "2020-08-07 00:00:00.000"
and logtime < "2020-08-07 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 @ 20:13:18.018
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.177'
and logtime > "2020-07-31"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheckallnetworks (Datasource=expert, Time=5ms, Records=153) in /home/www/html/navtop_rdesign5.cfm @ 20:13:18.018
	SELECT *
	From contentcountcountry, Networks
	where contentcountcountry.networkid = Networks.networkid
contentcheckallnetworks (Datasource=expert, Time=5ms, Records=153) in /home/www/html/navtop_rdesign5.cfm @ 20:13:18.018
	SELECT *
	From contentcountcountry, Networks
	where contentcountcountry.networkid = Networks.networkid
gettopbanner (Datasource=expert, Time=2ms, Records=0) in /home/www/html/navleader_rdesign5.cfm @ 20:13:18.018
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eebanner")
	and weight = 1
    and toDate > "2020-08-06"
    and fromDate < "2020-08-07"
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 20:13:18.018
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eebanner")
    and toDate > "2020-08-06"
    and fromDate < "2020-08-07"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 20:13:18.018
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gettaxgeneral (Datasource=expert, Time=25ms, Records=1053) in /home/www/html/expatguide.cfm @ 20:13:18.018
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles 
	Where hitopic <> ''
    and hidescript <> ''
    and type = '3'
    and articles.hihp <> 'n'
    and articles.hinet <> 'n'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
        and summary <> ''
    and publishdate < "2020-08-07"
    ORDER by publishdate desc
checkretirefeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=20) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and city <> ''
         
   	 order by city, date DESC
         
checkparenting (Datasource=expert, Time=6ms, Records=7) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and city <> ''
         
   	 order by city, date DESC
         
checkdreamfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=6ms, Records=20) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and city <> ''
         
   	 order by city, date DESC
         
checkculturefeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=20) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and city <> ''
         
   	 order by city, date DESC
         
checkmovingfeaturereportarticle (Datasource=reports, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '1'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-08-07"
     
         and rptarticlenetworks.networkid = 159 
checkmovingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=20) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
      
         and city <> ''
         
   	 order by city, date DESC
         
checklivingfeaturereportarticle (Datasource=reports, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '2'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-08-07"
      
         and rptarticlenetworks.networkid = 159 
checklivingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
		order by date DESC
checkliving (Datasource=expert, Time=6ms, Records=20) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
      
         and city <> ''
	
   	 order by city, date DESC
         
checkbaby (Datasource=expert, Time=5ms, Records=20) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
   	 order by city, date DESC
         
checkwork (Datasource=expert, Time=5ms, Records=20) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
   	 order by city, date DESC
         
checkschool (Datasource=expert, Time=5ms, Records=20) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
   	 order by city, date DESC
         
getrealestateadvice (Datasource=tipripper, Time=30ms, Records=57) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = allreports.networkid
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 9 
getanswerstext (Datasource=tipripper, Time=6ms, Records=10) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 79973
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 79973 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 79973
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 79973
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79973'
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79973'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 11 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 79973 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '28'
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 20:13:18.018
	SELECT *
	FROM markers
	WHERE answerid = '79973'
	and lat <> ''
	and lng <> ''
checkstatus (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 20:13:18.018
SELECT *
FROM expertusers
WHERE userid = 1
and startdate <{ts '2020-08-06 20:13:18'}
and enddate > {ts '2020-08-07 20:13:18'} 
getrestaurants (Datasource=tipripper, Time=5ms, Records=6) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 15 
getanswerstext (Datasource=tipripper, Time=5ms, Records=5) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 80719
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 80719 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 80719
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 80719
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
	SELECT summary
	FROM answers
	WHERE answers.answerid = '80719'
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80719'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=11ms, Records=0) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 164118
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 164118
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 164118
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 164118
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 164118
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 80719 
getphoto (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80719 
	AND answersphoto.qid = '104'
	
	AND answersphoto.photo <> 'none'
	
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '18'
getmarker (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
	SELECT *
	FROM markers
	WHERE answerid = '80719'
	and lat <> ''
	and lng <> ''
gethealthcare (Datasource=tipripper, Time=17ms, Records=113) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 7 
getanswerstext (Datasource=tipripper, Time=5ms, Records=3) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 65920
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 65920 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 65920
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 65920
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
	SELECT summary
	FROM answers
	WHERE answers.answerid = '65920'
getheading (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 20:13:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65920'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 82485
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 82485
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 82485
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 82485
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 82485
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 65920 
getphoto (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:13:18.018
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 65920 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getmarker (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 20:13:18.018
	SELECT *
	FROM markers
	WHERE answerid = '65920'
	and lat <> ''
	and lng <> ''
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 77006 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76515 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76932 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76808 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 76539 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 76532 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76816 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 77061 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 20:13:18.018
	Select *
	From Networks
	Where networkID = 159 
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 65245
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 48979
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25145
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24101
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 10888
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=7ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 10020
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=7ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 4247
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 1759
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 1696
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 22484
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 73431
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 65756
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 28484
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 2600
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 27287
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 22586
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 10353
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 11865
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 13872
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 20:13:18.018
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 11210
				AND answerstext.qid = 82
					
checkrptarticles (Datasource=reports, Time=0ms, Records=0, Cached Query) in /home/www/html/navcontentbox.cfm @ 20:13:18.018
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-08-07"
     
         and rptarticlenetworks.networkid = 159 
    ORDER by rptarticles.rptarticleID desc
    
gettaxgeneral2 (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navcontentbox.cfm @ 20:13:18.018
	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-08-07"  
    ORDER by articles.articleID desc  
checkretirefeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 20:13:18.018
		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=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 20:13:18.018
		Select summary, hiimg 
		FROM answers
         where answerid = 76142
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 20:13:18.018
		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 @ 20:13:18.018
		Select summary, hiimg 
		FROM answers
         where answerid = 76181
         and summary <> ''
GetCountryList (Datasource=expert, Time=0ms, Records=96, Cached Query) in /home/www/html/navsidesbottom_rdesign5.cfm @ 20:13:18.018
  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/expatguide.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/expatguide.cfm
QUERY_STRING=
REMOTE_ADDR=172.69.63.177
REMOTE_HOST=172.69.63.177
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expatguide.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=33382990
cftoken=70899776
sessionid=IBEXPATEXCHANGE.COM_33382990_70899776
urltoken=CFID=33382990&CFTOKEN=70899776
Debug Rendering Time: 15 ms