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

Expat Guide to Living in Rio de Janeiro

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

More Culture Shock Reports for Rio de Janeiro

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

More Living in Rio de Janeiro Reports

What are people's priorities in Rio de Janeiro - 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 Rio de Janeiro:
Submit a Living Overseas Report

More Moving to Rio de Janeiro Reports

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

Reviews of Schools in Rio de Janeiro

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

Dream vs. Reality Report

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Rio de Janeiro. If you are already living in Rio de Janeiro, 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 Rio de Janeiro by filling out our Overseas Retirement report.

Submit a Retire Abroad Report

Having a Baby in Rio de Janeiro Reports

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

Working Abroad Report

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

Expat-Advice10 Tips for Living in Brazil

Whether it's the beaches, exciting nightlife or the banking industry that draw you to Brazil, expats seem to truly enjoy life in Brazil. We've pulled together tips from expats in Brazil about learning Portuguese, crime, international schools, renting an apartment and much more.

Whether it's the beaches, exciting nightlife or the banking industry that draw you to Brazil, expats seem to truly enjoy life in Brazil. We've pulled together tips from expats in Brazil about learnin...

Expats-in-Brazil5 Tips for Living in Florianopolis, Brazil

Expats LOVE Florianopolis, Brazil for it's breathtaking beaches and safe neighborhoods. Plus, it's a great place to raise kids. Unfortunately, the cost of living and limited job opportunities can be challenging.

Expats LOVE Florianopolis, Brazil for it's breathtaking beaches and safe neighborhoods. Plus, it's a great place to raise kids. Unfortunately, the cost of living and limited job opportunities can be...

Expats-in-Sao-Paulo5 Tips For Living in Sao Paulo

Expats in Sao Paulo find themselves living in one of the most important cities in South America. Technology, finance, and services drive its economy, and that of Brazil as a nation. Influences from all over the world have shaped its culture.

Expats in Sao Paulo find themselves living in one of the most important cities in South America. Technology, finance, and services drive its economy, and that of Brazil as a nation. Influences from ...

Retirement-In-TaibaAn Expat Shares What it's Like Retiring in Taiba, Brazil

Eight years ago, a British couple bought a small farm that's a few minutes from the beach and settled into retirement in Brazil. They have great tips for newcomers about finances, renting vs. buying and learning the language.

Eight years ago, a British couple bought a small farm that's a few minutes from the beach and settled into retirement in Brazil. They have great tips for newcomers about finances, renting vs. buying ...

Moving-To-Praia-de-PipaAn Expat Talks about Moving to Praia de Pipa, Brazil

An American couple extensively researched and visited properties buying a place in Praia de Pipa, Brazil. They share great tips for anyone following in their footsteps about the property buying process and moving to Brazil.

An American couple extensively researched and visited properties buying a place in Praia de Pipa, Brazil. They share great tips for anyone following in their footsteps about the property buying proce...

Brazil Guide
Other Links
Our Story Our Team Contact Us Submit an Article Advertising Travel Warnings

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /expatguide.cfm
Time Stamp 02-Jul-20 11:20 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.193
Host Name 172.69.63.193


Execution Time

Total Time Avg Time Count Template
184 ms 184 ms 1 top level /home/www/html/expatguide.cfm
24 ms 24 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
23 ms 23 ms 1 /home/www/html/navcontentbox.cfm
23 ms 23 ms 1 /home/www/html/navrightmidcolumn_rdesign5.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/boolsearch.cfm
1 ms 1 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/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 9 /home/www/html/rewritecityname.cfm
0 ms 0 ms 9 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 9 /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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
190 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 @ 11:20:37.037
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 11:20:37.037
      	  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 @ 11:20:37.037
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 11:20:37.037
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 24 
getcities (Datasource=expert, Time=1ms, Records=5) in /home/www/html/navmeta_rdesign4.cfm @ 11:20:37.037
	Select *
	From citynetworks
	Where networkID = 24
	and status <> 'hold'
	ORDER by city
getcity (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 11:20:37.037
	Select *
	From citynetworks
	Where citynetworkid = 4088 
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 11:20:37.037
  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 @ 11:20:37.037
	Select *
	From Networks
	Where networkID = 24 
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 11:20:37.037
	Select *
	From countryphotos
	Where networkID = 24
	and citynetworkid = 4088 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 11:20:37.037
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.193'
and logtime > "2020-04-02"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 11:20:37.037
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.193'
and logtime > "2020-07-02 00:00:00.000"
and logtime < "2020-07-02 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 11:20:37.037
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.193'
and logtime > "2020-06-25"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 11:20:37.037
	SELECT *
	From contentcountcountry
	Where networkid = 24 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 11:20:37.037
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-01"
    and fromDate < "2020-07-02"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 11:20:37.037
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
	Select *
	From citynetworks 
	Where citynetworkid = 4088 
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 11:20:37.037
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement, articlecityplace 
 	Where hitopic <> ''
 	and articlePlacement.networkID = 24 
 	and articlecityplace.citynetworkid = 4088
    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-02"
    ORDER by articles.articleID desc
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 11:20:37.037
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%Rio%') OR (author LIKE '%Rio%') OR (hitopic LIKE '%Rio%') OR (hidescript LIKE '%Rio%')) AND ((title LIKE '%de%') OR (author LIKE '%de%') OR (hitopic LIKE '%de%') OR (hidescript LIKE '%de%')) AND ((title LIKE '%Janeiro%') OR (author LIKE '%Janeiro%') OR (hitopic LIKE '%Janeiro%') OR (hidescript LIKE '%Janeiro%')))
	and articlePlacement.networkID = 24 
	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-02"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Brazil' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 24 
         and citynetworkid = 4088 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 24 
         and citynetworkid = 4088 
         and city <> ''
         
   	 order by date DESC
   	
checkparenting (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 24 
         and citynetworkid = 4088 
         and city <> ''
         
   	 order by date DESC
   	
checkdreamfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 24 
         and citynetworkid = 4088 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 24 
         and citynetworkid = 4088 
         and city <> ''
         
   	 order by date DESC
   	
checkculturefeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 24 
         and citynetworkid = 4088 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 24 
         and citynetworkid = 4088 
         and city <> ''
         
   	 order by date DESC
   	
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 24 
         and citynetworkid = 4088 
		order by date DESC
checkmoving (Datasource=expert, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 24 
         and citynetworkid = 4088 
   	 order by date DESC
   	
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 24 
         and citynetworkid = 4088 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 24 
         and citynetworkid = 4088 
   	 order by date DESC
   	
checkbaby (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 24 
         and citynetworkid = 4088 
   	 order by date DESC
   	
checkwork (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 24 
         and citynetworkid = 4088 
   	 order by date DESC
   	
checkschool (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 24 
         and citynetworkid = 4088 
   	 order by date DESC
   	
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 26451 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 25982 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 12094 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 25875 
getrealestateadvice (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 11:20:37.037
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 24
and allreports.networkid = 24
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 @ 11:20:37.037
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 24
and allreports.networkid = 24
 and allreports.citynetworkid2 =  4088
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 @ 11:20:37.037
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 24
and allreports.networkid = 24
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 11:20:37.037
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 24
and allreports.networkid = 24
 and allreports.citynetworkid2 =  4088
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 24
and allreports.networkid = 24
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=10ms, Records=0) in /home/www/html/expatguide.cfm @ 11:20:37.037
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 24
and allreports.networkid = 24
 and allreports.citynetworkid2 =  4088
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 25875 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 26451 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 25982 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 12094 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 11:20:37.037
	Select *
	From Networks
	Where networkID = 24 
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24898
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 11:20:37.037
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 21226
				AND answerstext.qid = 82
					
checkrptarticles (Datasource=reports, Time=4ms, Records=0) in /home/www/html/navcontentbox.cfm @ 11:20:37.037
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-02"
     
         and rptarticlenetworks.networkid = 24 
    ORDER by rptarticles.rptarticleID asc   
    
gettaxgeneral2 (Datasource=expert, Time=4ms, Records=3) in /home/www/html/navcontentbox.cfm @ 11:20:37.037
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 24 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-02"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentbox.cfm @ 11:20:37.037
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 24 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 11:20:37.037
		Select summary, hiimg 
		FROM answers
         where answerid = 73641
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentbox.cfm @ 11:20:37.037
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 24 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 11:20:37.037
		Select summary, hiimg 
		FROM answers
         where answerid = 71249
         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=24&citynetworkid=4088
REMOTE_ADDR=172.69.63.193
REMOTE_HOST=172.69.63.193
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=30731360
cftoken=40709799
sessionid=IBEXPATEXCHANGE.COM_30731360_40709799
urltoken=CFID=30731360&CFTOKEN=40709799
URL Parameters:
citynetworkid=4088
networkid=24
Debug Rendering Time: 10 ms