Home Chile Forum Chile Guide Moving to Chile Real Estate Healthcare in Chile
Chile
Resources
City Guides
JoinSign In
Cigna International Health Insurance

Expat Guide to Living in Chile

Whether you're already living in Chile or preparing to move to Chile, our Expat Guide to Living in Chile offers articles and reports submitted by expats about expat life in Chile. For answers to specific questions, visit our Chile Forum to talk with expats in Chile.

Moving to Chile

If you're moving to Chile, this is a must-read article that covers it all - best places to live, healthcare, earthquakes, driving permits, schools and more.

Moving to Chile: Shipping, Customs Inspections & Extra Baggage

Expats in Chile offer advice to newcomers about shipping to Chile, customs inspections and more.

5 Expats Talk About Living in Chile

5 expats talk about what it's like living in Chile. Expats appreciate the focus on family in Chile, the strong work ethic and the slower pace of life.

5 Important Tips about Healthcare for Expats in Chile

After considering their individual health, Expats moving to Chile should carefully consider the health care options where they'll live, and what else is available in the immediate vicinity.

10 Tips for Living in Chile

Expats in Chile enjoy the stable economy, friendly people and relatively affordable cost-of-living. Many find becoming close friends with Chileans, who primarily socialize with family, a big challenge. But, the expat community in Chile is strong and offers a great support system for newcomers.

12 Tips for Living in Pucon, Chile

12 Tips for Living in Pucon, Chile

An expat in Pucon, Chile has described in detail what it is like to live there as an expatriate. Information offers advice about nightlife, health care, activities, safety, and much, much more.

Moving to Puerto Varas, Chile

An expat in Puerto Varas, Chile talks about moving to Chile with a few suitcases and a shipping container coming in six months. She and her husband lived in temporary housing and investigated areas to live in the south of Chile such as Pucon and Puerto Varas. They love their spacious, new home with amazing views of the lake and volcanoes.

Living in Santiago, Chile

An expat who has lived in Santiago, Chile for 23 years talks about how the city has changed due to immigration and the fact that fewer people are religious.

More Culture Shock Reports for Chile

Culture shock is part of the settling in process. Knowing the different phases of culture shock and how other expats in Chile handle it can be very comforting. Below are some of the responses from expats in Chile:
Submit a Culture Shock Report

More Living in Chile Reports

What are people's priorities in Chile - work? family? What are the best ways to meet other expats? Are people accepting of racial, cultural and religious differences? Below are some of the responses from expats in Chile:
Submit a Living Overseas Report

More Moving to Chile Reports

What should you take with you when you move to Chile? What should you leave behind? What type of housing and neighborhoods are typical for expats in Chile? Below are some of the responses from expats in Chile:
Submit a Moving Overseas Report

Reviews of Schools in Chile

Reviews and school profiles from expat parents and even a few school administrators in Chile. Great place to find insight into school facilities, teachers and curriculum. Below are some of the reviews from expats in Chile:
Submit an International School Review

Dream vs. Reality Report

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Chile. If you are already living in Chile, share how those "dreams" have been fulfilled, and how they have not by filling out our Dream vs. Reality Report.

Submit a Dream vs. Reality Report

Overseas Retirement Report

Retiring abroad can be a great option for retirees seeking their dream lifestyle at an affordable price. Help other retirees, who are thinking about retiring in Chile by taking our Overseas Retirement report.

Submit a Retire Abroad Report

Having a Baby in Chile Reports

How did expats choose their doctors, midwives, hospitals? What is childbirth like in Chile? Below are some of the reports from expats in Chile:
Submit a Having a Baby Abroad Report

Working Abroad Report

What's it like to find a job in Chile? How difficult was it to obtain a work permit? What types are jobs are typical for expats in Chile? Help others following in your footsteps by filling out our Working Abroad Report.

Submit a Working Abroad Report
Additional Articles
Expat Chile: The Best Places to Live in Chile

Expats in Chile enjoy the country's beaches, beautiful cities and lower cost of living. Santiago, La Serena, Vina del Mar and other destinations top their favorite places to live in Chile.

Expat Chile: Living and Starting a Business in Chile

James Jones offers advice about starting a business in Chile. He says that the main thing to remember as an expatriate opening a business in Chile is that customer service is much desired. If you provide a top-notch service to Chilean people, you can expect your business to flourish rapidly.

The Most Sought After Document in South America

Charles Barrett offers some helpful tips to ensure that you minimize risk associated with a lost or stolen passport.

Chile Immigration and Residency Visas

One of the best visa options for investors in Chile, is not an investor visa, but what is called a "retirement and periodic income".

Ten Things You Should Know Before You Move To Central or South America

Lee offers ten tips for people contemplating a move to Central or South America.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Living-in-SantiagoAn Expat Discusses Living in Santiago, Chile

An expat who has lived in Santiago, Chile for 23 years talks about how the city has changed due to immigration and the fact that fewer people are religious.

An expat who has lived in Santiago, Chile for 23 years talks about how the city has changed due to immigration and the fact that fewer people are religious. ...

The-Best-Places-to-Live-in-ChileExpat Chile: The Best Places to Live in Chile

Expats in Chile enjoy the country's beaches, beautiful cities and lower cost of living. Santiago, La Serena, Vina del Mar and other destinations top their favorite places to live in Chile.

Expats in Chile enjoy the country's beaches, beautiful cities and lower cost of living. Santiago, La Serena, Vina del Mar and other destinations top their favorite places to live in Chile....

10-Tips-for-Living-in-Chile10 Tips for Living in Chile

Expats in Chile enjoy the stable economy, friendly people and relatively affordable cost-of-living. Many find becoming close friends with Chileans, who primarily socialize with family, a big challenge. But, the expat community in Chile is strong and offers a great support system for newcomers.

Expats in Chile enjoy the stable economy, friendly people and relatively affordable cost-of-living. Many find becoming close friends with Chileans, who primarily socialize with family, a big challeng...

5-Important-Tips-about-Healthcare-for-Expats-in-Chile5 Important Tips about Healthcare for Expats in Chile

After considering their individual health, Expats moving to Chile should carefully consider the health care options where they'll live, and what else is available in the immediate vicinity.

After considering their individual health, Expats moving to Chile should carefully consider the health care options where they'll live, and what else is available in the immediate vicinity. ...

5-Expats-Talk-About-Living-in-Chile5 Expats Talk About Living in Chile

5 expats talk about what it's like living in Chile. Expats appreciate the focus on family in Chile, the strong work ethic and the slower pace of life.
5 expats talk about what it's like living in Chile. Expats appreciate the focus on family in Chile, the strong work ethic and the slower pace of life. ...

Chile Guide
Other Links
Our Story Our Team Contact Us Submit an Article Advertising Travel Warnings

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /expatguide.cfm
Time Stamp 06-Jul-20 08:04 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.167
Host Name 172.69.63.167


Execution Time

Total Time Avg Time Count Template
226 ms 226 ms 1 top level /home/www/html/expatguide.cfm
26 ms 26 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
24 ms 24 ms 1 /home/www/html/navcontentbox.cfm
24 ms 24 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
12 ms 12 ms 1 /home/www/html/navtop_rdesign5.cfm
11 ms 11 ms 1 /home/www/html/Application.cfm
5 ms 5 ms 1 /home/www/html/navleader_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 1 ms 2 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/constants.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 1 /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 12 /home/www/html/rewritearticle.cfm
0 ms 0 ms 12 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 12 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 12 /home/www/html/rewritereport.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
238 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 @ 08:04:33.033
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=10ms, Records=1) in /home/www/html/Application.cfm @ 08:04:33.033
      	  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 @ 08:04:33.033
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 08:04:33.033
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 30 
getcities (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 08:04:33.033
	Select *
	From citynetworks
	Where networkID = 30
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 08:04:33.033
  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) in /home/www/html/navmeta_rdesign4.cfm @ 08:04:33.033
	Select *
	From Networks
	Where networkID = 30 
getphoto (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 08:04:33.033
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 30
	and guidephoto = 'yes'
	and twimg <> ''
getphoto (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 08:04:33.033
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 30 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 08:04:33.033
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.167'
and logtime > "2020-04-06"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 08:04:33.033
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.167'
and logtime > "2020-07-06 00:00:00.000"
and logtime < "2020-07-06 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 @ 08:04:33.033
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.167'
and logtime > "2020-06-29"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 08:04:33.033
	SELECT *
	From contentcountcountry
	Where networkid = 30 
gettopbanner (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 08:04:33.033
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-07-05"
    and fromDate < "2020-07-06"
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 08:04:33.033
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-07-05"
    and fromDate < "2020-07-06"
UpdatePageViews (Datasource=expert, Time=4ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 08:04:33.033
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gettaxgeneral (Datasource=expert, Time=5ms, Records=9) in /home/www/html/expatguide.cfm @ 08:04:33.033
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 30 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and publishdate < "2020-07-06"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Chile' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 30 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 30 
         and city <> ''
         
   	 order by city, date DESC
         
checkparenting (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 30 
         and city <> ''
         
   	 order by city, date DESC
         
checkdreamfeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 30 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 30 
         and city <> ''
         
   	 order by city, date DESC
         
checkculturefeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 30 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 30 
         and city <> ''
         
   	 order by city, date DESC
         
checkmovingfeaturereportarticle (Datasource=reports, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '1'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-06"
     
         and rptarticlenetworks.networkid = 30 
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 30 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 30 
   	 order by city, date DESC
         
checklivingfeaturereportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '2'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-06"
      
         and rptarticlenetworks.networkid = 30 
checklivingfeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 30 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=3) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 30 
   	 order by city, date DESC
         
checkbaby (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 30 
   	 order by city, date DESC
         
checkwork (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 30 
   	 order by city, date DESC
         
checkschool (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 30 
   	 order by city, date DESC
         
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 08:04:33.033
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 6
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 08:04:33.033
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 30 
getlivingphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
SELECT  hpimg
FROM rptarticles
where rptarticleID = 6
and hpimg <> ''
getrealestateadvice (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 30
and allreports.networkid = 30
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 30
and allreports.networkid = 30
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 @ 08:04:33.033
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=4ms, Records=12) in /home/www/html/expatguide.cfm @ 08:04:33.033
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 = 79820
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 79820 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 79820
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 79820
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79820'
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79820'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 08:04:33.033
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 130194
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 08:04:33.033
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 130194
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 08:04:33.033
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 130194
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 08:04:33.033
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 130194
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 08:04:33.033
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 130194
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
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=1ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 79820 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '30'
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 08:04:33.033
	SELECT *
	FROM markers
	WHERE answerid = '79820'
	and lat <> ''
	and lng <> ''
checkstatus (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 08:04:33.033
SELECT *
FROM expertusers
WHERE userid = 130194
and startdate <{ts '2020-07-05 08:04:33'}
and enddate > {ts '2020-07-06 08:04:33'} 
getrestaurants (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 08:04:33.033
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 30
and allreports.networkid = 30
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 08:04:33.033
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 30
and allreports.networkid = 30
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 08:04:33.033
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 30
and allreports.networkid = 30
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 08:04:33.033
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 30
and allreports.networkid = 30
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74152 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 25800 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 24940 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 75933 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 9957 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 08:04:33.033
	Select *
	From Networks
	Where networkID = 30 
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 72764
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 08:04:33.033
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 65352
				AND answerstext.qid = 82
					
checkculturefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 08:04:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 30 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 08:04:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 30 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 08:04:33.033
		Select summary, hiimg 
		FROM answers
         where answerid = 75933
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 08:04:33.033
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 30 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-06"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 08:04:33.033
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-06"
     
         and rptarticlenetworks.networkid = 30 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=1, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 08:04:33.033
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 6
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 08:04:33.033
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 30 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 08:04:33.033
SELECT  hiimg
FROM rptarticles
where rptarticleID = 6
and hiimg <> ''


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=networkID=30
REMOTE_ADDR=172.69.63.167
REMOTE_HOST=172.69.63.167
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=31146316
cftoken=50399553
sessionid=IBEXPATEXCHANGE.COM_31146316_50399553
urltoken=CFID=31146316&CFTOKEN=50399553
URL Parameters:
networkID=30
Debug Rendering Time: 11 ms