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.

Expats Talk About The Biggest Challenges They Face Living in Latin America

Expats talk about some of the biggest challenges they've faced living in Latin America. Whether you're moving to Panama City or Punta del Este, this article is a must read to help you prepare (hint: you'll be much happier if you learn the language) and adjust your expectations (realities: the roads are rough, the pace of life is slower and bureaucracy is unavoidable). Despite all of the challenges, the list of what expats like about life in Latin America far exceeds the challenges.

Cost of Living: Costa Rica vs. Panama

People considering a move to Central America often narrow down their list to Panama and Costa Rica. Expats talk about the cost of living in Panama and Costa Rica - housing costs, gas, car, electric, internet, groceries, budgets for various lifestyles and more.

Healthcare in the Czech Republic

Important information about healthcare in Czech Republic, including health insurance requirements, quality of healthcare and more.

Expats Talk About The Biggest Challenges They Face Living in Europe

Living in Europe can be a dream realized for many expats, but that doesn't mean that adjusting to life there comes without its challenges. Expats share some of the biggest challenges they've faced from learning the language, making friends and dealing with the bureaucracy are some of the most common.

12 Tips for Living in Rio Chico, Ecuador

12 Tips for Living in Rio Chico, Ecuador

An expat talks about what life is like in Rio Chico, Ecuador, a small beach town about 10 minutes from Montanita. With 12 hours of sunlight every day, beautiful beaches and terrific local shops, life in Rio Chico sounds wonderful.

Vieux-Port Steakhouse

Vieux-Port Steakhouse

High end steakhouse in Old Montreal. Great wine list, very dimly lit, nice ambience. Lunch, dinner and Sunday brunch. Live music, outdoor terrasse surrounded by ivy-covered walls make for a wonderful dining experience during warm-weather months. Good for business dinners.

Expat Health Insurance and Healthcare

Expat Health Insurance and Healthcare in Grecia

An expat in Grecia, Costa Rica advises other expats to head to San Jose for medical care. He hasn't heard any good things about the local CAJA hospital.

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.

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.

Culture Shock in Hannover, Germany

Do you need to learn German before moving to Hannover? What are Germans like? An expat talks about living in Hannover, the cultural stereotype about German people being rude, healthcare in Germany and more.

Culture Shock in Montezuma , Costa Rica

An expat talks about what it's like living in Montezuma, Costa Rica. The challenges he found in Montezuma where terrible roads, power outages, the language barrier and the prohibitively high cost of shipping into the country.

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

Additional Articles
10 Expats Share Tips for Moving to Costa Rica

Expats in Costa Rica answer the question: If a friend of yours was thinking of moving here, what other advice would you give them. One expat summed it up perfectly when he said not to let your desire to live in paradise get in the way of thinking about the logistics. Here's what other expats had to say.

How are People around the World Handling the Pandemic?

Expats talk about how people in their countries are handling the pandemic. In some places, it hardly seems like people know that there is a pandemic, while people in most other countries are complying with the stay-at-home orders.

Expat Entertainment: Travel Movies

If you're looking for a short list of travel related films to fill the need for some escapism, look no further! Here's an international list of gems that will leave you thirsting for more.

Are Expats Running Out of Supplies?

We surveyed expats and asked if they are running low on supplies abroad. The responses are varied and seem closely tied to the progression of the pandemic in each country.

How to Immigrate to Spain: A Guide for First Movers

An overview of how to move to Spain and immigration options for non-EU citizens. Covers different long-term visa options.

Healthcare in the Netherlands

9 important things for expats to know about healthcare in the Netherlands. Include information about health insurance requirements for residency, prescription medications, emergency medical care, ambulance service and more.

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

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Latin-AmericaExpats Talk About The Biggest Challenges They Face Living in Latin America

Expats talk about some of the biggest challenges they've faced living in Latin America. Whether you're moving to Panama City or Punta del Este, this article is a must read to help you prepare (hint: you'll be much happier if you learn the language) and adjust your expectations (realities: the roads are rough, the pace of life is slower and bureaucracy is unavoidable). Despite all of the challenges, the list of what expats like about life in Latin America far exceeds the challenges.

Expats talk about some of the biggest challenges they've faced living in Latin America. Whether you're moving to Panama City or Punta del Este, this article is a must read to help you prepare (hint:...

Cost-of-LivingCost of Living: Costa Rica vs. Panama

People considering a move to Central America often narrow down their list to Panama and Costa Rica. Expats talk about the cost of living in Panama and Costa Rica - housing costs, gas, car, electric, internet, groceries, budgets for various lifestyles and more.

People considering a move to Central America often narrow down their list to Panama and Costa Rica. Expats talk about the cost of living in Panama and Costa Rica - housing costs, gas, car, electric, ...

Living-in-the-Czech-RepublicHealthcare in the Czech Republic

Important information about healthcare in Czech Republic, including health insurance requirements, quality of healthcare and more.

Important information about healthcare in Czech Republic, including health insurance requirements, quality of healthcare and more....

Retirement-In-TobercurryAn Expat Shares What it's Like Retiring in Tobercurry, Ireland

A expat in Tobercurry talks about how she and her husband chose to retire in Ireland - the more affordable lifestyle (living on less than $2,000 a month), Ireland's public healthcare system, finding a home through an Estate Agent, enjoying walking everywhere and not needing a car, the sense of safety and more. She cannot stress enough that anyone thinking about retiring in Ireland research diligently and seek the advice of other expats.

A expat in Tobercurry talks about how she and her husband chose to retire in Ireland - the more affordable lifestyle (living on less than $2,000 a month), Ireland's public healthcare system, finding a...

Moving-To-SalinasAn Expat Talks about Moving to Salinas, Ecuador

An expat talks about moving to Salinas, Ecuador - the lower cost of living, beach life and what to bring to make it feel like home.

An expat talks about moving to Salinas, Ecuador - the lower cost of living, beach life and what to bring to make it feel like home....

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /expatguide.cfm
Time Stamp 28-May-20 02:47 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.194
Host Name 162.158.78.194


Execution Time

Total Time Avg Time Count Template
443 ms 443 ms 1 /home/www/html/expatguide.cfm
7 ms 7 ms 1 /home/www/html/navtop_rdesign5.cfm
5 ms 5 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/navrightmidcolumn_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navcontentbox.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 0 ms 170 /home/www/html/rewritereport.cfm
1 ms 0 ms 170 /home/www/html/rewriteqoptionsctry.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/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 13 /home/www/html/rewritearticle.cfm
0 ms 0 ms 170 /home/www/html/rewritecityname.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
0 ms 0 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
448 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 @ 14:47:57.057
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 14:47:57.057
      	  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 @ 14:47:57.057
	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 @ 14:47:57.057
	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 @ 14:47:57.057
	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 @ 14:47:57.057
  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 @ 14:47:57.057
	Select *
	From Networks
	Where networkID = 159 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 14:47:57.057
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-02-27"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 14:47:57.057
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-05-28 00:00:00.000"
and logtime < "2020-05-28 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 @ 14:47:57.057
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-05-21"
and param1 = 'awdyn'
ORDER BY logtime DESC
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 14:47:57.057
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eebanner")
	and weight = 10
    and toDate > "2020-05-27"
    and fromDate < "2020-05-28"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 14:47:57.057
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gettaxgeneral (Datasource=expert, Time=22ms, Records=1050) in /home/www/html/expatguide.cfm @ 14:47:57.057
	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-05-28"
    ORDER by publishdate desc
checkretirefeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 14:47:57.057
		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 @ 14:47:57.057
		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=5ms, Records=7) in /home/www/html/expatguide.cfm @ 14:47:57.057
		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 @ 14:47:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=20) in /home/www/html/expatguide.cfm @ 14:47:57.057
		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 @ 14:47:57.057
		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 @ 14:47:57.057
		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=0ms, Records=0) in /home/www/html/expatguide.cfm @ 14:47:57.057
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '1'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-28"
     
         and rptarticlenetworks.networkid = 159 
checkmovingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 14:47:57.057
		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 @ 14:47:57.057
		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=0ms, Records=0) in /home/www/html/expatguide.cfm @ 14:47:57.057
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '2'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-28"
      
         and rptarticlenetworks.networkid = 159 
checklivingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 14:47:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=20) in /home/www/html/expatguide.cfm @ 14:47:57.057
		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 @ 14:47:57.057
		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 @ 14:47:57.057
		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 @ 14:47:57.057
		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=28ms, Records=56) in /home/www/html/expatguide.cfm @ 14:47:57.057
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=0ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:57.057
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=5ms, Records=12) in /home/www/html/expatguide.cfm @ 14:47:57.057
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 = 80407
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 80407 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:57.057
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 80407
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 80407
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:57.057
	SELECT summary
	FROM answers
	WHERE answers.answerid = '80407'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:57.057
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80407'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 14:47:57.057
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 128279
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 14:47:57.057
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 128279
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 14:47:57.057
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 128279
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 14:47:57.057
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 128279
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 14:47:57.057
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 128279
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:57.057
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 @ 14:47:57.057
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 80407 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:57.057
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 14:47:57.057
	SELECT *
	FROM markers
	WHERE answerid = '80407'
	and lat <> ''
	and lng <> ''
checkstatus (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 14:47:57.057
SELECT *
FROM expertusers
WHERE userid = 128279
and startdate <{ts '2020-05-27 14:47:57'}
and enddate > {ts '2020-05-28 14:47:57'} 
getrestaurants (Datasource=tipripper, Time=5ms, Records=6) in /home/www/html/expatguide.cfm @ 14:47:57.057
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 @ 14:47:57.057
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=4ms, Records=5) in /home/www/html/expatguide.cfm @ 14:47:57.057
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 = 80293
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 80293 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:57.057
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 80293
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 80293
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:57.057
	SELECT summary
	FROM answers
	WHERE answers.answerid = '80293'
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:57.057
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80293'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=7ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:57.057
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=7ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
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=7ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
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=7ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
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 @ 14:47:58.058
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
 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 80293 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '28'
getmarker (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
	SELECT *
	FROM markers
	WHERE answerid = '80293'
	and lat <> ''
	and lng <> ''
gethealthcare (Datasource=tipripper, Time=15ms, Records=112) in /home/www/html/expatguide.cfm @ 14:47:58.058
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=1ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
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=4ms, Records=4) in /home/www/html/expatguide.cfm @ 14:47:58.058
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 = 65936
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 65936 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 65936
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 65936
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
	SELECT summary
	FROM answers
	WHERE answers.answerid = '65936'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65936'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=10ms, Records=0) in /home/www/html/expatguide.cfm @ 14:47:58.058
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 70105
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 14:47:58.058
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 70105
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 14:47:58.058
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 70105
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 14:47:58.058
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 70105
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 14:47:58.058
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 70105
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 65936 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '33'
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 14:47:58.058
	SELECT *
	FROM markers
	WHERE answerid = '65936'
	and lat <> ''
	and lng <> ''
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76515 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76181 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76524 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76477 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 76539 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 76532 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76816 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76511 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 14:47:58.058
	Select *
	From Networks
	Where networkID = 159 
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 65245
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 48979
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25145
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24101
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 10888
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 10020
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
				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 @ 14:47:58.058
				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 @ 14:47:58.058
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 1696
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
				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 @ 14:47:58.058
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 73431
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 65756
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
				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 @ 14:47:58.058
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 2600
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
				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 @ 14:47:58.058
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 22586
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 10353
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 11865
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 13872
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 14:47:58.058
				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 @ 14:47:58.058
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-28"
     
         and rptarticlenetworks.networkid = 159 
    ORDER by rptarticles.rptarticleID desc
    
gettaxgeneral2 (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navcontentbox.cfm @ 14:47:58.058
	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-05-28"  
    ORDER by articles.articleID desc  
checkretirefeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 14:47:58.058
		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 @ 14:47:58.058
		Select summary, hiimg 
		FROM answers
         where answerid = 76137
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 14:47:58.058
		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 @ 14:47:58.058
		Select summary, hiimg 
		FROM answers
         where answerid = 76175
         and summary <> ''
GetCountryList (Datasource=expert, Time=0ms, Records=96, Cached Query) in /home/www/html/navsidesbottom_rdesign5.cfm @ 14:47:58.058
  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=162.158.78.194
REMOTE_HOST=162.158.78.194
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=28591896
cftoken=95104265
sessionid=IBEXPATEXCHANGE.COM_28591896_95104265
urltoken=CFID=28591896&CFTOKEN=95104265
Debug Rendering Time: 12 ms