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

Expat Guide to Living in Cape Town

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

Culture Shock Report

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

Submit a Culture Shock Report

Living Overseas Report

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

Submit a Living Overseas Report

More Moving to Cape Town Reports

What should you take with you when you move to Cape Town? What should you leave behind? What type of housing and neighborhoods are typical for expats in Cape Town? Below are some of the responses from expats in Cape Town:
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 Cape Town with the school selection process. If you have expat children who attend school in Cape Town, 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 Cape Town. If you are already living in Cape Town, 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 Cape Town 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 Cape Town? Help other expats who are preparing to have a baby in Cape Town 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 Cape Town? How difficult was it to obtain a work permit? What types are jobs are typical for expats in Cape Town? 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 South Africa from our partner, Cigna Global Health.
Get a Quote

Expat-South-Africa10 Tips for Living in South Africa

The reviews of expat life in South Africa are mixed. Some expats feel that crime is a big problem and causing an expat exodus. Others debate that the crime rates match those of other big cities in the world.

The reviews of expat life in South Africa are mixed. Some expats feel that crime is a big problem and causing an expat exodus. Others debate that the crime rates match those of other big cities in t...

South Africa 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 12:17 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.227
Host Name 172.69.63.227


Execution Time

Total Time Avg Time Count Template
274 ms 274 ms 1 /home/www/html/expatguide.cfm
32 ms 32 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
31 ms 31 ms 1 /home/www/html/navcontentbox.cfm
31 ms 31 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
12 ms 12 ms 1 /home/www/html/navtop_rdesign5.cfm
4 ms 4 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 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/boolsearch.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 1 /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
3 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
281 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 @ 12:17:12.012
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 12:17:12.012
      	  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 @ 12:17:12.012
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 12:17:12.012
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 100 
getcities (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navmeta_rdesign4.cfm @ 12:17:12.012
	Select *
	From citynetworks
	Where networkID = 100
	and status <> 'hold'
	ORDER by city
getcity (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 12:17:12.012
	Select *
	From citynetworks
	Where citynetworkid = 4219 
GetForums (Datasource=forum, Time=1ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 12:17:12.012
  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 @ 12:17:12.012
	Select *
	From Networks
	Where networkID = 100 
getphoto (Datasource=expert, Time=1ms, Records=3) in /home/www/html/navmeta_rdesign4.cfm @ 12:17:12.012
	Select *
	From countryphotos
	Where networkID = 100
	and citynetworkid = 4219 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:17:12.012
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.227'
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 @ 12:17:12.012
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.227'
and logtime > "2020-07-14 00:00:00.000"
and logtime < "2020-07-14 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 12:17:12.012
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.227'
and logtime > "2020-07-07"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:17:12.012
	SELECT *
	From contentcountcountry
	Where networkid = 100 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 12:17:12.012
	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=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 12:17:12.012
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 12:17:12.012
	Select *
	From citynetworks 
	Where citynetworkid = 4219 
gettaxgeneral (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:12.012
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement, articlecityplace 
 	Where hitopic <> ''
 	and articlePlacement.networkID = 100 
 	and articlecityplace.citynetworkid = 4219
    AND articlecityplace.articleID = articles.articleID
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and summary <> ''
    and publishdate < "2020-07-14"
    ORDER by articles.articleID desc
gettaxgeneral (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%Cape%') OR (author LIKE '%Cape%') OR (hitopic LIKE '%Cape%') OR (hidescript LIKE '%Cape%')) AND ((title LIKE '%Town%') OR (author LIKE '%Town%') OR (hitopic LIKE '%Town%') OR (hidescript LIKE '%Town%')))
	and articlePlacement.networkID = 100 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and summary <> ''
    and author <> 'Expat Exchange Member'
   and author <> 'ExpatExchange Member'
      and author <> 'ExpatExchange.com Member'
    and publishdate < "2020-07-14"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 12:17:13.013
SELECT qoid, value 
FROM qoptions 

WHERE value = 'South Africa' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 100 
         and citynetworkid = 4219 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 100 
         and citynetworkid = 4219 
         and city <> ''
         
   	 order by date DESC
   	
checkparenting (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 100 
         and citynetworkid = 4219 
         and city <> ''
         
   	 order by date DESC
   	
checkdreamfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 100 
         and citynetworkid = 4219 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 100 
         and citynetworkid = 4219 
         and city <> ''
         
   	 order by date DESC
   	
checkculturefeature (Datasource=expert, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 100 
         and citynetworkid = 4219 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 100 
         and citynetworkid = 4219 
         and city <> ''
         
   	 order by date DESC
   	
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 12:17:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 100 
         and citynetworkid = 4219 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 12:17:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 100 
         and citynetworkid = 4219 
   	 order by date DESC
   	
checklivingfeature (Datasource=expert, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 100 
         and citynetworkid = 4219 
		order by date DESC
checkliving (Datasource=expert, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 100 
         and citynetworkid = 4219 
   	 order by date DESC
   	
checkbaby (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 100 
         and citynetworkid = 4219 
   	 order by date DESC
   	
checkwork (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 100 
         and citynetworkid = 4219 
   	 order by date DESC
   	
checkschool (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 100 
         and citynetworkid = 4219 
   	 order by date DESC
   	
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 12:17:13.013
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 569 
getrealestateadvice (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 100
and allreports.networkid = 100
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 100
and allreports.networkid = 100
 and allreports.citynetworkid2 =  4219
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 @ 12:17:13.013
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 100
and allreports.networkid = 100
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=10ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 100
and allreports.networkid = 100
 and allreports.citynetworkid2 =  4219
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=10ms, Records=2) in /home/www/html/expatguide.cfm @ 12:17:13.013
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 100
and allreports.networkid = 100
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=13ms, Records=2) in /home/www/html/expatguide.cfm @ 12:17:13.013
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 100
and allreports.networkid = 100
 and allreports.citynetworkid2 =  4219
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 @ 12:17:13.013
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 @ 12:17:13.013
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 = 76836
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 76836 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 12:17:13.013
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 76836
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 76836
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 12:17:13.013
	SELECT summary
	FROM answers
	WHERE answers.answerid = '76836'
getheading (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '76836'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=11ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 93549
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=11ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 93549
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 93549
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 93549
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=2ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 93549
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 12:17:13.013
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 76836 
getphoto (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 12:17:13.013
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 76836 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 12:17:13.013
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '100'
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 12:17:13.013
	SELECT *
	FROM markers
	WHERE answerid = '76836'
	and lat <> ''
	and lng <> ''
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 12:17:13.013
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 569 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 12:17:13.013
	Select *
	From Networks
	Where networkID = 100 
checkrptarticles (Datasource=reports, Time=6ms, Records=0) in /home/www/html/navcontentbox.cfm @ 12:17:13.013
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-14"
     
         and rptarticlenetworks.networkid = 100 
    ORDER by rptarticles.rptarticleID desc
    
gettaxgeneral2 (Datasource=expert, Time=7ms, Records=1) in /home/www/html/navcontentbox.cfm @ 12:17:13.013
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 100 
	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 desc
    
checkretirefeature (Datasource=expert, Time=9ms, Records=0) in /home/www/html/navcontentbox.cfm @ 12:17:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 100 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=7ms, Records=0) in /home/www/html/navcontentbox.cfm @ 12:17:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 100 
          and date > '2013-04-01'
		order by date 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=100&citynetworkid=4219
REMOTE_ADDR=172.69.63.227
REMOTE_HOST=172.69.63.227
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=31881475
cftoken=88075225
sessionid=IBEXPATEXCHANGE.COM_31881475_88075225
urltoken=CFID=31881475&CFTOKEN=88075225
URL Parameters:
citynetworkid=4219
networkid=100
Debug Rendering Time: 20 ms