Home Qatar Forum Qatar Guide Qatar Resources Real Estate Healthcare in Qatar
Qatar
Resources
City Guides
JoinSign In
AGS Worldwide Movers

Expat Guide to Living in Doha

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

5 Tips For Living in Doha, Qatar

Expats in Doha live among a very large expatriate population. For first time expats in Doha, it can be challenging to adjust, while more experienced expats say the city and the country of Qatar is a manageable adjustment.

Expat Healthcare & Health Insurance

Expat Healthcare & Health Insurance in Doha

An expat provides basic information and thoughts about the health care system in Doha, Qatar, especially the National Health Care System.

Culture Shock in Doha, Qatar

Learn what it takes to manage the culture shock experienced when moving to Doha, Qatar. What are some of the contradictions you can expect to find there?

More Culture Shock Reports for Doha

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

More Living in Doha Reports

What are people's priorities in Doha - work? family? socializing? What are the best ways to meet other expats? Are people accepting of racial, cultural and religious differences? Below are some of the responses from expats in Doha:
Submit a Living Overseas Report

Moving Overseas Report

What should you take with you when you move to Doha? What should you leave behind? What type of housing and neighborhoods are typical for expats in Doha? Help others moving to Doha by filling out our Moving Overseas Report.

Submit a Moving Overseas Report

Reviews of Schools in Doha

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

Dream vs. Reality of Living in Doha Reports

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

Overseas Retirement Report

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 Doha by filling out our Overseas Retirement report.

Submit a Retire Abroad Report

Having a Baby in Doha Reports

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

Working Abroad Report

What's it like to find a job in Doha? How difficult was it to obtain a work permit? What types are jobs are typical for expats in Doha? Help others following in your footsteps by filling out our Working Abroad Report.

Submit a Working Abroad Report
Cigna Expat Health InsuranceExpatriate Health Insurance

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

Culture-Shock-in-DohaAn Expat Talks about Culture Shock & Living in Doha, Qatar

Learn what it takes to manage the culture shock experienced when moving to Doha, Qatar. What are some of the contradictions you can expect to find there?

Learn what it takes to manage the culture shock experienced when moving to Doha, Qatar. What are some of the contradictions you can expect to find there?...

10-Tips-for-Living-in-Qatar10 Tips for Living in Qatar

Expats in Qatar share their tips for living in Qatar. From school wait lists to life for single expat women, expats open up about the challenges and rewards of life in Qatar.

Expats in Qatar share their tips for living in Qatar. From school wait lists to life for single expat women, expats open up about the challenges and rewards of life in Qatar....

5-Tips-For-Living-in-Doha,-Qatar5 Tips For Living in Doha, Qatar

Expats in Doha live among a very large expatriate population. For first time expats in Doha, it can be challenging to adjust, while more experienced expats say the city and the country of Qatar is a manageable adjustment.

Expats in Doha live among a very large expatriate population. For first time expats in Doha, it can be challenging to adjust, while more experienced expats say the city and the country of Qatar is a ...

Qatar 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 13-Jul-20 07:50 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
228 ms 228 ms 1 top level /home/www/html/expatguide.cfm
23 ms 23 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
22 ms 22 ms 1 /home/www/html/navcontentbox.cfm
22 ms 22 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/Application.cfm
4 ms 4 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/boolsearch.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/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 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 13 /home/www/html/rewritecityname.cfm
0 ms 0 ms 13 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 13 /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
234 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 @ 19:50:41.041
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 19:50:41.041
      	  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 @ 19:50:41.041
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 19:50:41.041
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 94 
getcities (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 19:50:41.041
	Select *
	From citynetworks
	Where networkID = 94
	and status <> 'hold'
	ORDER by city
getcity (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 19:50:41.041
	Select *
	From citynetworks
	Where citynetworkid = 4207 
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 19:50:41.041
  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 @ 19:50:41.041
	Select *
	From Networks
	Where networkID = 94 
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 19:50:41.041
	Select *
	From countryphotos
	Where networkID = 94
	and citynetworkid = 4207 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 19:50:41.041
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.227'
and logtime > "2020-04-13"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 19:50:41.041
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.227'
and logtime > "2020-07-13 00:00:00.000"
and logtime < "2020-07-13 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:50:41.041
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.227'
and logtime > "2020-07-06"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 19:50:41.041
	SELECT *
	From contentcountcountry
	Where networkid = 94 
gettopbanner (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 19:50:41.041
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-12"
    and fromDate < "2020-07-13"
    and bannerPlacement.networkid = '94'
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 19:50:41.041
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
	Select *
	From citynetworks 
	Where citynetworkid = 4207 
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 19:50:41.041
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement, articlecityplace 
 	Where hitopic <> ''
 	and articlePlacement.networkID = 94 
 	and articlecityplace.citynetworkid = 4207
    AND articlecityplace.articleID = articles.articleID
	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 summary <> ''
    and publishdate < "2020-07-13"
    ORDER by articles.articleID desc
gettaxgeneral (Datasource=expert, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%Doha%') OR (author LIKE '%Doha%') OR (hitopic LIKE '%Doha%') OR (hidescript LIKE '%Doha%')))
	and articlePlacement.networkID = 94 
	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 summary <> ''
    and author <> 'Expat Exchange Member'
   and author <> 'ExpatExchange Member'
      and author <> 'ExpatExchange.com Member'
    and publishdate < "2020-07-13"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Qatar' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 94 
         and citynetworkid = 4207 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 94 
         and citynetworkid = 4207 
         and city <> ''
         
   	 order by date DESC
   	
checkparenting (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 94 
         and citynetworkid = 4207 
         and city <> ''
         
   	 order by date DESC
   	
checkdreamfeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 94 
         and citynetworkid = 4207 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 94 
         and citynetworkid = 4207 
         and city <> ''
         
   	 order by date DESC
   	
checkculturefeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 94 
         and citynetworkid = 4207 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=4) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 94 
         and citynetworkid = 4207 
         and city <> ''
         
   	 order by date DESC
   	
checkmovingfeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 94 
         and citynetworkid = 4207 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 94 
         and citynetworkid = 4207 
   	 order by date DESC
   	
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 94 
         and citynetworkid = 4207 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 94 
         and citynetworkid = 4207 
   	 order by date DESC
   	
checkbaby (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 94 
         and citynetworkid = 4207 
   	 order by date DESC
   	
checkwork (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 94 
         and citynetworkid = 4207 
   	 order by date DESC
   	
checkschool (Datasource=expert, Time=5ms, Records=4) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 94 
         and citynetworkid = 4207 
   	 order by date DESC
   	
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 70519 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 26423 
getrealestateadvice (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 19:50:41.041
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 94
and allreports.networkid = 94
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/expatguide.cfm @ 19:50:41.041
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 94
and allreports.networkid = 94
 and allreports.citynetworkid2 =  4207
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 19:50:41.041
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 94
and allreports.networkid = 94
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 19:50:41.041
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 94
and allreports.networkid = 94
 and allreports.citynetworkid2 =  4207
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 94
and allreports.networkid = 94
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 94
and allreports.networkid = 94
 and allreports.citynetworkid2 =  4207
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
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 = 7 
getanswerstext (Datasource=tipripper, Time=4ms, Records=4) in /home/www/html/expatguide.cfm @ 19:50:41.041
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 = 78382
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 78382 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 78382
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 78382
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
	SELECT summary
	FROM answers
	WHERE answers.answerid = '78382'
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '78382'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 19:50:41.041
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 169395
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 19:50:41.041
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 169395
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 19:50:41.041
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 169395
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 19:50:41.041
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 169395
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 19:50:41.041
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 169395
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 78382 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '94'
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 19:50:41.041
	SELECT *
	FROM markers
	WHERE answerid = '78382'
	and lat <> ''
	and lng <> ''
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 70519 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 26423 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 328 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 27905 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 19:50:41.041
	Select *
	From Networks
	Where networkID = 94 
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 26224
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25423
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24981
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 19:50:41.041
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 11530
				AND answerstext.qid = 82
					
checkculturefeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 19:50:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 94 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 19:50:41.041
		Select summary, hiimg 
		FROM answers
         where answerid = 70519
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 19:50:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 94 
        and date > '2013-04-01'
		order by date DESC
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentbox.cfm @ 19:50:41.041
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 94 
	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-13"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=4ms, Records=0) in /home/www/html/navcontentbox.cfm @ 19:50:41.041
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-13"
     
         and rptarticlenetworks.networkid = 94 
    ORDER by rptarticles.rptarticleID asc   
    


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=94&citynetworkid=4207
REMOTE_ADDR=172.69.63.227
REMOTE_HOST=172.69.63.227
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=31841597
cftoken=30080118
sessionid=IBEXPATEXCHANGE.COM_31841597_30080118
urltoken=CFID=31841597&CFTOKEN=30080118
URL Parameters:
citynetworkid=4207
networkid=94
Debug Rendering Time: 15 ms