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

Expat Guide to Living in Egypt

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

On the Road in Cairo, Egypt - Jan 28 & 29th 2011

Walter M Woolf,V.M.D. describes his recent travels in Egypt during the protests in Cairo.

Crime in Africa: Some Cities Are Safer Than Others for Expatriates

In Africa, international assignees and their families often face a special security risk simply because they are foreign and, as expatriates, perceived to be wealthy. Keefer offers an overview of the safety of popular cities.

Expat Health Insurance and Healthcare

Expat Health Insurance and Healthcare in Cairo

An expat in Cairo, Egypt says to get doctor recommendations from other expats. He does not have health insurance, but has had a stay in a local private hospital's ICU and been to the ER a few times and is still living to talk about it.

Living in Alexandria, Egypt

An expat in Alexandria, Egypt talks about living in a Muslim country, job opportunities for expats, the importance of family in Egypt and more.

More Culture Shock Reports for Egypt

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

More Living in Egypt Reports

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

Moving Overseas Report

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

Submit a Moving Overseas Report

Dream vs. Reality Report

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Egypt. If you are already living in Egypt, 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 Egypt by taking 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 Egypt? Help other expats who are preparing to have a baby in Egypt 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 Egypt? How difficult was it to obtain a work permit? What types are jobs are typical for expats in Egypt? 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 Egypt from our partner, Cigna Global Health.
Get a Quote

Youre-Not-Too-Old-To-Live-AbroadYou're Not Too Old To Live Abroad

Who doesn't want to get out there and see the world? So many of us put off the prospect of moving overseas until later in life, and that shouldn't keep you from considering retiring abroad.

Who doesn't want to get out there and see the world? So many of us put off the prospect of moving overseas until later in life, and that shouldn't keep you from considering retiring abroad....

Lisbon,-PortugalLisbon, Portugal

Lisbon is the capital and largest city in Portugal, which is one of the most popular countries for expats in Europe. You'll find basic information to help you get acquainted with Lisbon and what it has to offer.

Lisbon is the capital and largest city in Portugal, which is one of the most popular countries for expats in Europe. You'll find basic information to help you get acquainted with Lisbon and what it h...

Chiang-Mai,-ThailandChiang Mai, Thailand

Expats share what it's like living in Chiang Mai and why they move there. With its large expat community of missionaries, retirees, expat families and teachers, Chiang Mai is attractive for many reasons: its size, friendly people, low cost of living and good healthcare.

Expats share what it's like living in Chiang Mai and why they move there. With its large expat community of missionaries, retirees, expat families and teachers, Chiang Mai is attractive for many rea...

Egypt 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.57
Host Name 172.69.63.57


Execution Time

Total Time Avg Time Count Template
331 ms 331 ms 1 /home/www/html/expatguide.cfm
24 ms 24 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
23 ms 23 ms 1 /home/www/html/navcontentbox.cfm
23 ms 23 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/Application.cfm
4 ms 4 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 0 ms 18 /home/www/html/rewritecityname.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/constants.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 5 /home/www/html/rewritearticle.cfm
0 ms 0 ms 18 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 18 /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
338 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:17.017
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 15:40:17.017
      	  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:17.017
	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:17.017
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 40 
getcities (Datasource=expert, Time=1ms, Records=3) in /home/www/html/navmeta_rdesign4.cfm @ 15:40:17.017
	Select *
	From citynetworks
	Where networkID = 40
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 15:40:17.017
  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=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 15:40:17.017
	Select *
	From Networks
	Where networkID = 40 
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 15:40:17.017
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 40
	and guidephoto = 'yes'
	and twimg <> ''
getphoto (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 15:40:17.017
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 40 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 15:40:17.017
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.57'
and logtime > "2020-04-14"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 15:40:17.017
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.57'
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=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 15:40:17.017
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.57'
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:17.017
	SELECT *
	From contentcountcountry
	Where networkid = 40 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 15:40:17.017
	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:17.017
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gettaxgeneral (Datasource=expert, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 15:40:17.017
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 40 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and publishdate < "2020-07-14"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Egypt' 

and qid = 46
checkretirefeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 40 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 40 
         and city <> ''
         
   	 order by city, date DESC
         
checkparenting (Datasource=expert, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 40 
         and city <> ''
         
   	 order by city, date DESC
         
checkdreamfeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 40 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 40 
         and city <> ''
         
   	 order by city, date DESC
         
checkculturefeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 40 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 40 
         and city <> ''
         
   	 order by city, date DESC
         
checkmovingfeaturereportarticle (Datasource=reports, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '1'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-14"
     
         and rptarticlenetworks.networkid = 40 
checkmovingfeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 40 
		order by date DESC
checkmoving (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 40 
   	 order by city, date DESC
         
checklivingfeaturereportarticle (Datasource=reports, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '2'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-14"
      
         and rptarticlenetworks.networkid = 40 
checklivingfeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 40 
		order by date DESC
checkliving (Datasource=expert, Time=6ms, Records=3) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 40 
   	 order by city, date DESC
         
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 40 
   	 order by city, date DESC
         
checkwork (Datasource=expert, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 40 
   	 order by city, date DESC
         
checkschool (Datasource=expert, Time=10ms, Records=12) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 40 
   	 order by city, date DESC
         
getrealestateadvice (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 40
and allreports.networkid = 40
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 40
and allreports.networkid = 40
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=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 40
and allreports.networkid = 40
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=12ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 40
and allreports.networkid = 40
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=12ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 40
and allreports.networkid = 40
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=11ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 40
and allreports.networkid = 40
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:17.017
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=6ms, Records=4) in /home/www/html/expatguide.cfm @ 15:40:17.017
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 = 65935
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 65935 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 65935
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 65935
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
	SELECT summary
	FROM answers
	WHERE answers.answerid = '65935'
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65935'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 7408
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 7408
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=10ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 7408
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 7408
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 7408
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 65935 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '40'
getmarker (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 15:40:17.017
	SELECT *
	FROM markers
	WHERE answerid = '65935'
	and lat <> ''
	and lng <> ''
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 26214 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 24902 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 75392 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 23925 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 15:40:17.017
	Select *
	From Networks
	Where networkID = 40 
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24885
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 1504
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 21840
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 46594
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 27381
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 26158
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 26159
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 18511
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 11384
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 11285
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 10364
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 15:40:17.017
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 3624
				AND answerstext.qid = 82
					
checkrptarticles (Datasource=reports, Time=4ms, Records=0) in /home/www/html/navcontentbox.cfm @ 15:40:17.017
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-14"
     
         and rptarticlenetworks.networkid = 40 
    ORDER by rptarticles.rptarticleID asc   
    
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 15:40:17.017
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 40 
	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=0) in /home/www/html/navcontentbox.cfm @ 15:40:17.017
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 40 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 15:40:17.017
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 40 
          and date > '2013-04-01'
		order by date DESC
gettaxgeneral2 (Datasource=expert, Time=1ms, Records=3) in /home/www/html/navcontentbox.cfm @ 15:40:17.017
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles 
	Where hitopic <> ''
	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 desc  


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=40
REMOTE_ADDR=172.69.63.57
REMOTE_HOST=172.69.63.57
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=31892685
cftoken=26049689
sessionid=IBEXPATEXCHANGE.COM_31892685_26049689
urltoken=CFID=31892685&CFTOKEN=26049689
URL Parameters:
networkID=40
Debug Rendering Time: 15 ms