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

Expat Guide to Living in Quito

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

Expat Healthcare & Health Insurance

Expat Healthcare & Health Insurance in Quito

An expat living in Quito, Ecuador offers advice about healthcare in Quito. She advises others to go to private hospitals for significant health issues and go to public clinics for only for the basics, i.e. colds and the flu. In her experience, the quality of medical care is good and the cost of healthcare in Ecuador (with health insurance) is much less than the US.

Moving to Quito, Ecuador

One expat talks about the challenges she faced moving to Quito, Ecuador. She advises that people interested in moving to Quito visit, do their homework, know that they will be taken advantage of and walk around their desired neighborhood to find an apartment.

Dream vs Reality of Living in Quito, Ecuador

It's not as warm as I thought it would be in Ecuador, actually it is quite mild on the coast and chilly in the highland towns of Quito and Cuenca. The locals like foreigners and greet them warmly.

Culture Shock Report

Culture shock is part of the settling in process. Knowing the different phases of culture shock and how other expats in Quito handle it can be very comforting. Help others preparing to move to Quito by filling out our Culture Shock Report.

Submit a Culture Shock Report

More Living in Quito Reports

What are people's priorities in Quito - work? family? socializing? 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 Quito:
Submit a Living Overseas Report

More Moving to Quito Reports

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

Reviews of Schools in Quito

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

Dream vs. Reality of Living in Quito Reports

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Quito. If you are already living in Quito, share how those "dreams" have been fulfilled, and how they have not. Below are some of the reports from expats in Quito:
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 Quito by filling out our Overseas Retirement report.

Submit a Retire Abroad Report

Having a Baby Abroad Report

How did expats choose their doctors, midwives, hospitals? What is childbirth like in Quito? Help other expats who are preparing to have a baby in Quito by filling out our Having a Baby Abroad Report.

Submit a Having a Baby Abroad Report

Working Abroad Report

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

Submit a Working Abroad Report
Cigna Expat Health InsuranceExpatriate Health Insurance

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

17-Tips-from-Expats-about-Moving-to-Ecuador17 Tips from Expats about Moving to Ecuador

We asked expats in Ecuador for advice for newcomers. From cost of living to what to bring to culture shock, their insight is a must read for anyone thinking about moving to Ecuador.
We asked expats in Ecuador for advice for newcomers. From cost of living to what to bring to culture shock, their insight is a must read for anyone thinking about moving to Ecuador. ...

Moving-to-EcuadorMoving to Ecuador: Tips for Newcomers in Ecuador

When it comes to getting an insider's perspective on expat life in Ecuador, our Ecuador network is the place to post! With hundreds of posts each month, members cover current events, moving and relocation advice and much more!

When it comes to getting an insider's perspective on expat life in Ecuador, our Ecuador network is the place to post! With hundreds of posts each month, members cover current events, moving and reloc...

Expat-LifeInternational Schools in Ecuador

From the American School of Quito to Acadamia Cotopaxi, we cover the most popular international schools in Ecuador.

From the American School of Quito to Acadamia Cotopaxi, we cover the most popular international schools in Ecuador. ...

Expat-Advice-Expat Advice about Crime & Safety in Ecuador

Advice from Expats in Ecuador about Safety, Security and Crime in Ecuador.

Advice from Expats in Ecuador about Safety, Security and Crime in Ecuador....

Retirement-In-CuencaAn Expat Shares What it's Like Retiring in Cuenca, Ecuador

A retiree talks about what it's like living in Cuenca, Ecuador - she enjoys the slower pace of living, lower cost of living, climate and that she has friends from all over the world.

A retiree talks about what it's like living in Cuenca, Ecuador - she enjoys the slower pace of living, lower cost of living, climate and that she has friends from all over the world. ...

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

Ecuador 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 14-Jul-20 03:40 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.37
Host Name 172.69.63.37


Execution Time

Total Time Avg Time Count Template
247 ms 247 ms 1 top level /home/www/html/expatguide.cfm
27 ms 27 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
26 ms 26 ms 1 /home/www/html/navcontentbox.cfm
26 ms 26 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
12 ms 12 ms 1 /home/www/html/navtop_rdesign5.cfm
6 ms 6 ms 1 /home/www/html/Application.cfm
6 ms 6 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 2 /home/www/html/navinjection.cfm
1 ms 1 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 0 ms 14 /home/www/html/rewritecityname.cfm
1 ms 0 ms 14 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 1 /home/www/html/boolsearch.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/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 14 /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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
255 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 @ 15:40:46.046
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=5ms, Records=1) in /home/www/html/Application.cfm @ 15:40:46.046
      	  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 @ 15:40:46.046
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 15:40:46.046
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 39 
getcities (Datasource=expert, Time=1ms, Records=8) in /home/www/html/navmeta_rdesign4.cfm @ 15:40:46.046
	Select *
	From citynetworks
	Where networkID = 39
	and status <> 'hold'
	ORDER by city
getcity (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 15:40:46.046
	Select *
	From citynetworks
	Where citynetworkid = 4114 
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 15:40:46.046
  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 @ 15:40:46.046
	Select *
	From Networks
	Where networkID = 39 
getphoto (Datasource=expert, Time=1ms, Records=5) in /home/www/html/navmeta_rdesign4.cfm @ 15:40:46.046
	Select *
	From countryphotos
	Where networkID = 39
	and citynetworkid = 4114 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 15:40:46.046
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-04-14"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 15:40:46.046
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-07-14 00:00:00.000"
and logtime < "2020-07-14 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 @ 15:40:46.046
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-07-07"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 15:40:46.046
	SELECT *
	From contentcountcountry
	Where networkid = 39 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 15:40:46.046
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-13"
    and fromDate < "2020-07-14"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 15:40:46.046
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
	Select *
	From citynetworks 
	Where citynetworkid = 4114 
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:46.046
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement, articlecityplace 
 	Where hitopic <> ''
 	and articlePlacement.networkID = 39 
 	and articlecityplace.citynetworkid = 4114
    AND articlecityplace.articleID = articles.articleID
	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 summary <> ''
    and publishdate < "2020-07-14"
    ORDER by articles.articleID desc
gettaxgeneral (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:46.046
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%Quito%') OR (author LIKE '%Quito%') OR (hitopic LIKE '%Quito%') OR (hidescript LIKE '%Quito%')))
	and articlePlacement.networkID = 39 
	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 summary <> ''
    and author <> 'Expat Exchange Member'
   and author <> 'ExpatExchange Member'
      and author <> 'ExpatExchange.com Member'
    and publishdate < "2020-07-14"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Ecuador' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 39 
         and citynetworkid = 4114 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 39 
         and citynetworkid = 4114 
         and city <> ''
         
   	 order by date DESC
   	
checkparenting (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 39 
         and citynetworkid = 4114 
         and city <> ''
         
   	 order by date DESC
   	
checkdreamfeature (Datasource=expert, Time=8ms, Records=2) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 39 
         and citynetworkid = 4114 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=6ms, Records=3) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 39 
         and citynetworkid = 4114 
         and city <> ''
         
   	 order by date DESC
   	
checkculturefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 39 
         and citynetworkid = 4114 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 39 
         and citynetworkid = 4114 
         and city <> ''
         
   	 order by date DESC
   	
checkmovingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 39 
         and citynetworkid = 4114 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=3) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 39 
         and citynetworkid = 4114 
   	 order by date DESC
   	
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 39 
         and citynetworkid = 4114 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 39 
         and citynetworkid = 4114 
   	 order by date DESC
   	
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 39 
         and citynetworkid = 4114 
   	 order by date DESC
   	
checkwork (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 39 
         and citynetworkid = 4114 
   	 order by date DESC
   	
checkschool (Datasource=expert, Time=5ms, Records=3) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 39 
         and citynetworkid = 4114 
   	 order by date DESC
   	
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 21504 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 43696 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 25974 
getrealestateadvice (Datasource=tipripper, Time=6ms, Records=4) in /home/www/html/expatguide.cfm @ 15:40:46.046
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 39
and allreports.networkid = 39
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:46.046
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 39
and allreports.networkid = 39
 and allreports.citynetworkid2 =  4114
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=11ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 39
and allreports.networkid = 39
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:46.046
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 39
and allreports.networkid = 39
 and allreports.citynetworkid2 =  4114
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=9ms, Records=6) in /home/www/html/expatguide.cfm @ 15:40:46.046
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 39
and allreports.networkid = 39
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 39
and allreports.networkid = 39
 and allreports.citynetworkid2 =  4114
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 @ 15:40:46.046
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=5) in /home/www/html/expatguide.cfm @ 15:40:46.046
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 = 79002
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 79002 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 79002
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 79002
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79002'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79002'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:46.046
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 47493
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:46.046
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 47493
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:46.046
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 47493
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:46.046
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 47493
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:46.046
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 47493
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 79002 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:46.046
	SELECT *
	FROM markers
	WHERE answerid = '79002'
	and lat <> ''
	and lng <> ''
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 43696 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 25974 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 21504 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 38926 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 15:40:46.046
	Select *
	From Networks
	Where networkID = 39 
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25878
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25290
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:46.046
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24786
				AND answerstext.qid = 82
					
checkrptarticles (Datasource=reports, Time=4ms, Records=1) in /home/www/html/navcontentbox.cfm @ 15:40:46.046
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-14"
     
         and rptarticlenetworks.networkid = 39 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 15:40:46.046
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 1
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 15:40:46.046
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 39 
getrptarticlephotos (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 15:40:46.046
SELECT  hiimg
FROM rptarticles
where rptarticleID = 1
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=3) in /home/www/html/navcontentbox.cfm @ 15:40:46.046
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 39 
	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-14"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 15:40:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 39 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 15:40:46.046
		Select summary, hiimg 
		FROM answers
         where answerid = 75944
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 15:40:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 39 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 15:40:46.046
		Select summary, hiimg 
		FROM answers
         where answerid = 76175
         and summary <> ''


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=39&citynetworkid=4114
REMOTE_ADDR=172.69.63.37
REMOTE_HOST=172.69.63.37
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=31892697
cftoken=93047113
sessionid=IBEXPATEXCHANGE.COM_31892697_93047113
urltoken=CFID=31892697&CFTOKEN=93047113
URL Parameters:
citynetworkid=4114
networkid=39
Debug Rendering Time: 14 ms