Home Spain Forum Spain Guide Moving to Spain Real Estate Healthcare in Spain
Spain
Resources
City Guides
JoinSign In
Take the 2020 Expat Exchange Survey

Healthcare in Spain > 7 Important Tips about Healthcare for Expats in Spain

7 Important Tips about Healthcare for Expats in Spain

By Betsy Burlingame

Last updated on: Oct 15, 2019

Summary: Expats in Spain share their experiences with healthcare and overseas medical insurance in Spain.

Expats in Spain - 7 Important Tips about Healthcare

If you are thinking about living in Spain, health insurance and medical care are among your key considerations. Spain's Healthcare System is considered among the best in the world. Our guide to healthcare and health insurance in Spain includes these 7 topics:

Healthcare Costs in Spain

One expat described medical costs in Spain saying, "Doctors, treatments, medications are dramatically less expensive here. Custom orthotics would have cost me approximately $300 in the US, but are $45 here."

"My policy costs 1017 Euros or about $1109 annually. It can also be paid monthly through a bank deduction. There is no co-pay, which is the requirement for the Spanish visa, so most treatment is included, but not prescriptions or outside consultation," reported one expat.

Expat Health Insurance in Spain

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

Quality of Medical Care in Spain

"Before I first moved to Europe, one year ago, I was afraid that our excellent USA medical care was a sacrifice I wasn't willing to make. So I took out a very expensive insurance policy (about $ 15M per year) and 'damned the torpedoes'. Since then I've learned that France has better medical care, and that Spain is pretty much up there too. My insurance costs are down to under $300 per month which is below what I would have paid with Medicare + excess coverage. I would suggest that you check carefully what hospitals, and what rating these hospitals have in the city/area you want to live. Then I would check which national insurance will cover you and what requirements they have. We are in Spain and are using SANITAS. So far, so good. The medical care in Switzerland, France and Spain, in which we have lived over the past 12 months, has been good to exception," explained one expat who retired in Spain.

Overseas Health Insurance is Required for Residence Visas

According to the Consulate of Spain in Washington DC, all four types of residence visas require you to have overseas medical insurance from a company licensed to operate in Spain. For more details on obtaining residency, read our article, 8 Tips for Obtaining Long-Term Residency in Spain.

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

Prescription Drugs Prices in Spain

An expat in Madrid commented, "All of my medicines are available here [in Spain]. Often much lower in cost than the US. I take medication for my asthma. in the US my co-pay is $100 with Walgeens saying my insurance saved me $550.00. Here my over the counter price for the exact same medicine from Smith Glaxo Kline is $63."

Another expat added, "Most medications are available at pharmacies without a prescription. Bring old medication bottle or written info with name and dosage. They may have a different name. I always check via internet to make sure what I got is the correct medication and dosage. Certain prescriptions like antibiotics require a prescription. Most medications are extremely inexpensive."

Hospitals in Spain

"I live outside of Madrid. I found HM hospitals are excellent. They are very detail oriented and are an international hospital so communication is not a problem. HM has many specialists here. I am in a serious situation now and all the doctors are working as a team," said one expat.

An expat in Altea said, "On my plan, there are two large private clinics/hospitals in Benidorm which is about a 45 minute bus ride or 20 minute car ride. I have heard and experienced both good treatment at these facilities, and also poor treatment, like a man I know who had surgery for a broken leg after being struck by a car. They botched it and he had to have multiple surgeries to correct it. I had to make multiple trips for assessment and feedback."

Get a Second Opinion

"Although the primary care from physicians and the local hospital/clinic are generally adequate, I recommend getting a second opinion before accepting a recommendation for major treatment like surgery, even though you will likely have to pay that out of pocket," advised another expat.

Giving Birth in Spain

"I went to the local state hospital (Maternity and childrens) everything was great, the midwives were very helpful with breathing techniques and changing positions. I had an epidural with a weak dose and I could still move around. I stayed in for 36 hours. I found it a lot better than I had heard, no shaving, enema or forced episiotomy, my baby was delivered straight onto my chest and the midwife helped latch her on. Then once in my room she showed me various feeding techniques and explained the main problems I would encounter. It was a 100% positive experience and we are planning a repeat performance," described one expat who had a baby in Granada.

An expat who gave birth at a hospital in Barcelona said, "I didn't choose [my doctor]. They are assigned through the local Social Security System. I delivered in a hospital without any type of pain management. I did have the option of having an epidural, but decided against it. I stayed in the hospital for 2 days after the delivery. It was a positive experience overall, but I was somewhat disappointed with the lack of support for breastfeeding.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Healthcare in AlteaHealthcare in Altea, Spain

An expat in Altea, Spain shares her experiences with expat health care and insurance. Topics covered include costs, medications, quality of health care, medical procedures abroad and more.

Healthcare in MadridHealthcare in Madrid, Spain

An expat in Madrid recommends HM hospitals, says that prescriptions are a fraction of the prices that they are in the US and has a warning about US health insurance policies for expats.

expat healthcare surveyAnswer Questions about Healthcare in Spain

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

Having-a-Baby-In-SpainExpats Talk about What it's Like Having a Baby in Spain

Read recent baby reports submitted for Granada and Barcelona.

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

Join our Spain Expat Forum

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

Read Next

Moving-to-ValenciaMoving to Valencia

Expats moving to Valencia enjoy life on the Mediterranean coast and a cost of living that is lower than what expats in Barcelona and Madrid must absorb.

Moving-to-BarcelonaMoving to Barcelona

Expats in Barcelona enjoy a beautiful city on the Mediterranean Sea and one of the most popular cities in Europe. Here is some great advice from expat that already live there.

10-Tips-for-Living-in-Spain10 Tips for Living in Spain

Expats Living in Spain offer their advice for others making the move to the nation on the Iberian peninsula. From what to bring, to learning Spanish, culture shock and more, read on to learn how to settle into your new life as an expat in Spain.

Pros-and-Cons-of-Living-in-SpainExpats in Spain: Pros and Cons of Living in Spain

Expats in Spain discuss the pros and cons of living in Spain. Topics discussed include lower cost of living, taxation on worldwide income, friendliness of Spaniards, LGBT community, slower pace of life and more.

5-Best-Places-to-Live-in-Spain5 Best Places to Live in Spain

Expats in Spain have a lot of opinions as to the best places to live in Spain. It all comes down to preferences, resources and where you are in life. Here's a good start in your research for deciding where to live in Spain as an expat!

About the Author

Betsy Burlingame Betsy Burlingame is the Founder of Expat Exchange. She launched Expat Exchange in 1997 as her Master's thesis project at NYU. Some of Betsy's more popular articles include 6 Best Places to Live in Costa Rica, 12 Things to Know Before Moving to The Dominican Republic and 7 Tips for Obtaining Residence in Italy. Betsy loves to travel and spend time with her family. Connect with Betsy on LinkedIn.

Take the 2020 Expat Exchange Survey

Write a Comment about this Article

Sign In to post a comment.
addacomment

Comments about this Article

egorhunka
May 20, 2017 19:38

Betsy - Could you please tell me the name and contact info of the company you are contracted with for your health insurance. The 1017 Euro premium you are paying sounds like a good option. Thanks, Lou Defrain

Updated On: Oct 15, 2019

First Published: Dec 13, 2016

Cigna Expat Health InsuranceExpatriate Health Insurance

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

healthcare in AlteaHealthcare in Altea, Spain

An expat in Altea, Spain shares her experiences with expat health care and insurance. Topics covered include costs, medications, quality of health care, medical procedures abroad and more. -

healthcare in MadridHealthcare in Madrid, Spain

An expat in Madrid recommends HM hospitals, says that prescriptions are a fraction of the prices that they are in the US and has a warning about US health insurance policies for expats. -

healthcare surveyAnswer Questions about Healthcare in Spain

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

Having-a-Baby-In-SpainExpats Talk about What it's Like Having a Baby in Spain

Read recent baby reports submitted for Granada and Barcelona.

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

Spain 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 03-Jun-20 09:57 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.143
Host Name 172.69.63.143


Execution Time

Total Time Avg Time Count Template
87 ms 87 ms 1 top level /home/www/html/lib_rd.cfm
33 ms 33 ms 1 /home/www/html/navcontentboxhealthcaremobile.cfm
9 ms 9 ms 1 /home/www/html/commentsnew_rdesign4.cfm
9 ms 9 ms 1 /home/www/html/navtop_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/lib_rd_readnext.cfm
5 ms 5 ms 1 /home/www/html/Application.cfm
4 ms 4 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
3 ms 1 ms 3 /home/www/html/nativerotationtop_tester13.cfm
3 ms 3 ms 1 /home/www/html/navbottomad_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
3 ms 3 ms 1 /home/www/html/navmpu_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navcontentboxhealthcarepc.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/breadcrumb.cfm
1 ms 1 ms 2 /home/www/html/rewriteqoptionsctry.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/constants.cfm
0 ms 0 ms 2 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/natad/native_4872_25204.txt
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 8 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
93 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:57:09.009
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 09:57:09.009
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 09:57:09.009
	Select *
	From articles
	Where articleID = 4872
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=1ms, Records=0) in /home/www/html/lib_rd.cfm @ 09:57:09.009
	Select *
	From sponcers
	Where sponcerID = 0 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 09:57:09.009
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 4872 
	and articles.articleID = 4872 
	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 @ 09:57:09.009
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 4872
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 4872
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 09:57:09.009
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 09:57:09.009
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 101 
getcities (Datasource=expert, Time=1ms, Records=8) in /home/www/html/navmeta_rdesign4.cfm @ 09:57:09.009
	Select *
	From citynetworks
	Where networkID = 101
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 09:57:09.009
  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=1) in /home/www/html/navmeta_rdesign4.cfm @ 09:57:09.009
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 4872 
  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 @ 09:57:09.009
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.143'
and logtime > "2020-03-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 09:57:09.009
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.143'
and logtime > "2020-06-03 00:00:00.000"
and logtime < "2020-06-03 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:57:09.009
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.143'
and logtime > "2020-05-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 09:57:09.009
	SELECT *
	From contentcountcountry
	Where networkid = 101 
gettopbanner (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 09:57:09.009
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 09:57:09.009
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 874 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb.cfm @ 09:57:09.009
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4872 
checkcitynetwork (Datasource=expert, Time=1ms, Records=0) in /home/www/html/breadcrumb.cfm @ 09:57:09.009
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 4872 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 09:57:09.009
SELECT tag
FROM natadoptions 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 09:57:09.009
SELECT *
FROM natadoptions 
WHERE 'hiheader' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 09:57:09.009
SELECT *
FROM natadoptions 
WHERE natadtypeid = 1 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 09:57:09.009
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 1
and natadPlacement.networkID = 101
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-06-02"
and headerparagraphstart < "2020-06-03"
and headerparagraphstatus = 'live'

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

and (natsentenceweight = 'medium' or natsentenceweight = 'high')
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 09:57:09.009
SELECT resourceid, natsentence as adcode, natsentenceweight, natadid
FROM natads 
WHERE natadid = 1
and natsentencetype = 2 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 09:57:09.009
SELECT *
FROM natadoptions 
WHERE 'hianchor' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 09:57:09.009
SELECT *
FROM natadoptions 
WHERE natadtypeid = 5 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 09:57:09.009
SELECT resourceid,  natanchorlink as adcode,natanchorlinkweight, natads.natadid
FROM natads, natadPlacement
WHERE natanchorlinktype = 5
and natadPlacement.networkID = 101
and natadPlacement.natadid = natads.natadid
and natanchorlinkend > "2020-06-02"
and natanchorlinkstart < "2020-06-03"
and natanchorstatus = 'live'

and (natanchorlinkweight = 'medium' or natanchorlinkweight = 'high')
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 09:57:09.009
SELECT resourceid, natanchorlink as adcode, natanchorlinkweight, natadid
FROM natads 
WHERE natadid = 1
and natanchorlinktype = 5 
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:57:09.009
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 101 
	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 <> '4872'
	
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-03"
     ORDER by articles.sectionintro DESC, articles.articleID desc 
 
gethospitals (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:57:09.009
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 101 
		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 <> '4872'
	
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-03"
     ORDER by articles.title
 
GetClassifieds (Datasource=tipripper, Time=10ms, Records=2) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:57:09.009
SELECT *
FROM allreports, Networks, answers
WHERE allreports.rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 7
and hide <> 'y'
and allreports.networkid = 101 
and answers.answerid = allreports.answerid
and answers.reviewed = 'y'

    ORDER by allreports.answerid desc
    
getslugs (Datasource=tipripper, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:57:09.009
SELECT *
FROM topics
WHERE topicid = 7 
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:57:09.009
	SELECT summary as answer
	FROM answers
	WHERE answerid = 78381 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:57:09.009
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 78381 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:57:09.009
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 78381 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:57:09.009
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '101'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:57:09.009
	SELECT summary as answer
	FROM answers
	WHERE answerid = 77274 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:57:09.009
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 77274 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:57:09.009
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 77274 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:57:09.009
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '101'
checkbabyfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:57:09.009
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
      
         and networkid = 101 
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:57:09.009
		Select summary, hiimg 
		FROM answers
         where answerid = 24457
         and summary <> ''
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd_readnext.cfm @ 09:57:09.009
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4872 
gettaxgeneral (Datasource=expert, Time=5ms, Records=5) in /home/www/html/lib_rd_readnext.cfm @ 09:57:09.009
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 101 
	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.articleID <> 4872
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-03"

    ORDER by articles.articleID desc
    
gettopbanner (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 09:57:09.009
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
    and bannerPlacement.networkid = 101
    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 @ 09:57:09.009
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
gethpbox (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 09:57:09.009
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eehpboxcountry"
    and toDate > {ts '2020-06-02 09:57:09'}
    and fromDate <{ts '2020-06-03 09:57:09'}
    and weight < 7
    and bannerPlacement.networkid = 101
    and bannerPlacement.bannerid = banners.bannerid
    and banners.type <> 'swf'
  
gethpbox (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 09:57:09.009
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
	and weight < 7
    and toDate > {ts '2020-06-02 09:57:09'}
    and fromDate <{ts '2020-06-03 09:57:09'}
    and banners.type <> 'swf'
    
gethpbox (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navmpu_rdesign5.cfm @ 09:57:09.009
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
    and toDate > {ts '2020-06-02 09:57:09'}
    and fromDate <{ts '2020-06-03 09:57:09'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 09:57:09.009
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 875 
GetMessages (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 09:57:09.009
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 4872 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 09:57:09.009
  SELECT *
  FROM users
  WHERE userid = 154027 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 09:57:09.009
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4872 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:57:09.009
	SELECT summary as answer
	FROM answers
	WHERE answerid = 78381 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:57:09.009
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 78381 
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:57:09.009
	SELECT summary as answer
	FROM answers
	WHERE answerid = 77274 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:57:09.009
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 77274 
getsummary (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:57:09.009
		Select summary, hiimg 
		FROM answers
         where answerid = 24457
         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=4872&networkid=101
REMOTE_ADDR=172.69.63.143
REMOTE_HOST=172.69.63.143
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=28931970
cftoken=17706013
sessionid=IBEXPATEXCHANGE.COM_28931970_17706013
urltoken=CFID=28931970&CFTOKEN=17706013
URL Parameters:
articleID=4872
networkid=101
Debug Rendering Time: 10 ms