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

Luxembourg: Expat Blogs & Websites

Submit Your Blog to our Directory (it's free)

A bit of Lux

A seaoned British expats take on moving to and living in Luxembourg

More Info

A German Teacher In Luxembourg

My diary as a German Teacher in Luxembourg - in easy German

More Info

Expat Mum in Luxembourg

Expat mum of two little ones writing about everything related to our experience living in Luxembourg as expats, from local info to schools, from supermarkets to restaurants…

More Info

The Gluten Free Cupboard

An expat's odyssey to thrive with food allergies in Luxembourg and beyond.

More Info

Expat-Luxembourg10 Tips for Living in Luxembourg

How many languages do they speak in Luxembourg? How are the international schools in Luxembourg? Is it as expensive in Luxembourg as everyone says? In our article, expats answer these questions and many more.

How many languages do they speak in Luxembourg? How are the international schools in Luxembourg? Is it as expensive in Luxembourg as everyone says? In our article, expats answer these questions and...

Luxembourg 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 /rgblogscountry.cfm
Time Stamp 03-Jul-20 10:17 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.169
Host Name 172.69.63.169


Execution Time

Total Time Avg Time Count Template
69 ms 69 ms 1 top level /home/www/html/rgblogscountry.cfm
22 ms 22 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
21 ms 21 ms 1 /home/www/html/navcontentbox.cfm
21 ms 21 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/navtop_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/Application.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.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 1 /home/www/html/rewritearticle.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
76 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 @ 22:17:48.048
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 22:17:48.048
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getcatname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rgblogscountry.cfm @ 22:17:48.048
	Select *
	From Categories
	Where categoryid = 84 
getNets (Datasource=expert, Time=1ms, Records=153) in /home/www/html/rgblogscountry.cfm @ 22:17:48.048
		Select DISTINCT Networks.networkname, Networks.id, Networks.networkid as nets,  Networks.networktype, Networks.isCity
		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	
getpremium (Datasource=expert, Time=16ms, Records=0) in /home/www/html/rgblogscountry.cfm @ 22:17:48.048
	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.description, Resources.homepage
    From Resources, resourcePlacement, resourceCats
    WHERE resourceCats.resourceID = Resources.resourceID 
    
    AND ((resourceCats.categoryID = 84) or (resourceCats.categoryID = 85))
    
	AND ((Resources.type = 'premium') or (Resources.type = 'supaff'))
    and todate > {ts '2020-07-02 22:17:48'}
    and fromdate <{ts '2020-07-03 22:17:48'}
	AND resourcePlacement.networkID = '159'
	AND resourcePlacement.resourceID = Resources.resourceID
	Order by Resources.resourcename
getaffiliates (Datasource=expert, Time=13ms, Records=0) in /home/www/html/rgblogscountry.cfm @ 22:17:48.048
	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.description, Resources.homepage
    From Resources, resourcePlacement, resourceCats
    WHERE resourceCats.resourceID = Resources.resourceID 
    
    AND ((resourceCats.categoryID = 84) or (resourceCats.categoryID = 85))
    
	and Resources.type  ='affiliate'
	AND resourcePlacement.networkID = '159'
	AND resourcePlacement.resourceID = Resources.resourceID
	Order by Resources.resourcename
getfreecountry (Datasource=expert, Time=4ms, Records=4) in /home/www/html/rgblogscountry.cfm @ 22:17:48.048
	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.description, Resources.homepage
    From Resources, resourcePlacement, resourceCats
    WHERE resourceCats.resourceID = Resources.resourceID 
    
    AND ((resourceCats.categoryID = 84) or (resourceCats.categoryID = 85))
    
	AND resourceCats.resourceID = Resources.resourceID 
	and Resources.type  ='free'
	and Resources.paid <> 'd' 
	AND resourcePlacement.networkID = '73'
	AND resourcePlacement.resourceID = Resources.resourceID
	Order by Resources.resourcename
UpdateImpressions (Datasource=expert, Time=2ms, Records=1) in /home/www/html/rgblogscountry.cfm @ 22:17:48.048
  UPDATE Categories
  SET rgallimpressions = rgallimpressions + 1
  Where categoryid = 84 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:17:48.048
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 22:17:48.048
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 73 
getcities (Datasource=expert, Time=0ms, Records=2) in /home/www/html/navmeta_rdesign4.cfm @ 22:17:48.048
	Select *
	From citynetworks
	Where networkID = 73
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=1ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:17:48.048
  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 @ 22:17:48.048
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.169'
and logtime > "2020-04-03"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 22:17:48.048
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.169'
and logtime > "2020-07-03 00:00:00.000"
and logtime < "2020-07-03 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 @ 22:17:48.048
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.169'
and logtime > "2020-06-26"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:17:48.048
	SELECT *
	From contentcountcountry
	Where networkid = 73 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 22:17:48.048
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-02"
    and fromDate < "2020-07-03"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 22:17:48.048
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
checkrptarticles (Datasource=reports, Time=4ms, Records=0) in /home/www/html/navcontentbox.cfm @ 22:17:48.048
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-03"
     
         and rptarticlenetworks.networkid = 73 
    ORDER by rptarticles.rptarticleID desc
    
gettaxgeneral2 (Datasource=expert, Time=4ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:17:48.048
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 73 
	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-03"

    ORDER by articles.articleID desc
    
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 22:17:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 73 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 22:17:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 73 
          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/rgblogscountry.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/rgblogscountry.cfm
QUERY_STRING=categoryid=84&networkid=73
REMOTE_ADDR=172.69.63.169
REMOTE_HOST=172.69.63.169
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rgblogscountry.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=30983667
cftoken=61237563
sessionid=IBEXPATEXCHANGE.COM_30983667_61237563
urltoken=CFID=30983667&CFTOKEN=61237563
URL Parameters:
categoryid=84
networkid=73
Debug Rendering Time: 11 ms