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

Expat Guide to Living in Lagos

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

Culture Shock Report

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

Submit a Culture Shock Report

Living Overseas Report

What are people's priorities in Lagos - 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 Lagos 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 Lagos? What should you leave behind? What type of housing and neighborhoods are typical for expats in Lagos? Help others moving to Lagos by filling out our Moving Overseas Report.

Submit a Moving Overseas Report

Reviews of Schools in Lagos

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

Dream vs. Reality Report

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Lagos. If you are already living in Lagos, 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 Lagos 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 Lagos? Help other expats who are preparing to have a baby in Lagos 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 Lagos? How difficult was it to obtain a work permit? What types are jobs are typical for expats in Lagos? 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 Portugal from our partner, Cigna Global Health.
Get a Quote

9-Expats-Talk-About-What-Its-Really-Like-Living-in-Portugal9 Expats Talk About What It's Really Like Living in Portugal

With it's beautiful beaches, historic cities, lower cost of living and welcoming Portuguese people, Portugal continues to be a popular expat destination. 9 expats talk about what it's really like living in Portugal.
With it's beautiful beaches, historic cities, lower cost of living and welcoming Portuguese people, Portugal continues to be a popular expat destination. 9 expats talk about what it's really like liv...

Expats-in-PortugalLisbon, Portugal

Lisbon is the capital and largest city in Portugal, which is one of the most popular countries for expats in Europe. You'll find basic information to help you get acquainted with Lisbon and what it has to offer.

Lisbon is the capital and largest city in Portugal, which is one of the most popular countries for expats in Europe. You'll find basic information to help you get acquainted with Lisbon and what it h...

Living-in-PortugalBest Places to Live in the Algarve

If you're interested in the best places to live in the Algarve, Portugal's sunny southern-most region, here are some great options to consider. Also find information on why some like the region, and others choose to opt elsewhere.

If you're interested in the best places to live in the Algarve, Portugal's sunny southern-most region, here are some great options to consider. Also find information on why some like the region, and ...

Retirement-In-CascaisAn Expat Shares What it's Like Retiring in Cascais, Portugal

Here is a wonderful, detailed report about what it's like to retire in Portugal. Written by a woman with dual US/Dutch citizenship, she has left no stone unturned!

Here is a wonderful, detailed report about what it's like to retire in Portugal. Written by a woman with dual US/Dutch citizenship, she has left no stone unturned!...

Moving-To-PortoAn Expat Talks about Moving to Porto, Portugal

An expat talks about moving to Porto, Portugal - moving costs, renting a condo, the lower cost of living in Porto and more.

An expat talks about moving to Porto, Portugal - moving costs, renting a condo, the lower cost of living in Porto and more....

Portugal 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 10-Jul-20 09:31 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.79.9
Host Name 162.158.79.9


Execution Time

Total Time Avg Time Count Template
182 ms 182 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
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
4 ms 4 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
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/rewritearticlefirsttitle.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 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/rewritearticle.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
187 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 @ 09:31:56.056
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 09:31:56.056
      	  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 @ 09:31:56.056
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 09:31:56.056
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 92 
getcities (Datasource=expert, Time=0ms, Records=6) in /home/www/html/navmeta_rdesign4.cfm @ 09:31:56.056
	Select *
	From citynetworks
	Where networkID = 92
	and status <> 'hold'
	ORDER by city
getcity (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 09:31:56.056
	Select *
	From citynetworks
	Where citynetworkid = 5058 
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 09:31:56.056
  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 @ 09:31:56.056
	Select *
	From Networks
	Where networkID = 92 
getphoto (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navmeta_rdesign4.cfm @ 09:31:56.056
	Select *
	From countryphotos
	Where networkID = 92
	and citynetworkid = 5058 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 09:31:56.056
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-04-10"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 09:31:56.056
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-07-10 00:00:00.000"
and logtime < "2020-07-10 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 @ 09:31:56.056
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-07-03"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 09:31:56.056
	SELECT *
	From contentcountcountry
	Where networkid = 92 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 09:31:56.056
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-09"
    and fromDate < "2020-07-10"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 09:31:56.056
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 09:31:56.056
	Select *
	From citynetworks 
	Where citynetworkid = 5058 
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 09:31:56.056
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement, articlecityplace 
 	Where hitopic <> ''
 	and articlePlacement.networkID = 92 
 	and articlecityplace.citynetworkid = 5058
    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-10"
    ORDER by articles.articleID desc
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 09:31:56.056
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%Lagos%') OR (author LIKE '%Lagos%') OR (hitopic LIKE '%Lagos%') OR (hidescript LIKE '%Lagos%')))
	and articlePlacement.networkID = 92 
	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-10"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 09:31:56.056
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Portugal' 

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

    ORDER by articles.articleID desc
    
checkretirefeature (Datasource=expert, Time=5ms, Records=3) in /home/www/html/navcontentbox.cfm @ 09:31:56.056
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 92 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 09:31:56.056
		Select summary, hiimg 
		FROM answers
         where answerid = 75637
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 09:31:56.056
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 92 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 09:31:56.056
		Select summary, hiimg 
		FROM answers
         where answerid = 76515
         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=92&citynetworkid=5058
REMOTE_ADDR=162.158.79.9
REMOTE_HOST=162.158.79.9
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=31625683
cftoken=58485117
sessionid=IBEXPATEXCHANGE.COM_31625683_58485117
urltoken=CFID=31625683&CFTOKEN=58485117
URL Parameters:
citynetworkid=5058
networkid=92
Debug Rendering Time: 10 ms