Cigna International Health Insurance

Alnakhla

A blog full of info about living in Yemen. You can ask questions, too.

Web Site:

Culture-Shock-in-HannoverAn Expat Talks about Culture Shock & Living in Hannover, Germany

Do you need to learn German before moving to Hannover? What are Germans like? An expat talks about living in Hannover, the cultural stereotype about German people being rude, healthcare in Germany and more.

Do you need to learn German before moving to Hannover? What are Germans like? An expat talks about living in Hannover, the cultural stereotype about German people being rude, healthcare in Germany a...

Living-in-TaguigAn Expat Discusses Living in Taguig, Philippines

An British expat talks about spending winters in Taguig, Philippines with his Filipina wife of 25 years. He does miss chatting with other English speakers and hopes to find some expat clubs in Bonifacio Global City.

An British expat talks about spending winters in Taguig, Philippines with his Filipina wife of 25 years. He does miss chatting with other English speakers and hopes to find some expat clubs in Bonifa...

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

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /rgblog.cfm
Time Stamp 15-Jul-20 02:02 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
23 ms 23 ms 1 top level /home/www/html/rgblog.cfm
11 ms 11 ms 1 /home/www/html/navtop_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/navleader_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
4 ms 4 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navcontentbox.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.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/constants.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /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
29 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 @ 14:02:19.019
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 14:02:19.019
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getresources (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rgblog.cfm @ 14:02:19.019
	SELECT *
	FROM Resources
	where resourceID = 10466 
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rgblog.cfm @ 14:02:19.019
	Select *
	From Networks
	Where networkID = 159 
getcatname (Datasource=expert, Time=4ms, Records=1) in /home/www/html/rgblog.cfm @ 14:02:19.019
	Select DISTINCT Resources.resourceID, Categories.categoryname, Categories.usermeta, Categories.titletagglobal, Categories.keywordsglobal, Categories.descripttagglobal, Categories.searchterms, Categories.descriptionglobal, Categories.usedescription, Categories.usearticles, Categories.headinglocal, Categories.categoryname2, Categories.headingglobal, Categories.titletaglocal, Categories.keywordslocal, Categories.descripttaglocal, Categories.descriptionlocal
    From Resources, Categories, resourceCats
    WHERE Categories.categoryid = resourceCats.categoryID 
	AND resourceCats.resourceID = Resources.resourceID 
	and Resources.resourceID = 10466
	ORDER by Categories.categoryID
	
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 14:02:19.019
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 14:02:19.019
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 159 
getcities (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 14:02:19.019
	Select *
	From citynetworks
	Where networkID = 159
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 14:02: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
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 14:02:19.019
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.227'
and logtime > "2020-04-15"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 14:02:19.019
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.227'
and logtime > "2020-07-15 00:00:00.000"
and logtime < "2020-07-15 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 @ 14:02:19.019
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.227'
and logtime > "2020-07-08"
and param1 = 'awdyn'
ORDER BY logtime DESC
gettopbanner (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navleader_rdesign5.cfm @ 14:02:19.019
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eebanner")
	and weight = 1
    and toDate > "2020-07-14"
    and fromDate < "2020-07-15"
gettopbanner (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 14:02:19.019
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eebanner")
    and toDate > "2020-07-14"
    and fromDate < "2020-07-15"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 14:02:19.019
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
UpdateImpressions (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rgblog.cfm @ 14:02:19.019
  UPDATE Resources
  SET impressions = impressions + 1
  WHERE resourceID = 10466 
checkculturefeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 14:02:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 14:02:19.019
		Select summary, hiimg 
		FROM answers
         where answerid = 76524
         and summary <> ''
checklivingfeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 14:02:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 14:02:19.019
		Select summary, hiimg 
		FROM answers
         where answerid = 76398
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navcontentbox.cfm @ 14:02:19.019
	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-15"
    ORDER by articles.articleID desc   
checkrptarticles (Datasource=reports, Time=0ms, Records=0, Cached Query) in /home/www/html/navcontentbox.cfm @ 14:02:19.019
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-15"
     
         and rptarticlenetworks.networkid = 159 
    ORDER by rptarticles.rptarticleID asc   
    
GetCountryList (Datasource=expert, Time=0ms, Records=96, Cached Query) in /home/www/html/navsidesbottom_rdesign5.cfm @ 14:02:19.019
  SELECT networkname, frmid, networkid, location1, location2, location3, location4, location5, shortname
  FROM mostcountries
  order by networkname


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/rgblog.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/rgblog.cfm
QUERY_STRING=resourceID=10466
REMOTE_ADDR=172.69.63.227
REMOTE_HOST=172.69.63.227
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rgblog.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=31940738
cftoken=91515234
sessionid=IBEXPATEXCHANGE.COM_31940738_91515234
urltoken=CFID=31940738&CFTOKEN=91515234
URL Parameters:
resourceID=10466
Debug Rendering Time: 11 ms