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

Expat Guide to Living in Sharjah

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

Culture Shock Report

Culture shock is part of the settling in process. Knowing the different phases of culture shock and how other expats in Sharjah handle it can be very comforting. Help others preparing to move to Sharjah by filling out our Culture Shock Report.

Submit a Culture Shock Report

Living Overseas Report

What are people's priorities in Sharjah - work? family? socializing? What are the best ways to meet other expats? Are people accepting of racial, cultural and religious differences? Help other expats and people moving to Sharjah by filling out our Living Overseas Report.

Submit a Living Overseas Report

Moving Overseas Report

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

Submit a Moving Overseas Report

Reviews of Schools in Sharjah

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

Dream vs. Reality Report

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Sharjah. If you are already living in Sharjah, share how those "dreams" have been fulfilled, and how they have not by filling out our Dream vs. Reality Report.

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

Submit a Retire Abroad Report

Having a Baby Abroad Report

How did expats choose their doctors, midwives, hospitals? What is childbirth like in Sharjah? Help other expats who are preparing to have a baby in Sharjah by filling out our Having a Baby Abroad Report.

Submit a Having a Baby Abroad Report

Working Abroad Report

What's it like to find a job in Sharjah? How difficult was it to obtain a work permit? What types are jobs are typical for expats in Sharjah? 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 UAE from our partner, Cigna Global Health.
Get a Quote

6-Expats-Talk-about-Living-in-the-UAE6 Expats Talk about Living in the UAE

6 expats talk about the expat life in the UAE and how to meet people in Dubai, Abu Dhabi and Al Ain.
6 expats talk about the expat life in the UAE and how to meet people in Dubai, Abu Dhabi and Al Ain. ...

Expats-in-Abu-Dhabi10 Tips for Living in Abu Dhabi

Expats in Abu Dhabi enjoy a unique lifestyle in the Middle East, but the requirements for moving there are very specific. Find out what these are and what it is like to live in this truly diverse city.

Expats in Abu Dhabi enjoy a unique lifestyle in the Middle East, but the requirements for moving there are very specific. Find out what these are and what it is like to live in this truly diverse cit...

Expats-in-Dubai5 Tips for Living in Dubai

Expats in Dubai will find one of the largest expat hubs in the world. With so many other people from other cultures, it's a location where just about anyone can find a comfort zone with the right frame of mind and amount of effort.

Expats in Dubai will find one of the largest expat hubs in the world. With so many other people from other cultures, it's a location where just about anyone can find a comfort zone with the right fra...

Expats-in-the-UAE7 Important Tips about Healthcare for Expats in the UAE

Expats and people moving to the UAE have lots of questions. Healthcare and health insurance are often on the list. Here are 7 tips about healthcare, health insurance in the UAE, having a baby in the UAE and more.

Expats and people moving to the UAE have lots of questions. Healthcare and health insurance are often on the list. Here are 7 tips about healthcare, health insurance in the UAE, having a baby in the ...

UAE 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 29-May-20 07:14 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.62.82
Host Name 172.69.62.82


Execution Time

Total Time Avg Time Count Template
195 ms 195 ms 1 top level /home/www/html/expatguide.cfm
26 ms 26 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
25 ms 25 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
24 ms 24 ms 1 /home/www/html/navcontentbox.cfm
9 ms 9 ms 1 /home/www/html/navtop_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/Application.cfm
4 ms 4 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /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 0 ms 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/boolsearch.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 6 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 6 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 6 /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
201 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:14:32.032
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=4ms, Records=1) in /home/www/html/Application.cfm @ 19:14:32.032
      	  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:14:32.032
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 19:14:32.032
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 112 
getcities (Datasource=expert, Time=0ms, Records=4) in /home/www/html/navmeta_rdesign4.cfm @ 19:14:32.032
	Select *
	From citynetworks
	Where networkID = 112
	and status <> 'hold'
	ORDER by city
getcity (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 19:14:32.032
	Select *
	From citynetworks
	Where citynetworkid = 5030 
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 19:14:32.032
  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:14:32.032
	Select *
	From Networks
	Where networkID = 112 
getphoto (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 19:14:32.032
	Select *
	From countryphotos
	Where networkID = 112
	and citynetworkid = 5030 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 19:14:32.032
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.82'
and logtime > "2020-02-28"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 19:14:32.032
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.82'
and logtime > "2020-05-29 00:00:00.000"
and logtime < "2020-05-29 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:14:32.032
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.82'
and logtime > "2020-05-22"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 19:14:32.032
	SELECT *
	From contentcountcountry
	Where networkid = 112 
gettopbanner (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 19:14:32.032
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-05-28"
    and fromDate < "2020-05-29"
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 19:14:32.032
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-05-28"
    and fromDate < "2020-05-29"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 19:14:32.032
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:14:32.032
	Select *
	From citynetworks 
	Where citynetworkid = 5030 
gettaxgeneral (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement, articlecityplace 
 	Where hitopic <> ''
 	and articlePlacement.networkID = 112 
 	and articlecityplace.citynetworkid = 5030
    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-05-29"
    ORDER by articles.articleID desc
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%Sharjah%') OR (author LIKE '%Sharjah%') OR (hitopic LIKE '%Sharjah%') OR (hidescript LIKE '%Sharjah%')))
	and articlePlacement.networkID = 112 
	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-05-29"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:14:32.032
SELECT qoid, value 
FROM qoptions 

WHERE value = 'UAE' 

and qid = 46
checkretirefeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 112 
         and citynetworkid = 5030 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 112 
         and citynetworkid = 5030 
         and city <> ''
         
   	 order by date DESC
   	
checkparenting (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 112 
         and citynetworkid = 5030 
         and city <> ''
         
   	 order by date DESC
   	
checkdreamfeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 112 
         and citynetworkid = 5030 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 112 
         and citynetworkid = 5030 
         and city <> ''
         
   	 order by date DESC
   	
checkculturefeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 112 
         and citynetworkid = 5030 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 112 
         and citynetworkid = 5030 
         and city <> ''
         
   	 order by date DESC
   	
checkmovingfeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 112 
         and citynetworkid = 5030 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 112 
         and citynetworkid = 5030 
   	 order by date DESC
   	
checklivingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 112 
         and citynetworkid = 5030 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 112 
         and citynetworkid = 5030 
   	 order by date DESC
   	
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 112 
         and citynetworkid = 5030 
   	 order by date DESC
   	
checkwork (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 112 
         and citynetworkid = 5030 
   	 order by date DESC
   	
checkschool (Datasource=expert, Time=5ms, Records=6) in /home/www/html/expatguide.cfm @ 19:14:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 112 
         and citynetworkid = 5030 
   	 order by date DESC
   	
getrealestateadvice (Datasource=tipripper, Time=5ms, Records=4) in /home/www/html/expatguide.cfm @ 19:14:32.032
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 112
and allreports.networkid = 112
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 112
and allreports.networkid = 112
 and allreports.citynetworkid2 =  5030
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 112
and allreports.networkid = 112
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:14:32.032
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 112
and allreports.networkid = 112
 and allreports.citynetworkid2 =  5030
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=8ms, Records=2) in /home/www/html/expatguide.cfm @ 19:14:32.032
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 112
and allreports.networkid = 112
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 19:14:32.032
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 112
and allreports.networkid = 112
 and allreports.citynetworkid2 =  5030
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 19:14:32.032
	Select *
	From Networks
	Where networkID = 112 
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 19:14:32.032
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24562
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 19:14:32.032
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24331
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 19:14:32.032
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 14141
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 19:14:32.032
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 13592
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 19:14:32.032
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 13591
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 19:14:32.032
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 2372
				AND answerstext.qid = 82
					
checkrptarticles (Datasource=reports, Time=4ms, Records=1) in /home/www/html/navcontentbox.cfm @ 19:14:32.032
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-29"
     
         and rptarticlenetworks.networkid = 112 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 19:14:32.032
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 39
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 19:14:32.032
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 112 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 19:14:32.032
SELECT  hiimg
FROM rptarticles
where rptarticleID = 39
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=3) in /home/www/html/navcontentbox.cfm @ 19:14:32.032
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 112 
	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-05-29"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 19:14:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 112 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 19:14:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 112 
          and date > '2013-04-01'
		order by date DESC


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/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=112&citynetworkid=5030
REMOTE_ADDR=172.69.62.82
REMOTE_HOST=172.69.62.82
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=28657838
cftoken=68443957
sessionid=IBEXPATEXCHANGE.COM_28657838_68443957
urltoken=CFID=28657838&CFTOKEN=68443957
URL Parameters:
citynetworkid=5030
networkid=112
Debug Rendering Time: 10 ms