Home Saudi Arabia Forum Saudi Arabia Guide Moving to Saudi Arabia Real Estate Healthcare in Saudi Arabia
Saudi Arabia
Resources
City Guides
JoinSign In

Moving to Saudi Arabia > Riyadh >

An Expat Talks about Moving to Riyadh, Saudi Arabia

What is the name of the city or town that you are reporting on?

Riyadh

Name three things that you wish you had brought and three you wish you had left at home.

Three things I wish I brought: more music on my computer, a large jar of vegemite and rexona men's deoderant.

Three things to leave: wireless router, batteries, and personal care products

What advice would you give someone preparing to move to your area about the actual move, choosing a neighborhood and finding a home?

Be very sure of what your getting into. Ask questions from as many different sources not just the employment agencies, they just want their money and paint a very rosie picture to what the reality is...

What type of housing do you live in? Is this typical for most expats in your area?

4 bedroom villa with three other expats. The villa is quite old, poorly furnished, very cold in the winter, power and electrics can be dodgy, circa 1970-80's fixtures. Cheap and nasty kitchen supplies.

How did you choose your neighborhood and find your home or apartment?

It was chosen by mt employer

Expats living in Saudi Arabia interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA. Get a Quote

Expats living in Saudi Arabia interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA.

Are your housing costs higher or lower than they were in your home country? What is the average cost of housing there?

My housing costs are provided by my employer

Cigna Expat Health InsuranceExpatriate Health Insurance

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

More about Riyadh

Guide to Living in Riyadh

Guide to Living in Riyadh

Expats living in Riyadh face a number of adjustments. Women have to learn to wear an abaya in public and are not allowed drive. Western compounds often enable expat families to relax and live like they do at home. In this article, expats offer tips for newcomers to Riyadh.

Healthcare in Saudi Arabia

Healthcare in Saudi Arabia

Information about healthcare, expat health insurance and hospitals in Saudi Arabia.

Expat Healthcare & Health Insurance

Expat Healthcare & Health Insurance in Riyadh

An expat in Riyadh recommends returning to the US or Europe for medical treatment should the need arise. She found that medical care, even at the top hospital in Riyadh, was substandard.

Culture Shock in Riyadh

A woman from New Zealand accepted a job in a hospital in Riyadh. Although the hospital and job was English-speaking, she enrolled in Arabic classes at a university. She found the culture and treatment of women extremely challenge at times, but knew what she was getting into when she accepted the job.

Join our Saudi Arabia Expat Forum

Visit our Saudi Arabia Forum and talk with other expats who can offer you insight and tips about living in Riyadh, Saudi Arabia.

More about Saudi Arabia

Moving-to-Saudi-ArabiaMoving to Saudi Arabia

Expats who want to move to the Saudi Arabia should fully explore what it means to move and live there. Read a lot of comments from people who live in Saudi Arabia, and have for a number of years.

Cigna International Health Insurance

Write a Comment about this Expat Report

Sign In to post a comment.
addacomment

Comments about this Report

guest
Feb 11, 2011 07:27

I am going with a reputable agent ( I thnk ) from London and am only worried about the standard of accom which he said was nice ... Can you advise, please ...?

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Guide to Living in RiyadhGuide to Living in Riyadh

Expats living in Riyadh face a number of adjustments. Women have to learn to wear an abaya in public and are not allowed drive. Western compounds often enable expat families to relax and live like they do at home. In this article, expats offer tips for newcomers to Riyadh.

Healthcare in Saudi ArabiaHealthcare in Saudi Arabia

Information about healthcare and hospitals in Saudi Arabia.

Restaurants in RiyadhRestaurants in Riyadh

Support your favorite restaurants in Riyadh as they recover from the pandemic. Submit a free listing for them on Expat Exchange to help spread the word about them to the expat community.

Expat Healthcare & Health Insurance Expat Healthcare & Health Insurance in Riyadh

An expat in Riyadh recommends returning to the US or Europe for medical treatment should the need arise. She found that medical care, even at the top hospital in Riyadh, was substandard.

Culture Shock in Riyadh

A woman from New Zealand accepted a job in a hospital in Riyadh. Although the hospital and job was English-speaking, she enrolled in Arabic classes at a university. She found the culture and treatment of women extremely challenge at times, but knew what she was getting into when she accepted the job.

Moving-to-Saudi-ArabiaMoving to Saudi Arabia

Expats who want to move to the Saudi Arabia should fully explore what it means to move and live there. Read a lot of comments from people who live in Saudi Arabia, and have for a number of years.

Saudi Arabia 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 /rspnet.cfm
Time Stamp 04-Jul-20 07:23 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.108
Host Name 162.158.78.108


Execution Time

Total Time Avg Time Count Template
106 ms 106 ms 1 top level /home/www/html/rspnet.cfm
41 ms 41 ms 1 /home/www/html/navcontentboxcityrptsmobile.cfm
24 ms 24 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
22 ms 22 ms 1 /home/www/html/navcontentboxcitypc.cfm
22 ms 22 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
10 ms 10 ms 1 /home/www/html/commentsnew_rdesign4.cfm
8 ms 8 ms 1 /home/www/html/navtop_ctygd2.cfm
7 ms 7 ms 1 /home/www/html/rspnet_ctygd_readnext.cfm
6 ms 6 ms 1 /home/www/html/navbottomad_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
3 ms 3 ms 1 /home/www/html/navmpu_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/breadcrumb_ctygd.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.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/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 1 /home/www/html/navlikeandmore_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereport.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/datasources.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
112 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:23:47.047
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 07:23:47.047
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getreportresponses (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rspnet.cfm @ 07:23:47.047
SELECT  networkname as ctry, city, networkid, rid, networkname, answerid, citynetworkid
FROM allreports
WHERE rid = 63
AND networkid = 97 
AND 19986 = answerid

GROUP BY answerid
ORDER by city
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 07:23:47.047
	Select *
	From allreports, citynetworks 
	Where allreports.answerid = 19986
	and allreports.citynetworkid = citynetworks.citynetworkid
getquestions (Datasource=reports, Time=6ms, Records=6) in /home/www/html/rspnet.cfm @ 07:23:47.047
SELECT DISTINCT questions.qid, answers.answerid, questions.question, responsequestions.qid, answerstext.qid, answerstext.answer as answer, answerstext.reviewed, answerstext.score, answers.rid, answers.reviewed, responses.intro, responses.responsename, responsequestions.listorder, answers.userid, answers.date
FROM responsequestions, questions, answers, responses, answerstext
WHERE answerstext.qid = questions.qid

AND 19986 = answerstext.answerid
 
AND answerstext.score > 1
AND answerstext.answer <> ''

AND answers.answerid = 19986 
AND answers.reviewed = 'y'
AND questions.qid = responsequestions.qid
AND responses.responseid = responsequestions.responseid
AND answers.rid = responses.rid
ORDER BY responsequestions.listorder ASC
getphotos (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rspnet.cfm @ 07:23:47.047
SELECT DISTINCT img, photocaption, summary, hpimg, fbimg, twimg
FROM answers 
WHERE answers.answerid = 19986 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 07:23:47.047
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 07:23:47.047
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 97 
getcities (Datasource=expert, Time=0ms, Records=6) in /home/www/html/navmeta_rdesign4.cfm @ 07:23:47.047
	Select *
	From citynetworks
	Where networkID = 97
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 07:23:47.047
  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
GetMessages (Datasource=forum, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 07:23:47.047
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 19986 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
getalternatesummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 07:23:47.047
				SELECT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 19986
				AND answerstext.qid = 91 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 07:23:47.047
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
and logtime > "2020-04-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_ctygd2.cfm @ 07:23:47.047
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
and logtime > "2020-07-04 00:00:00.000"
and logtime < "2020-07-04 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_ctygd2.cfm @ 07:23:47.047
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
and logtime > "2020-06-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 07:23:47.047
	SELECT *
	From contentcountcountry
	Where networkid = 97 
citycontentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 07:23:47.047
	SELECT *
	From contentcountcity
	Where citynetworkid = 4216 
getarticlesection (Datasource=expert, Time=0ms, Records=103) in /home/www/html/breadcrumb_ctygd.cfm @ 07:23:47.047
SELECT *
FROM articleCategories
 
WHERE section = 1
checkcitynetwork (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 07:23:47.047
		Select *
		FROM allreports, citynetworks
         where answerid = 19986
         and citynetworks.citynetworkid = allreports.citynetworkid
         and citynetworks.status = 'live'
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 07:23:47.047
SELECT DISTINCT img, photocaption, summary, hpimg, twimg
FROM answers 
WHERE answers.answerid = 19986 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:23:47.047
SELECT *
FROM natadoptions 
WHERE 'moveheader' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:23:47.047
	Select *
	From Networks
	Where networkid = 97 
getnatadtype (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:23:47.047
SELECT *
FROM natadoptions 
WHERE natadtypeid = 6 
getnatadbottom (Datasource=expert, Time=0ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 07:23:47.047
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 6
and natadPlacement.networkID = 97
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-07-03"
and headerparagraphstart < "2020-07-04"
and headerparagraphstatus = 'live'

and (headerparagraphweight = 'medium' or headerparagraphweight = 'high')
getnatadbottom (Datasource=expert, Time=1ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 07:23:47.047
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 6
and natadPlacement.networkID = 97
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-07-03"
and headerparagraphstart < "2020-07-04"
and headerparagraphstatus = 'live'
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:23:47.047
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:23:47.047
	Select *
	From Networks
	Where networkid = 97 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:23:47.047
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:23:47.047
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 97
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-03"
and natsentencestart < "2020-07-04"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 07:23:47.047
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articleCategories, articlecityplace
	Where hitopic <> ''
	and hidescript <> ''
    and type = '3'
   and articlecityplace.citynetworkid = 4216
	and articlecityplace.articleid = articles.articleID
     and articleCategories.articleID = articles.articleID
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = 0
    and cityintro = 'n'
    and summary <> ''
    
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-04" 
    ORDER by articles.articleID desc  
getguidesummary (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 07:23:47.047
	Select summary, hpimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4216
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
gethealthsummary (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 07:23:47.047
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 97 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
gethealthcare (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 07:23:47.047
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 97
and allreports.networkid = 97
 and allreports.citynetworkid2 =  4216
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 07:23:47.047
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=5) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 07:23:47.047
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 = 79646
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 79646 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 07:23:47.047
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79646'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 07:23:47.047
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79646'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 07:23:47.047
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 79646 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 07:23:47.047
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '97'
checkculturefeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 07:23:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
            
         and allreports.answerid <> 19986         
         and networkid = 97
          and citynetworkid = 4216
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 07:23:47.047
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 70325 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 07:23:47.047
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 25547 
gettaxgeneral (Datasource=expert, Time=5ms, Records=1) in /home/www/html/rspnet_ctygd_readnext.cfm @ 07:23:47.047
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 97 
	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 keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and publishdate < "2020-07-04"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID desc
    
gettopbanner (Datasource=expert, Time=2ms, Records=0) in /home/www/html/navbottomad_rdesign5.cfm @ 07:23:47.047
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-07-03"
    and fromDate < "2020-07-04"
        and banners.promised = ''
    and banners.type <> 'swf'
gettopbanner (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 07:23:47.047
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-07-03"
    and fromDate < "2020-07-04"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 07:23:47.047
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 07:23:47.047
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-07-03 07:23:47'}
    and fromDate <{ts '2020-07-04 07:23:47'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 07:23:47.047
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 07:23:47.047
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 19986 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 07:23:47.047
  SELECT *
  FROM users
  WHERE userid = 2 
getguidesummary (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 07:23:47.047
	Select summary, hiimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4216
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
gethealthsummary (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 07:23:47.047
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 97 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
gethealthcare (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 07:23:47.047
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 97
and allreports.networkid = 97
 and allreports.citynetworkid2 =  4216
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 07:23:47.047
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=5) in /home/www/html/navcontentboxcitypc.cfm @ 07:23:47.047
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 = 79646
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 79646 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 07:23:47.047
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79646'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 07:23:47.047
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79646'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 07:23:47.047
	SELECT DISTINCT hiimg as photo
	FROM answers
	WHERE answerid = 79646 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 07:23:47.047
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '97'
checkculturefeature (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 07:23:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
            
         and allreports.answerid <> 19986         
         and networkid = 97
          and citynetworkid = 4216
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 07:23:47.047
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 70325 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 07:23:47.047
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 25547 


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/rspnet.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/rspnet.cfm
QUERY_STRING=rid=63&answerid=19986&networkid=97&start=19986
REMOTE_ADDR=162.158.78.108
REMOTE_HOST=162.158.78.108
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rspnet.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=31006949
cftoken=27793657
sessionid=IBEXPATEXCHANGE.COM_31006949_27793657
urltoken=CFID=31006949&CFTOKEN=27793657
URL Parameters:
answerid=19986
networkid=97
rid=63
start=19986
Debug Rendering Time: 12 ms