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

Healthcare in Brazil > Healthcare in Brazil

Healthcare in Brazil

By Joshua Wood, LPC

Last updated on: May 08, 2019

Summary: Expats in Brazil are able to get excellent health care in and many of the larger cities in Brazil. There is national health care available, but expats still strongly recommend private health insurance while living in Brazil.

Expats in Brazil - Healthcare in Brazil

Expat health care in Brazil is a critical aspect of life in the South American country, and it is a frequent topic on our forum for expats living in Brazil.

Medical Emergencies in Brazil

In the event of a medical emergency that requires immediate care, call 192 or 193 for an ambulance.

Quality of Care in Brazil

An expat in Natal shared: "Good doctors outside of Sao Paulo and Rio can be difficult to find....but in Sao Paulo you will have no problems finding one should you need it."

"Sao Paulo does have wonderful doctors and great private hospitals. Getting a local doctor who speak English should be relatively simple and your doctor can look them up in his doctor data base and give you names and telephone numbers to make contact."

"Should you need emergency care in Sao Paulo, Einstein Hospital is the best. I get a physical every year here and my doctor in Natal is actually a Cardiologist who trained under Dr. Christian Barnard in South Africa. My Doctor actually runs the stress test on the tread mill!"

Expats living in Brazil 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 Brazil interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA.

English-Speaking Doctors and Health Care Providers in Brazil

Here is a list of English-Speaking Doctors in Brazil as maintained by the U.S. Embassy in Brazil. Those on the list are "included after a review of their educational certification and local licensure."

The embassy website notes that "the quality of medical care available is similar to the same standards as in the US, if you use the physicians' list" above, adding that "it is not meant to be a complete list, as there are many competent doctors in the community." Inclusion on this list does not indicate exceptional competence. This list does not represent either a guarantee of competence or endorsement by the Department of State.

National Health Care in Brazil

On our expats in Brazil forum, an expat considering moving to Brazil asked: "Does Brazil have a national health care system?" An expat living in Brazil responded that, "Yes, Brazil does." However, he advised: "The quality varies with where you are, from poor to really good. Would think the south would have better healthcare, say from SP south. Most northern states are broke. [I] believe pre-existing conditions don't matter."

An expat in Natal wrote about the health system in Brazil: "Brazil does have a National Health Care program and my wife and I have taken advantage of this service for relatively minor health issues. But it is a national health care program that must be funded by the government with many cities such as Rio de Janerio unable to fund many of these clinics and public hospitals to the degree that they should be. We are retired and our health issues are relatively minor but we feel strongly about having a paid for medical insurance plan."

The public health system is called the Sistema Unico de Saude.

An article on the National Institutes of Health website asserts that The Brazilian health system at crossroads: progress, crisis and resilience. It reads that "structural weakness, economic and political crises and austerity policies that have capped public expenditure growth are threatening its sustainability and outcomes."

Payment for Health Care Services in Brazil

It is important to remember that in Brazil, payment is required for all medical services at the time that they are rendered.

Expat Health Insurance in Brazil

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

Prescriptions in Brazil

When asking about prescription Medicines in Brazil, some expats gave the following advice:

"I think a [Brazilian] doctor will be able to write a prescription for you. Lots of these doctors went to school or did internships in the U.S. and speak English."

"In some cases a doctor can write a prescription for you to fill for the 4 months that you will be in Sao Paulo. I lived there for 5 years and I am currently living in Praia da Pipa near Natal in the NE of Brazil."

"There is a pharmacy on every street corner of almost every city in Brazil so finding a pharmacy is no problem. I do take prescription medications and on my first visit with my new doctor he made it clear that the meds I was taking from the USA were out-dated and better meds were available. He switched my prescription and these meds are readily available at all the pharmacies that I have been to. It is hard to beat the USA $4.00 prescription program for a long list of certain meds. But buying the medications here have shown to be readily available and cheaper (not considering the USA $4.00 meds) than my home country."

"Except for some of the more exotic drugs I think you will find that prescription meds are cheaper here in Brazil... so much so that I pay for these out of pocket even though I have insurance. It is the over-the-counter-meds that cost so much here."

Having a Baby in Brazil

An expat who had a baby in Sao Paolo wrote: "I had my baby at Pro Matre cause Albert Einstein was full, but I dont regret it. We dont use any kind of health insurance, so we payed ir from our pockets. I spent 6 days there, 2 on ICU. And my daughter 12 days, all of them on neo ICU. I had all the support I need, even psychological care. The staff is great, and gives a lot of help with whatever we need."

Another expat who had a baby in Rio de Janeiro reported: "Although most Brasilians choose C-Section I requested a natural birth and they accommodated my wishes and I was not pushed into choosing to have a C-Section. With my second pregnancy there were complications and at a late stage in my pregnancy I was advised that a C-Section would be best for both myself and the baby but felt happy that this was the best advice. Both births were at the Perinatal in Laranjeiras and this is a private maternity hospital with top notch facilities and en-suite rooms."

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Healthcare in NatalHealthcare in Natal, Brazil

An expat living outside of Natal, Brazil talks about the healthcare system in Brazil, the lower cost of prescription medicines and more. He advises other expats to purchase private health insurance.

expat healthcare surveyAnswer Questions about Healthcare in Brazil

Help others moving to Brazil by answering a set of questions about health insurance, public healthcare in Brazil, prescription medicine, quality of medical care and emergency services.

Having-a-Baby-In-BrazilExpats Talk about What it's Like Having a Baby in Brazil

Read recent baby reports submitted for Sao Paulo and Rio de Janerio.

If you're an expat parent who had a baby abroad, write a report about your childbirth experiences to help other expecting expat parents.

About the Author

Joshua Wood Joshua Wood, LPC joined Expat Exchange in 2000. Joshua has a BA from Syracuse and a Master's in Clinical and Counseling Psychology from Fairleigh Dickinson University. Some of Joshua's more popular articles include Pros and Cons of Living in Portugal, 10 Best Places to Live in Ireland and 5 Best Places to Live in Spain. Connect with Joshua on LinkedIn.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Join our Brazil Expat Forum

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

More about Brazil

Expats-Talk-About-The-Biggest-Challenges-They-Face-Living-in-Latin-America

Expats Talk About The Biggest Challenges They Face Living in Latin America

Expats talk about some of the biggest challenges they've faced living in Latin America. Whether you're moving to Panama City or Punta del Este, this article is a must read to help you prepare (hint: you'll be much happier if you learn the language) and adjust your expectations (realities: the roads are rough, the pace of life is slower and bureaucracy is unavoidable). Despite all of the challenges, the list of what expats like about life in Latin America far exceeds the challenges.

Expats talk about some of the biggest challenges they've faced living in Latin America. Whether you're moving to Panama City or Punta del Este, this article is a must read to help you prepare (hint:...

5-Tips-For-Living-in-Sao-Paulo

5 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 ...

5-Tips-for-Living-in-Florianopolis,-Brazil

5 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...

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Updated On: May 08, 2019

First Published: May 08, 2019

Cigna Expat Health InsuranceExpatriate Health Insurance

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

healthcare in NatalHealthcare in Natal, Brazil

An expat living outside of Natal, Brazil talks about the healthcare system in Brazil, the lower cost of prescription medicines and more. He advises other expats to purchase private health insurance. -

healthcare surveyAnswer Questions about Healthcare in Brazil

Help others moving to Brazil by answering a set of questions about health insurance, public healthcare in Brazil, prescription medicine, quality of medical care and emergency services.

Having-a-Baby-In-BrazilExpats Talk about What it's Like Having a Baby in Brazil

Read recent baby reports submitted for Sao Paulo and Rio de Janerio.

If you're an expat parent who had a baby abroad, write a report about your childbirth experiences to help other expecting expat parents.

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 /lib_rd.cfm
Time Stamp 02-Jul-20 03:23 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.57
Host Name 172.69.63.57


Execution Time

Total Time Avg Time Count Template
97 ms 97 ms 1 top level /home/www/html/lib_rd.cfm
39 ms 39 ms 1 /home/www/html/navcontentboxhealthcaremobile.cfm
17 ms 17 ms 1 /home/www/html/lib_rd_ctrygd_readnext.cfm
11 ms 11 ms 1 /home/www/html/navtop_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/commentsnew_rdesign4.cfm
5 ms 5 ms 1 /home/www/html/Application.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
4 ms 4 ms 1 /home/www/html/navbottomad_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/navleader_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
3 ms 3 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navcontentboxhealthcarepc.cfm
2 ms 2 ms 1 /home/www/html/navmpu_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/breadcrumb.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
0 ms 0 ms 1 /home/www/html/boolsearch.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/natad/native_5357_2719.txt
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 5 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereportscountry.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
104 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 @ 15:23:11.011
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=4ms, Records=1) in /home/www/html/Application.cfm @ 15:23:11.011
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 15:23:11.011
	Select *
	From articles
	Where articleID = 5357
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 15:23:11.011
	Select *
	From sponcers
	Where sponcerID = 465 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 15:23:11.011
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 5357 
	and articles.articleID = 5357 
	and articlePlacement.networkID = Networks.networkID
	and articles.hinet = 'y'
  and (articles.general = 'no' or articles.general = 'city')
    and articles.hitopic <> ''
    and articles.hidescript <> ''
	and isCity <> "hold"
	AND networktype <> 2
	AND networktype <> 3
	AND networktype <> 4
	AND networktype <> 5
	AND networkname <> 'national'
	AND networkname <> 'Global Listing'
	AND (isCity = 'Country') 
citystatus (Datasource=expert, Time=0ms, Records=0) in /home/www/html/lib_rd.cfm @ 15:23:11.011
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 5357
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 5357
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=1ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 15:23:11.011
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 15:23:11.011
	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 @ 15:23:11.011
	Select *
	From citynetworks
	Where networkID = 24
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 15:23:11.011
  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
commentcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 15:23:11.011
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 5357 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid DESC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 15:23:11.011
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.57'
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 @ 15:23:11.011
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.57'
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=1) in /home/www/html/navtop_rdesign5.cfm @ 15:23:11.011
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.57'
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 @ 15:23:11.011
	SELECT *
	From contentcountcountry
	Where networkid = 24 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 15:23:11.011
	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=4ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 15:23:11.011
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb.cfm @ 15:23:11.011
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5357 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 15:23:11.011
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 5357 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 15:23:11.011
SELECT tag
FROM natadoptions 
getnatadtopull (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 15:23:11.011
SELECT *
FROM natadoptions 
WHERE 'hiheader' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 15:23:11.011
SELECT *
FROM natadoptions 
WHERE natadtypeid = 1 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 15:23:11.011
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 1
and natadPlacement.networkID = 24
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-07-01"
and headerparagraphstart < "2020-07-02"
and headerparagraphstatus = 'live'

and headerparagraphweight = 'high'
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 15:23:11.011
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 15:23:11.011
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 15:23:11.011
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 24
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-01"
and natsentencestart < "2020-07-02"
and natsentencestatus = 'live'

and (natsentenceweight = 'medium' or natsentenceweight = 'high')
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 15:23:11.011
SELECT resourceid, natsentence as adcode, natsentenceweight, natadid
FROM natads 
WHERE natadid = 46
and natsentencetype = 2 
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:23:11.011
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 24 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
   and articleCategories.section = '9'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    
    and articles.articleID <> '5357'
	
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-02"
     ORDER by articles.sectionintro DESC, articles.articleID desc 
 
gethospitals (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:23:11.011
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 24 
		and (((title LIKE '%hospital%') OR (hitopic LIKE '%hospital%') OR (hidescript LIKE '%hospital%')))
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '22'
   and articleCategories.section = '9'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    
    and articles.articleID <> '5357'
	
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-02"
     ORDER by articles.title
 
GetClassifieds (Datasource=tipripper, Time=12ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:23:11.011
SELECT *
FROM allreports, Networks, answers
WHERE allreports.rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 7
and hide <> 'y'
and allreports.networkid = 24 
and answers.answerid = allreports.answerid
and answers.reviewed = 'y'

    ORDER by allreports.answerid desc
    
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:23:11.011
SELECT *
FROM topics
WHERE topicid = 7 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:23:11.011
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79000 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:23:11.011
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79000 
getphotos (Datasource=reports, Time=1ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:23:11.011
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 79000 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:23:11.011
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '24'
checkbabyfeature (Datasource=expert, Time=9ms, Records=3) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:23:11.011
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
      
         and networkid = 24 
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:23:11.011
		Select summary, hiimg 
		FROM answers
         where answerid = 27896
         and summary <> ''
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 15:23:11.011
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5357 
gettaxgeneral3 (Datasource=expert, Time=8ms, Records=1) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 15:23:11.011
	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 keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and articles.articleID <> 5357
    and publishdate < "2020-07-02"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID desc
    
gettaxgeneral4 (Datasource=expert, Time=7ms, Records=2) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 15:23:11.011
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articlecityplace
	Where hitopic <> ''
	and articlePlacement.networkID = 24 
	AND articlePlacement.articleID = articles.articleID
		and articlecityplace.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.articleID <> 5357
    and publishdate < "2020-07-02"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID desc
    
gettopbanner (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 15:23:11.011
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-01"
    and fromDate < "2020-07-02"
    and bannerPlacement.networkid = 24
    and bannerPlacement.bannerid = banners.bannerid
    and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 15:23:11.011
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 15:23:11.011
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-07-01 15:23:11'}
    and fromDate <{ts '2020-07-02 15:23:11'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 15:23:11.011
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 15:23:11.011
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 5357 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 15:23:11.011
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5357 
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 15:23:11.011
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79000 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 15:23:11.011
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79000 
getsummary (Datasource=reports, Time=1ms, Records=0) in /home/www/html/navcontentboxhealthcarepc.cfm @ 15:23:11.011
		Select summary, hiimg 
		FROM answers
         where answerid = 27896
         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/lib_rd.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/lib_rd.cfm
QUERY_STRING=articleID=5357&networkid=24
REMOTE_ADDR=172.69.63.57
REMOTE_HOST=172.69.63.57
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/lib_rd.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=30740933
cftoken=33894517
sessionid=IBEXPATEXCHANGE.COM_30740933_33894517
urltoken=CFID=30740933&CFTOKEN=33894517
URL Parameters:
articleID=5357
networkid=24
Debug Rendering Time: 13 ms