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

Expat Resource Guide

Expat Health Services

Expat Health Insurance

Expatriate Health Insurance, Expatriate Medical Insurance, Private Medical Insurance

Medical Evacuation

Medical Evacuation, Emergency Medical Transport, Medical Repatriation

Expat Counseling

Psychotherapists for Expats, Therapists for Expats, Expat Counseling, Marriage Counseling

Moving to Germany

Overseas Shipping & International Moving

Shippers, International Movers

Auto Shipping & Auto

International Car Shipping, Auto Transport Companies, Car Transporter & Overseas Car Shipping

Car Insurance for Expats in Germany

Specialized international car insurance plans for expats in Germany

Pet Shipping & Pet Travel

Pet Transport, Overseas Pet Shipping, Pet Care Abroad

Relocation Companies in Germany

Help With All of Your Relocation Needs

Mail Forwarding & Mail

Mail Forwarding Services, Postal Mail Forwarding, Mail Services for Expats

Expat Tax & Finance

Expat Tax

Expat Tax Preparation, Expat Tax Professionals

Life Insurance

Expat Life Insurance

Expat Banking Germany

Expat Banking, International Personal Banking & Offshore Banking

Expat Finance

QDROPS, Expat Finance & Expat Mortgages

Currency Exchange

Foreign Currency Exchange, Currency Exchange Rates, Currency Exchange Converter

Visa & Legal Services

Visa & Immigration Services in Germany

Visa Services, Immigration Services, Immigration Attorneys

Germany Real Estate

Real Estate Agencies & Property Agents in Germany

Find a real estate agent in Germany

Furnished Apartments

Short-term Rental, Extended Stay, Furnished Rental

Job & Career Related Services

Jobs in Germany

Overseas Jobs, Expat Jobs, Jobs Abroad

Language Training & Cross-Cultural

Language Immersion Training, Language Training Online, Cross-Cultural Traning

Miscellaneous

Golf, Sports & Recreation

Golf Clubs, Sports & Recreation

Travel Insurance

International Travel Insurance

Cigna Expat Health InsuranceExpatriate Health Insurance

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

12-Expats-Talk-about-What-its-Like-Living-in-Germany12 Expats Talk about What it's Like Living in Germany

Expats talk about living in Germany. From meeting people to adjusting to the German culture, expats offer a glimpse of life in Germany.
Expats talk about living in Germany. From meeting people to adjusting to the German culture, expats offer a glimpse of life in Germany. ...

Living-in-GermanyLiving in Germany

This article highlights some of the tremendous contributions that expats in Germany have made on Expat Exchange. We thank all of you who have gotten involved in the Germany forum and/or posted a report about living in Germany.

This article highlights some of the tremendous contributions that expats in Germany have made on Expat Exchange. We thank all of you who have gotten involved in the Germany forum and/or posted a repo...

Expat-Germany10 Tips for Living in Germany

Should you learn German before you move to Germany? What type of apartments are typical in Germany? Expats offer advice and share 10 tips for living in Germany.

Should you learn German before you move to Germany? What type of apartments are typical in Germany? Expats offer advice and share 10 tips for living in Germany....

Expats-in-Germany5 Tips for Living in Frankfurt

Expats often move to Frankfurt for jobs in finance and IT. Frankfurt is continental Europe's largest financial center and has a population of approximately 2.5 million in the city and surrounding urban area. Towns in the Taunus area north of Frankfurt and Wiesbaden and Mainz to the west are popular among expats. There are many international and bi-lingual schools to choose from and lots of expat clubs in the Frankfurt area.

Expats often move to Frankfurt for jobs in finance and IT. Frankfurt is continental Europe's largest financial center and has a population of approximately 2.5 million in the city and surrounding urb...

Retirement-In-Eifel-An Expat Shares What it's Like Retiring in Eifel , Germany

A couple from the UK discusses their decision to move abroad to reduce living costs and travel more. For now, they are living in Eifel, but the locals are not welcoming and they are considering moving again.

A couple from the UK discusses their decision to move abroad to reduce living costs and travel more. For now, they are living in Eifel, but the locals are not welcoming and they are considering movin...

Moving-To-MunichAn Expat Talks about Moving to Munich, Germany

An expat living in Munich offers advice on moving to the southern German city. Great advice on getting a drivers license, renting a flat, and more.

An expat living in Munich offers advice on moving to the southern German city. Great advice on getting a drivers license, renting a flat, and more....

Germany 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 /rgtop.cfm
Time Stamp 14-Jul-20 03:52 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
37 ms 37 ms 1 top level /home/www/html/rgtop.cfm
28 ms 28 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
26 ms 26 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
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
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/rewritearticlefirsttitle.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 2 /home/www/html/navinjection.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 1 /home/www/html/rewritenetworkname.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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
43 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 @ 15:52:48.048
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 15:52:48.048
      	  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 @ 15:52: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 @ 15:52:48.048
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 3 
getcities (Datasource=expert, Time=1ms, Records=13) in /home/www/html/navmeta_rdesign4.cfm @ 15:52:48.048
	Select *
	From citynetworks
	Where networkID = 3
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 15:52: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 @ 15:52:48.048
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
and logtime > "2020-04-14"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 15:52:48.048
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
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 @ 15:52:48.048
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
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 @ 15:52:48.048
	SELECT *
	From contentcountcountry
	Where networkid = 3 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 15:52:49.049
	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=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 15:52:49.049
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 15:52:49.049
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-14"
     
         and rptarticlenetworks.networkid = 3 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 15:52:49.049
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 4
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 15:52:49.049
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 3 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 15:52:49.049
SELECT  hiimg
FROM rptarticles
where rptarticleID = 4
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 15:52:49.049
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 3 
	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 asc   
    
checkretirefeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 15:52:49.049
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 3 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 15:52:49.049
		Select summary, hiimg 
		FROM answers
         where answerid = 46590
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 15:52:49.049
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 3 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 15:52:49.049
		Select summary, hiimg 
		FROM answers
         where answerid = 74522
         and summary <> ''


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/rgtop.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/rgtop.cfm
QUERY_STRING=networkID=3
REMOTE_ADDR=172.68.65.192
REMOTE_HOST=172.68.65.192
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rgtop.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=31893209
cftoken=51218014
sessionid=IBEXPATEXCHANGE.COM_31893209_51218014
urltoken=CFID=31893209&CFTOKEN=51218014
URL Parameters:
networkID=3
Debug Rendering Time: 12 ms