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

Expat Guide to Living in Kenya

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

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.

Violence in Nairobi, Kenya

A moving report on recent violence and expat life in Nairobi.

City Profile: Nairobi, Kenya

One member shares experiences living in Nairobi, Kenya. From the family-centric culture to a lively social scene, Kenya has a lot to offer in spite of its crime and social unrest.

More Culture Shock Reports for Kenya

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

More Living in Kenya Reports

What are people's priorities in Kenya - 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 Kenya:
Submit a Living Overseas Report

More Moving to Kenya Reports

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

Reviews of Schools in Kenya

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

Dream vs. Reality Report

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Kenya. If you are already living in Kenya, 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 Kenya 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 Kenya? Help other expats who are preparing to have a baby in Kenya 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 Kenya? How difficult was it to obtain a work permit? What types are jobs are typical for expats in Kenya? Help others following in your footsteps by filling out our Working Abroad Report.

Submit a Working Abroad Report
Integra Expat Health InsuranceExpatriate Health Insurance

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

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

Kenya 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 07-Jul-20 10:43 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.230
Host Name 162.158.78.230


Execution Time

Total Time Avg Time Count Template
200 ms 200 ms 1 top level /home/www/html/expatguide.cfm
22 ms 22 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
22 ms 22 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
21 ms 21 ms 1 /home/www/html/navcontentbox.cfm
9 ms 9 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 1 ms 1 /home/www/html/constants.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/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 5 /home/www/html/rewritearticle.cfm
0 ms 0 ms 13 /home/www/html/rewritecityname.cfm
0 ms 0 ms 13 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 13 /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
207 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 @ 10:43:52.052
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=4ms, Records=1) in /home/www/html/Application.cfm @ 10:43:52.052
      	  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 @ 10:43:52.052
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 10:43:52.052
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 64 
getcities (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 10:43:52.052
	Select *
	From citynetworks
	Where networkID = 64
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 10:43:52.052
  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 @ 10:43:52.052
	Select *
	From Networks
	Where networkID = 64 
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 10:43:52.052
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 64
	and guidephoto = 'yes'
	and twimg <> ''
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 10:43:52.052
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 64 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 10:43:52.052
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.230'
and logtime > "2020-04-07"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 10:43:52.052
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.230'
and logtime > "2020-07-07 00:00:00.000"
and logtime < "2020-07-07 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 @ 10:43:52.052
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.230'
and logtime > "2020-06-30"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 10:43:52.052
	SELECT *
	From contentcountcountry
	Where networkid = 64 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 10:43:52.052
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-06"
    and fromDate < "2020-07-07"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 10:43:52.052
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
gettaxgeneral (Datasource=expert, Time=7ms, Records=3) in /home/www/html/expatguide.cfm @ 10:43:52.052
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 64 
	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-07"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 10:43:52.052
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Kenya' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 64 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 64 
         and city <> ''
         
   	 order by city, date DESC
         
checkparenting (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 64 
         and city <> ''
         
   	 order by city, date DESC
         
checkdreamfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 64 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 64 
         and city <> ''
         
   	 order by city, date DESC
         
checkculturefeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 64 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 64 
         and city <> ''
         
   	 order by city, date DESC
         
checkmovingfeaturereportarticle (Datasource=reports, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '1'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-07"
     
         and rptarticlenetworks.networkid = 64 
checkmovingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 64 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 64 
   	 order by city, date DESC
         
checklivingfeaturereportarticle (Datasource=reports, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '2'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-07"
      
         and rptarticlenetworks.networkid = 64 
checklivingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 64 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 64 
   	 order by city, date DESC
         
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 64 
   	 order by city, date DESC
         
checkwork (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 64 
   	 order by city, date DESC
         
checkschool (Datasource=expert, Time=5ms, Records=8) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 64 
   	 order by city, date DESC
         
getrealestateadvice (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 10:43:52.052
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 64
and allreports.networkid = 64
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 @ 10:43:52.052
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 64
and allreports.networkid = 64
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 @ 10:43:52.052
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 64
and allreports.networkid = 64
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 @ 10:43:52.052
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 64
and allreports.networkid = 64
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=10ms, Records=0) in /home/www/html/expatguide.cfm @ 10:43:52.052
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 64
and allreports.networkid = 64
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 10:43:52.052
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 64
and allreports.networkid = 64
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 37880 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 26069 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 25549 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 24939 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 10:43:52.052
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 16488 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 10:43:52.052
	Select *
	From Networks
	Where networkID = 64 
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 10:43:52.052
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 73434
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 10:43:52.052
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 71959
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 10:43:52.052
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 68415
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 10:43:52.052
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 37017
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 10:43:52.052
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25799
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 10:43:52.052
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 10744
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 10:43:52.052
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 1367
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 10:43:52.052
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 73768
				AND answerstext.qid = 82
					
checkrptarticles (Datasource=reports, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 10:43:52.052
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-07"
     
         and rptarticlenetworks.networkid = 64 
    ORDER by rptarticles.rptarticleID desc
    
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 10:43:52.052
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 64 
	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-07"

    ORDER by articles.articleID desc
    
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 10:43:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 64 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 10:43:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 64 
          and date > '2013-04-01'
		order by date DESC
gettaxgeneral2 (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navcontentbox.cfm @ 10:43:52.052
	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-07"  
    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=64
REMOTE_ADDR=162.158.78.230
REMOTE_HOST=162.158.78.230
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=31216589
cftoken=17277016
sessionid=IBEXPATEXCHANGE.COM_31216589_17277016
urltoken=CFID=31216589&CFTOKEN=17277016
URL Parameters:
networkID=64
Debug Rendering Time: 10 ms