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

Expat Guide to Living in Monterrey

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

Expat Healthcare & Health Insurance

Expat Healthcare & Health Insurance in Monterrey

An expat in Monterrey, Mexico shares her thoughts about the expat health insurance, the health care system in Monterrey, medical facilities and much more.

Culture Shock Report

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

Submit a Culture Shock Report

Living Overseas Report

What are people's priorities in Monterrey - 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 Monterrey by filling out our Living Overseas Report.

Submit a Living Overseas Report

More Moving to Monterrey Reports

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

Reviews of Schools in Monterrey

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

Dream vs. Reality Report

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Monterrey. If you are already living in Monterrey, 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 Monterrey 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 Monterrey? Help other expats who are preparing to have a baby in Monterrey by filling out our Having a Baby Abroad Report.

Submit a Having a Baby Abroad Report

Working in Monterrey Reports

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

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

Culture-Shock-in-Comitan,-CHIAPASAn Expat Talks about Culture Shock & Living in Comitan, CHIAPAS, Mexico

An expat, who traveled to Mexico to take a 30 day course for teaching ESL, fell in love with Mexico, was offered a job and made the move.

An expat, who traveled to Mexico to take a 30 day course for teaching ESL, fell in love with Mexico, was offered a job and made the move. ...

Living-in-HuatulcoAn Expat Discusses Living in Huatulco, Mexico

An expat in Huatulco talks about living in this remote part of Mexico, which is a 7 hour drive from the nearest city. He cautions anyone considering a move to be realistic about whether or not they can handle the isolation and remoteness.

An expat in Huatulco talks about living in this remote part of Mexico, which is a 7 hour drive from the nearest city. He cautions anyone considering a move to be realistic about whether or not they ...

Expats-Talk-About-The-Biggest-Challenges-They-Face-Living-in-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:...

Living-in-Mexico-CityLiving in Mexico City

Expats talk about the best places to live in Mexico City, living near work to avoid hours of traffic every day, crime in Mexico City, international schools and much more.

Expats talk about the best places to live in Mexico City, living near work to avoid hours of traffic every day, crime in Mexico City, international schools and much more. ...

15-Expats-Talk-About-Life-in-Mexico15 Expats Talk About Life in Mexico

Expats share some insight into what it's like to live in Mexico on a day-to-day basis once you actually make the move and get there.
Expats share some insight into what it's like to live in Mexico on a day-to-day basis once you actually make the move and get there....

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


Execution Time

Total Time Avg Time Count Template
218 ms 218 ms 1 top level /home/www/html/expatguide.cfm
26 ms 26 ms 1 /home/www/html/navcontentbox.cfm
26 ms 26 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
26 ms 26 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/navmeta_rdesign4.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.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 1 /home/www/html/rewritearticlefirsttitle.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 2 /home/www/html/navinjection.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 6 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 6 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 6 /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
224 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 @ 05:15:19.019
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 05:15:19.019
      	  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 @ 05:15:19.019
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 05:15:19.019
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 77 
getcities (Datasource=expert, Time=1ms, Records=21) in /home/www/html/navmeta_rdesign4.cfm @ 05:15:19.019
	Select *
	From citynetworks
	Where networkID = 77
	and status <> 'hold'
	ORDER by city
getcity (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 05:15:19.019
	Select *
	From citynetworks
	Where citynetworkid = 4178 
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 05:15:19.019
  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 @ 05:15:19.019
	Select *
	From Networks
	Where networkID = 77 
getphoto (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 05:15:19.019
	Select *
	From countryphotos
	Where networkID = 77
	and citynetworkid = 4178 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 05:15:19.019
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.249'
and logtime > "2020-04-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 05:15:19.019
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.249'
and logtime > "2020-07-04 00:00:00.000"
and logtime < "2020-07-04 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 05:15:19.019
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.249'
and logtime > "2020-06-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 05:15:19.019
	SELECT *
	From contentcountcountry
	Where networkid = 77 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 05:15:19.019
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-03"
    and fromDate < "2020-07-04"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 05:15:19.019
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 05:15:19.019
	Select *
	From citynetworks 
	Where citynetworkid = 4178 
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement, articlecityplace 
 	Where hitopic <> ''
 	and articlePlacement.networkID = 77 
 	and articlecityplace.citynetworkid = 4178
    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-04"
    ORDER by articles.articleID desc
gettaxgeneral (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%Monterrey%') OR (author LIKE '%Monterrey%') OR (hitopic LIKE '%Monterrey%') OR (hidescript LIKE '%Monterrey%')))
	and articlePlacement.networkID = 77 
	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-04"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 05:15:19.019
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Mexico' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 77 
         and citynetworkid = 4178 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 77 
         and citynetworkid = 4178 
         and city <> ''
         
   	 order by date DESC
   	
checkparenting (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 77 
         and citynetworkid = 4178 
         and city <> ''
         
   	 order by date DESC
   	
checkdreamfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 77 
         and citynetworkid = 4178 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 77 
         and citynetworkid = 4178 
         and city <> ''
         
   	 order by date DESC
   	
checkculturefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 77 
         and citynetworkid = 4178 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 77 
         and citynetworkid = 4178 
         and city <> ''
         
   	 order by date DESC
   	
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 05:15:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 77 
         and citynetworkid = 4178 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 05:15:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 77 
         and citynetworkid = 4178 
   	 order by date DESC
   	
checklivingfeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 77 
         and citynetworkid = 4178 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 77 
         and citynetworkid = 4178 
   	 order by date DESC
   	
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 77 
         and citynetworkid = 4178 
   	 order by date DESC
   	
checkwork (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 05:15:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 77 
         and citynetworkid = 4178 
   	 order by date DESC
   	
checkschool (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 05:15:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 77 
         and citynetworkid = 4178 
   	 order by date DESC
   	
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 05:15:19.019
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 21744 
getrealestateadvice (Datasource=tipripper, Time=6ms, Records=5) in /home/www/html/expatguide.cfm @ 05:15:19.019
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 77
and allreports.networkid = 77
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 @ 05:15:19.019
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 77
and allreports.networkid = 77
 and allreports.citynetworkid2 =  4178
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 @ 05:15:19.019
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 77
and allreports.networkid = 77
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 @ 05:15:19.019
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 77
and allreports.networkid = 77
 and allreports.citynetworkid2 =  4178
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 @ 05:15:19.019
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 77
and allreports.networkid = 77
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=8ms, Records=2) in /home/www/html/expatguide.cfm @ 05:15:19.019
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 77
and allreports.networkid = 77
 and allreports.citynetworkid2 =  4178
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 @ 05:15:19.019
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 @ 05:15:19.019
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 = 78385
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 78385 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 05:15:19.019
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 78385
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 78385
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 05:15:19.019
	SELECT summary
	FROM answers
	WHERE answers.answerid = '78385'
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 05:15:19.019
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '78385'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 34318
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 34318
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 34318
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 34318
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 34318
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 05:15:19.019
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 78385 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 05:15:19.019
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 05:15:19.019
	SELECT *
	FROM markers
	WHERE answerid = '78385'
	and lat <> ''
	and lng <> ''
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 05:15:19.019
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 21744 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 05:15:19.019
	Select *
	From Networks
	Where networkID = 77 
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 05:15:19.019
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 26227
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 05:15:19.019
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24559
				AND answerstext.qid = 82
					
checkculturefeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 05:15:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 77 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 05:15:19.019
		Select summary, hiimg 
		FROM answers
         where answerid = 76808
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 05:15:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 77 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 05:15:19.019
		Select summary, hiimg 
		FROM answers
         where answerid = 76539
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentbox.cfm @ 05:15:19.019
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 77 
	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-04"

    ORDER by articles.articleID desc
    
checkrptarticles (Datasource=reports, Time=4ms, Records=1) in /home/www/html/navcontentbox.cfm @ 05:15:19.019
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-04"
     
         and rptarticlenetworks.networkid = 77 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 05:15:19.019
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 28
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 05:15:19.019
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 77 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 05:15:19.019
SELECT  hiimg
FROM rptarticles
where rptarticleID = 28
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=77&citynetworkid=4178
REMOTE_ADDR=172.69.63.249
REMOTE_HOST=172.69.63.249
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=31002202
cftoken=58593909
sessionid=IBEXPATEXCHANGE.COM_31002202_58593909
urltoken=CFID=31002202&CFTOKEN=58593909
URL Parameters:
citynetworkid=4178
networkid=77
Debug Rendering Time: 11 ms