Home Guatemala Forum Guatemala Guide Moving to Guatemala Real Estate Healthcare in Guatemala
Guatemala
Resources
City Guides
JoinSign In
AGS Worldwide Movers

Expat Guide to Living in Guatemala City

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

Expat Health Insurance and Healthcare

Expat Health Insurance and Healthcare in Guatemala City

An expat who lives several hours from Guatemala City explains that he would only use the local hospital in an emergency to be stabilized before going a hospital in Guatemala city. He explains most prescription medicines are available in Guatemala, but expensive.

Culture Shock in Guatemala City, Guatemala

My biggest problem was understanding that I was no longer in the U.S. and had to accept the way things were done in Guatemala or leave. That took at least two to three years of banging my head against the wall before I accepted that things run differently here.

More Culture Shock Reports for Guatemala City

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

Living Overseas Report

What are people's priorities in Guatemala City - work? family? socializing? What are the best ways to meet other expats? Are people accepting of racial, cultural and religious differences? Help other expats and people moving to Guatemala City by filling out our Living Overseas Report.

Submit a Living Overseas Report

Moving Overseas Report

What should you take with you when you move to Guatemala City? What should you leave behind? What type of housing and neighborhoods are typical for expats in Guatemala City? Help others moving to Guatemala City by filling out our Moving Overseas Report.

Submit a Moving Overseas Report

International School Report

Parents are invited to answer questions about the schools that their kids attend (Pre-K through High School) in hopes of helping others moving to Guatemala City with the school selection process. If you have expat children who attend school in Guatemala City, take a few minutes to submit a School Review.

Submit an International School Review

Dream vs. Reality Report

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Guatemala City. If you are already living in Guatemala City, 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 Guatemala City by filling out our Overseas Retirement report.

Submit a Retire Abroad Report

Having a Baby in Guatemala City Reports

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

Working in Guatemala City Reports

What's it like to find a job in Guatemala City? How difficult was it to obtain a work permit? What types are jobs are typical for expats in Guatemala City? Below are some of the reports from expats in Guatemala City:
Submit a Working Abroad Report
Cigna Expat Health InsuranceExpatriate Health Insurance

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

Top-5-Reasons-Expats-Move-to-Central-AmericaTop 5 Reasons Expats Move to Central America

From lower cost of living to affordable healthcare and beachfront living, expats discuss the top reasons they moved to Central America.
From lower cost of living to affordable healthcare and beachfront living, expats discuss the top reasons they moved to Central America....

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

Expats-in-GuatemalaExpats in Guatemala: Pros and Cons of Living in Guatemala

Expats are very forthcoming about the pros and cons of living in Guatemala. Pros include the spring-like weather, the low cost of living and the lifestyle. Cons include limited access to quality healthcare (especially outside of Guatemala City), gringo pricing, crime and the reality that the rainy season can be depressing.

Expats are very forthcoming about the pros and cons of living in Guatemala. Pros include the spring-like weather, the low cost of living and the lifestyle. Cons include limited access to quality hea...

Moving-To-PanajachelAn Expat Talks about Moving to Panajachel, Guatemala

A French expat who went to Panajachel, Guatemala on vacation loved the climate and locals so much he ended up staying. He advises other newcomers to rent first, pack lightly, use a lawyer and translator when signing contracts and leave your prejudices behind.

A French expat who went to Panajachel, Guatemala on vacation loved the climate and locals so much he ended up staying. He advises other newcomers to rent first, pack lightly, use a lawyer and transla...

Guatemala 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 05-Jul-20 01:57 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.198
Host Name 162.158.78.198


Execution Time

Total Time Avg Time Count Template
253 ms 253 ms 1 /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
11 ms 11 ms 1 /home/www/html/navtop_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.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/boolsearch.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 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/rewritearticle.cfm
0 ms 0 ms 8 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 8 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 8 /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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
258 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=1ms, Records=1, Cached Query) in /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm @ 01:57:45.045
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 01:57:45.045
      	  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 @ 01:57:45.045
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 01:57:45.045
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 49 
getcities (Datasource=expert, Time=0ms, Records=4) in /home/www/html/navmeta_rdesign4.cfm @ 01:57:45.045
	Select *
	From citynetworks
	Where networkID = 49
	and status <> 'hold'
	ORDER by city
getcity (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 01:57:45.045
	Select *
	From citynetworks
	Where citynetworkid = 4138 
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 01:57:45.045
  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 @ 01:57:45.045
	Select *
	From Networks
	Where networkID = 49 
getphoto (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navmeta_rdesign4.cfm @ 01:57:45.045
	Select *
	From countryphotos
	Where networkID = 49
	and citynetworkid = 4138 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 01:57:45.045
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.198'
and logtime > "2020-04-05"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 01:57:45.045
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.198'
and logtime > "2020-07-05 00:00:00.000"
and logtime < "2020-07-05 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 @ 01:57:45.045
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.198'
and logtime > "2020-06-28"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 01:57:45.045
	SELECT *
	From contentcountcountry
	Where networkid = 49 
gettopbanner (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 01:57:45.045
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-04"
    and fromDate < "2020-07-05"
    and bannerPlacement.networkid = 49
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 01:57:45.045
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 01:57:45.045
	Select *
	From citynetworks 
	Where citynetworkid = 4138 
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 01:57:45.045
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement, articlecityplace 
 	Where hitopic <> ''
 	and articlePlacement.networkID = 49 
 	and articlecityplace.citynetworkid = 4138
    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-05"
    ORDER by articles.articleID desc
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 01:57:45.045
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%Guatemala%') OR (author LIKE '%Guatemala%') OR (hitopic LIKE '%Guatemala%') OR (hidescript LIKE '%Guatemala%')) AND ((title LIKE '%City%') OR (author LIKE '%City%') OR (hitopic LIKE '%City%') OR (hidescript LIKE '%City%')))
	and articlePlacement.networkID = 49 
	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-05"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 01:57:45.045
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Guatemala' 

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

    ORDER by articles.articleID desc
    
checkretirefeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/navcontentbox.cfm @ 01:57:45.045
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 49 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 01:57:45.045
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 49 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 01:57:45.045
		Select summary, hiimg 
		FROM answers
         where answerid = 74524
         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=49&citynetworkid=4138
REMOTE_ADDR=162.158.78.198
REMOTE_HOST=162.158.78.198
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=31056535
cftoken=75181291
sessionid=IBEXPATEXCHANGE.COM_31056535_75181291
urltoken=CFID=31056535&CFTOKEN=75181291
URL Parameters:
citynetworkid=4138
networkid=49
Debug Rendering Time: 11 ms