Home Ecuador Forum Ecuador Guide Moving to Ecuador Real Estate Healthcare in Ecuador
Ecuador
Resources
City Guides
JoinSign In
Take the 2020 Expat Exchange Survey

Login

Register Lost Password Lost Username & Password

User Name:

Password:

  

Join Today (free)

Join Expat Exchange to meet expats in your area or get advice before your move. It's FREE and takes 1 minute!

Cigna Expat Health InsuranceExpatriate Health Insurance

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

13-Expats-Talk-about-Living-in-Ecuador13 Expats Talk about Living in Ecuador

Expats in Ecuador talk about what its like living in Ecuador. From the lower cost of living to its wonderful climate to the focus on family, Ecuador is a popular destination for retirees and other expats.
Expats in Ecuador talk about what its like living in Ecuador. From the lower cost of living to its wonderful climate to the focus on family, Ecuador is a popular destination for retirees and other ex...

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

Moving-to-Ecuador11 Things to Know Before Moving to Cuenca, Ecuador

Cuenca is Ecuador's third largest city, but still has a small-city feeling. Expats share 11 things they wish they had known before moving to Cuenca from packing sunscreen to being aware of gringo gouging.

Cuenca is Ecuador's third largest city, but still has a small-city feeling. Expats share 11 things they wish they had known before moving to Cuenca from packing sunscreen to being aware of gringo gou...

Retirement-In-Bahia-de-CaraquezAn Expat Shares What it's Like Retiring in Bahia de Caraquez, Ecuador

An expat who retired to Bahia de Caraquez, Ecuador enjoys Bahia's very low cost of living, fresh uncontaminated food and warm climate. He wishes he had been more cautious with investments given the issues in Ecuador with the 7.8 earthquake last April. The experience has taught him a lot about buying property and property laws.

An expat who retired to Bahia de Caraquez, Ecuador enjoys Bahia's very low cost of living, fresh uncontaminated food and warm climate. He wishes he had been more cautious with investments given the i...

Moving-To-CuencaAn Expat Talks about Moving to Cuenca, Ecuador

An expat in Cuenca, Ecuador advises others to take an exploratory trip before committing to making the move. Then, if you do move to Cuenca, leave your furniture at home since it's very expensive to ship and furniture is very reasonably priced in Ecuador.

An expat in Cuenca, Ecuador advises others to take an exploratory trip before committing to making the move. Then, if you do move to Cuenca, leave your furniture at home since it's very expensive to ...

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 /expat/index.cfm
Time Stamp 02-Jun-20 02:21 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.127
Host Name 172.69.63.127


Execution Time

Total Time Avg Time Count Template
92 ms 92 ms 1 /home/www/html/expat/Application.cfm
62 ms 62 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
62 ms 62 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
61 ms 61 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
31 ms 31 ms 1 /home/www/html/navcontentbox.cfm
22 ms 22 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
16 ms 16 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/navtop_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/expat/constants.cfm
1 ms 1 ms 1 /home/www/html/expat/ibstyle.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_GetModerators.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/expat/copyright.cfm
0 ms 0 ms 1 /home/www/html/expat/datasources.cfm
0 ms 0 ms 1 /home/www/html/expat/ibkey.cfm
0 ms 0 ms 1 /home/www/html/expat/index.cfm
0 ms 0 ms 1 /home/www/html/expat/instaboard.cfm
0 ms 0 ms 1 /home/www/html/expat/login.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_DesignSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GetCategory.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_rdesign4.cfm
0 ms 0 ms 2 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereport.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
93 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GeneralSet.cfm @ 02:21:29.029
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/expat/Application.cfm @ 02:21:29.029
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 02:21:29.029
	Select *
	From Networks
	Where frmid = 202 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:21:29.029
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:21:29.029
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 39 
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:21:29.029
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 202 
getcities (Datasource=expert, Time=1ms, Records=8) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:21:29.029
	Select *
	From citynetworks
	Where networkID = 39
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:21:29.029
  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/navmetaforums_rdesign5.cfm @ 02:21:29.029
	Select *
	From Networks
	Where networkID = 39 
GetTopicTitle (Datasource=forum, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:21:29.029
  SELECT f.frmid as frmid, frmname, t.tpcname, m.msgtext, t.urlchanged, t.tpcrewriteurl, t.section, t.citynetworkid, t.tpcnamenew, t.summary, t.keywords, m.msgid
  FROM forums f, topics t, messages m  
  WHERE f.frmid = 202 
  AND t.tpcid = 3386713 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
  AND t.tpcid = m.tpcid
  AND m.msgparent = 0
GetTopicInformation (Datasource=forum, Time=5ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:21:29.029
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext as msgintro, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.userid, u.userid, u.username, t.msgcount-1 as replycount, topicimage, topicimageapproved
  FROM messages m, users u, topics t
  WHERE m.tpcid = 3386713
  and  t.tpcid = 3386713
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
GetTopicInformation (Datasource=forum, Time=4ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:21:29.029
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext as msgintro, m.msgparent, m.msghost, m.msgdate, m.msgupdate, t.tpcupdate, m.replylevel, m.userid, u.userid, u.username, t.msgcount-1 as replycount, topicimage, topicimageapproved
  FROM messages m, users u, topics t
  WHERE m.tpcid = 3386713
  and  t.tpcid = 3386713
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=1ms, Records=29) in /home/www/html/navmetaforums_rdesign5.cfm @ 02:21:29.029
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 39
	order by lastsent ASC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 02:21:29.029
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-03-03"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 02:21:29.029
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-06-02 00:00:00.000"
and logtime < "2020-06-02 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 @ 02:21:29.029
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-05-26"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 02:21:29.029
	SELECT *
	From contentcountcountry
	Where networkid = 39 
gettopbanner (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 02:21:29.029
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-06-01"
    and fromDate < "2020-06-02"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 02:21:29.029
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 874 
GetNavigator (Datasource=forum, Time=0ms, Records=1) in /home/www/html/expat/Application.cfm @ 02:21:29.029
  SELECT catid, allowattach, isreviewed, isprivate, f.frmid as frmid, frmname, frmdesc, frmorder, frmpass, frmnotice, isapproved, f.isclosed as frmclosed, tpcname, tpcid, t.isclosed as tpcclosed, ispoll, isreviewed
  FROM forums f, topics t  
  WHERE f.frmid = 202 
  AND tpcid = 3386713 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
GetModerators (Datasource=forum, Time=1ms, Records=1) in /home/www/html/expat/queries/qry_GetModerators.cfm @ 02:21:29.029
  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 202
  AND u.userdbname = "ee"
  ORDER BY u.username
GetCategory (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GetCategory.cfm @ 02:21:29.029
  SELECT *
  FROM categories
  WHERE catid = "2"
DesignSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 02:21:29.029
  SELECT * FROM designset
  WHERE designsetid = 11 
getclasscheck (Datasource=tipripper, Time=29ms, Records=7) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 02:21:29.029
	SELECT answersphoto.photo, answersphoto.answerid, answersphoto.qid, answers.rid, allreports.networkname, allreports.networkid, allreports.city, allreports.state
	FROM answersphoto, answers, allreports 
	WHERE answersphoto.answerid = answers.answerid
	and allreports.answerid = answers.answerid
	and allreports.topicid = 6
	and allreports.hide <> 'y'
	and (answers.paid = 'yes' or answers.paid = 'free')
	AND answersphoto.qid = '104'
	AND allreports.networkid = 39
	AND "2020-06-02" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkrptarticles (Datasource=reports, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 02:21:29.029
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-02"
     
         and rptarticlenetworks.networkid = 39 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 02:21:29.029
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 7
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 02:21:29.029
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 39 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 02:21:29.029
SELECT  hiimg
FROM rptarticles
where rptarticleID = 7
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentbox.cfm @ 02:21:29.029
	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-06-02"

    ORDER by articles.articleID desc
    
checkretirefeature (Datasource=expert, Time=6ms, Records=4) in /home/www/html/navcontentbox.cfm @ 02:21:29.029
		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 @ 02:21:29.029
		Select summary, hiimg 
		FROM answers
         where answerid = 73772
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 02:21:29.029
		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=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 02:21:29.029
		Select summary, hiimg 
		FROM answers
         where answerid = 68442
         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/expat/index.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/expat/index.cfm
QUERY_STRING=pr=replymsg&frmid=202&tpcid=3386713&msgid=235820
REMOTE_ADDR=172.69.63.127
REMOTE_HOST=172.69.63.127
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expat/index.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Cookie Variables:
MS=flat
Session Variables:
cfid=28855457
cftoken=87952223
sessionid=IBEXPATEXCHANGE.COM_28855457_87952223
urltoken=CFID=28855457&CFTOKEN=87952223
URL Parameters:
frmid=202
msgid=235820
pr=replymsg
tpcid=3386713
Debug Rendering Time: 15 ms