Home Botswana Forum Botswana Guide Botswana Resources Real Estate Healthcare in Botswana
Botswana
Resources
JoinSign In
AGS Worldwide Movers

Botswana Daily Update

Our Botswana Daily Update is delivered Tuesdays through Sundays. The Daily Update provides an update on related to expat life, advice from members and experts in Botswana. Sign up today!

To subscribe to Expat Exchange's Daily Update Botswana, please fill out the brief form below. You may unsubscribe at any time by clicking on the Unsubscribe Link included at the bottom of every issue of The Daily Update e-mail newsletter.

Email Address:

Select Version (Global or Country-Specific)

Cigna Expat Health InsuranceExpatriate Health Insurance

Get a quote for expat health insurance in Botswana 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...

Botswana 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 /expat/index.cfm
Time Stamp 10-Jul-20 07:25 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.68.65.192
Host Name 172.68.65.192


Execution Time

Total Time Avg Time Count Template
73 ms 73 ms 1 /home/www/html/expat/Application.cfm
22 ms 22 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
22 ms 22 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
22 ms 22 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
20 ms 20 ms 1 /home/www/html/navcontentbox.cfm
12 ms 12 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
8 ms 8 ms 1 /home/www/html/navtop_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/expat/daily_signup.cfm
3 ms 3 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/expat/constants.cfm
1 ms 1 ms 1 /home/www/html/expat/ibstyle.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_DesignSet.cfm
1 ms 1 ms 2 /home/www/html/navinjection.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/expat/copyright.cfm
0 ms 0 ms 1 /home/www/html/expat/datasources.cfm
0 ms 0 ms 1 /home/www/html/expat/ibkey.cfm
0 ms 0 ms 1 /home/www/html/expat/index.cfm
0 ms 0 ms 1 /home/www/html/expat/instaboard.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/rewritearticle.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
74 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GeneralSet.cfm @ 19:25:27.027
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/expat/Application.cfm @ 19:25:27.027
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 19:25:27.027
	Select *
	From Networks
	Where networkid = 23 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 19:25:27.027
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 19:25:27.027
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 23 
getcities (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmetaforums_rdesign5.cfm @ 19:25:27.027
	Select *
	From citynetworks
	Where networkID = 23
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=1ms, Records=154, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 19:25:27.027
  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/navmetaforums_rdesign5.cfm @ 19:25:27.027
	Select *
	From Networks
	Where networkID = 23 
getcountryphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmetaforums_rdesign5.cfm @ 19:25:27.027
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 23
	order by lastsent ASC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 19:25:27.027
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
and logtime > "2020-04-10"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 19:25:27.027
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
and logtime > "2020-07-10 00:00:00.000"
and logtime < "2020-07-10 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 @ 19:25:27.027
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
and logtime > "2020-07-03"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 19:25:27.027
	SELECT *
	From contentcountcountry
	Where networkid = 23 
gettopbanner (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 19:25:27.027
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-09"
    and fromDate < "2020-07-10"
    and bannerPlacement.networkid = '23'
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 19:25:27.027
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
DesignSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 19:25:27.027
  SELECT * FROM designset
  WHERE designsetid = 11 
getNets (Datasource=expert, Time=1ms, Records=153) in /home/www/html/expat/daily_signup.cfm @ 19:25:27.027
		Select DISTINCT Networks.networkname, Networks.id, Networks.networkid as nets,  Networks.networktype, Networks.isCity, Networks.networkid
		From Networks
		WHERE isCity <> "hold"
		AND networktype <> 2
		AND networktype <> 3
		AND networktype <> 4
		AND networktype <> 5
		AND networkname <> 'national'
		AND networkname <> 'Global Listing'
		AND (isCity = 'Country') 
    	ORDER by isCity, networkname	
getcountry (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expat/daily_signup.cfm @ 19:25:27.027
	Select *
	From Networks
	Where networkid = 23 
checkrptarticles (Datasource=reports, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 19:25:27.027
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-10"
     
         and rptarticlenetworks.networkid = 23 
    ORDER by rptarticles.rptarticleID desc
    
gettaxgeneral2 (Datasource=expert, Time=4ms, Records=0) in /home/www/html/navcontentbox.cfm @ 19:25:27.027
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 23 
	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-10"

    ORDER by articles.articleID desc
    
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 19:25:27.027
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 23 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 19:25:27.027
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 23 
          and date > '2013-04-01'
		order by date DESC
gettaxgeneral2 (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navcontentbox.cfm @ 19:25:27.027
	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-10"  
    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/expat/index.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/expat/index.cfm
QUERY_STRING=pr=daily_signup&networkID=23
REMOTE_ADDR=172.68.65.192
REMOTE_HOST=172.68.65.192
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expat/index.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Cookie Variables:
MS=flat
Session Variables:
cfid=31652164
cftoken=63445083
sessionid=IBEXPATEXCHANGE.COM_31652164_63445083
urltoken=CFID=31652164&CFTOKEN=63445083
URL Parameters:
networkID=23
pr=daily_signup
Debug Rendering Time: 10 ms