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

Expat Guide to Living in Germany

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

Moving to Germany

Expats in Germany share 10 things they wish they had known before moving to Germany - from the importance of learning German to residency permits to understanding the culture and more.

8 Best Places to Live in Germany

Expats love Germany for its historic towns, festivals, Christmas markets and diversity. In this article, we cover 8 of the best places to live in Germany.

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

5 Tips for Tech Jobs in Berlin

Expats in Berlin live in one of the biggest tech hubs in Europe. There are companies that range anywhere from large corporations to budding start up, and these are able to attract talent from all over the world.

5 Tips for Living in Cologne, Germany

Expats in Cologne, Germany share tips for living in Cologne from international schools to Karneval. They also discuss the shocking events of New Year's Eve 2015 and how that has impacted life in Cologne.

12 Tips for Living in Dusseldorf, Germany

12 Tips for Living in Dusseldorf, Germany

A glimpse at expat life in Dusseldorf, Germany - from international schools to cost of living in Dusseldorf, expat clubs to recreational activities.

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.

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

Culture Shock in Frankfurt, Germany

An expat in Germany talks about the living in Germany. Although he's from France, he had trouble adjusting to the German culture - the lack of politeness, thriftiness and difficulty making friendships.

Dream vs Reality of Living in Berlin, Germany

Once we settled in Berlin, we have no regrets whatsoever. It has been all we could hope for in living in Germany. The culture, the history and of course, cosmopolitan Berlin. We love our place in the city and are happy we made this move. Berlin is no longer divided and I still see the Berlin from my younger days.

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

More Culture Shock Reports for Germany

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

More Moving to Germany Reports

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

Reviews of Schools in Germany

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

Dream vs. Reality of Living in Germany Reports

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Germany. If you are already living in Germany, share how those "dreams" have been fulfilled, and how they have not. Below are some of the reports from expats in Germany:
Submit a Dream vs. Reality Report

Retiring in Germany Reports

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 Germany, by filling out our Overseas Retirement report. Below are some of the reports from expats in Germany:
Submit a Retire Abroad Report

Having a Baby in Germany Reports

How did expats choose their doctors, midwives, hospitals? What is childbirth like in Germany? Below are some of the reports from expats in Germany:
Submit a Having a Baby Abroad Report

Working in Germany Reports

What's it like to find a job in Germany? How difficult was it to obtain a work permit? What types are jobs are typical for expats in Germany? Below are some of the reports from expats in Germany:
Submit a Working Abroad Report
Additional Articles
10 Best Places in the World to Get in the Christmas Spirit

Christmas is a wonderful time of year. Here are 10 of the best places in the world to get in the Christmas spirit.

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

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.

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 report about living in Germany.

Getting the Anmeldebestätigung - Registering in Germany

If you're moving to Germany, registering at your town's Einwohnermeldeamt -- Registration Office -- within 7 days of arriving is a must. The Tapxe blog offers helpful advice.

Opening a Bank Account in Germany

Opening a bank account in Germany is not difficult as long as you have your passport and Andmeldedestätigung.

Having a Baby in Erlangen, Germany

Planning to have a baby in Germany? One member shares their experiences having a baby in Erlangen.

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 /expatguide.cfm
Time Stamp 02-Jul-20 07:54 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
422 ms 422 ms 1 /home/www/html/expatguide.cfm
27 ms 27 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
26 ms 26 ms 1 /home/www/html/navcontentbox.cfm
26 ms 26 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/navmeta_rdesign4.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 1 ms 2 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/eetr/rewriterealtorlink.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/eetr/rewritetipheading.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 14 /home/www/html/rewritearticle.cfm
0 ms 0 ms 101 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 101 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 101 /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
427 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 @ 07:54:26.026
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 07:54:26.026
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=expert, Time=1ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 07:54:26.026
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 07:54:26.026
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 3 
getcities (Datasource=expert, Time=0ms, Records=13) in /home/www/html/navmeta_rdesign4.cfm @ 07:54:26.026
	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 @ 07:54:26.026
  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 @ 07:54:26.026
	Select *
	From Networks
	Where networkID = 3 
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 07:54:26.026
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 3
	and guidephoto = 'yes'
	and twimg <> ''
getphoto (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 07:54:26.026
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 3 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 07:54:26.026
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.230'
and logtime > "2020-04-02"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 07:54:26.026
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.230'
and logtime > "2020-07-02 00:00:00.000"
and logtime < "2020-07-02 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 @ 07:54:26.026
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.230'
and logtime > "2020-06-25"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 07:54:26.026
	SELECT *
	From contentcountcountry
	Where networkid = 3 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 07:54:26.026
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-01"
    and fromDate < "2020-07-02"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 07:54:26.026
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
gettaxgeneral (Datasource=expert, Time=6ms, Records=11) in /home/www/html/expatguide.cfm @ 07:54:26.026
	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 publishdate < "2020-07-02"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Germany' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 3 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 3 
         and city <> ''
         
   	 order by city, date DESC
         
checkparenting (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 3 
         and city <> ''
         
   	 order by city, date DESC
         
checkdreamfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 3 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=3) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 3 
         and city <> ''
         
   	 order by city, date DESC
         
checkculturefeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 3 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=10) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 3 
         and city <> ''
         
   	 order by city, date DESC
         
checkmovingfeaturereportarticle (Datasource=reports, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '1'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-02"
     
         and rptarticlenetworks.networkid = 3 
checkmovingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 3 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=10) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 3 
   	 order by city, date DESC
         
checklivingfeaturereportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '2'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-02"
      
         and rptarticlenetworks.networkid = 3 
checklivingfeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 3 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=17) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 3 
   	 order by city, date DESC
         
checkbaby (Datasource=expert, Time=5ms, Records=5) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 3 
   	 order by city, date DESC
         
checkwork (Datasource=expert, Time=6ms, Records=4) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 3 
   	 order by city, date DESC
         
checkschool (Datasource=expert, Time=5ms, Records=43) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 3 
   	 order by city, date DESC
         
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 07:54:26.026
	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 @ 07:54:26.026
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 3 
getlivingphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT  hpimg
FROM rptarticles
where rptarticleID = 4
and hpimg <> ''
getrealestateadvice (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 3
and allreports.networkid = 3
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 3
and allreports.networkid = 3
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 9 
getanswerstext (Datasource=tipripper, Time=5ms, Records=12) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 79417
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 79417 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 79417
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 79417
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79417'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79417'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 26690
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 26690
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 26690
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 26690
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 26690
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 11 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 79417 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '3'
getmarker (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 07:54:26.026
	SELECT *
	FROM markers
	WHERE answerid = '79417'
	and lat <> ''
	and lng <> ''
checkstatus (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 07:54:26.026
SELECT *
FROM expertusers
WHERE userid = 26690
and startdate <{ts '2020-07-01 07:54:26'}
and enddate > {ts '2020-07-02 07:54:26'} 
getrestaurants (Datasource=tipripper, Time=10ms, Records=0) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 3
and allreports.networkid = 3
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 3
and allreports.networkid = 3
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 3
and allreports.networkid = 3
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 07:54:26.026
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 3
and allreports.networkid = 3
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74522 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 26157 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 76524 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74885 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 10995 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 9910 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 49048 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 46590 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 07:54:26.026
	Select *
	From Networks
	Where networkID = 3 
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 3142
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 23975
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 21082
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 9968
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 3114
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 1689
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 277
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=0) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 70179
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 65361
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 447
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25258
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25213
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24973
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=0) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24958
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 18175
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 784
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25330
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 26077
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 21277
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 23613
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 65185
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 65046
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 37784
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 26346
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=0) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 26307
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24255
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 11051
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 10863
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 10854
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 3928
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 76523
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 70826
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 4517
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 605
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 22566
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 15699
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 2556
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 515
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 3865
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 2676
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 831
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 2708
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 07:54:26.026
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 442
				AND answerstext.qid = 82
					
checkrptarticles (Datasource=reports, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 07:54:26.026
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-02"
     
         and rptarticlenetworks.networkid = 3 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=1, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 07:54:26.026
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 4
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 07:54:26.026
	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 @ 07:54:26.026
SELECT  hiimg
FROM rptarticles
where rptarticleID = 4
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 07:54:26.026
	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-02"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 07:54:26.026
		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 @ 07:54:26.026
		Select summary, hiimg 
		FROM answers
         where answerid = 46590
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 07:54:26.026
		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=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 07:54:26.026
		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/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=3
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=30722472
cftoken=88306865
sessionid=IBEXPATEXCHANGE.COM_30722472_88306865
urltoken=CFID=30722472&CFTOKEN=88306865
URL Parameters:
networkID=3
Debug Rendering Time: 12 ms