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

Healthcare in Italy > Healthcare in Italy

Healthcare in Italy

By Betsy Burlingame

Last updated on: May 14, 2019

Summary: An overview of the healthcare system in Italy - public and private hospitals, Servizio Sanitario Nazionale (SSN), getting your Tessera Sanitaria (healthcare card), vaccinations for Italy, prescription medication availability and more.

Expats in Italy - Healthcare in Italy

Italy Healthcare System

"In Italy, patients are free to choose between public hospitals and private hospitals. Public hospitals normally provide both emergency and non-emergency services. At public hospitals, patients may receive emergency services at no cost or upon payment of a limited contribution, depending on the public hospital's policy. Non-emergency services provided by public hospitals are subject to a fee. Public hospitals' quality standards may be different from those of American hospitals. However, Italian public hospitals must meet quality standards and criteria established by Italian law and are normally equipped to provide emergency services," wrote the US Embassy in Italy in their article, "An Overview of the Italian National Health System".

Private Hospitals in Italy

"Private hospitals do not normally have emergency rooms. To be admitted to a private hospital, it is usually necessary to make arrangements with the hospital's administration or directly with a doctor affiliated with the private hospital prior to being admitted. Private hospitals normally have higher fees than public hospitals. Patients in private hospitals are generally required to pay fees upfront before leaving the hospital. (Patients with insurance may subsequently seek reimbursement from their insurance companies.) Some private hospitals may be 'accredited' which means that fees can be reimbursed by the Italian National Health Service if the patient is an official resident in Italy and affiliated with the National Health System," wrote the US Embassy in Italy.

Private Health Insurance in Italy

Some expats choose to have expat health insurance to have access to private hospitals and private doctors in Italy and outside of Italy. Many of these international insurance plans provide global coverage or coverage in most countries.

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

Proof of Health Insurance for Permesso di Soggiorno (Residency Permit)

If you are applying Permesso di Soggiorno (residency), you will be required to show proof of private health insurance coverage. One expat explained, "If I understand correctly, we can't buy the private health insurance that Italian citizens do until we get our ID cards . Yet we can buy coverage now from a private insurance company located outside Italy. I'm still trying to get my head around the logic of that."

Public Hospitals in Italy

Many expats, especially Americans living in Italy, will find that the public hospital experience is much different than hospital stays in the US. In a lengthy thread on the Italy forum, expats shared their personal experiences:

"The nurses provide medical care. Take blood, administer meds, take pulse, bring bedpan. But that's ALL they do. They do not provide, or bring water. Or ice. Or a way to wash up. The hospital doesn't provide or sell crutches, walkers etc. The hospital generally expect family members to be there for basic care and needs. I was in the hospital last year and my roommate's husband spent every night on a cot with her. I also saw other people walking down the halls with their cots in the morning. It is expected. So if you come here with no family and no friends and you have to go in the hospital you are in trouble. You need to have friends, family, a network to help you. You can't go it alone," cautioned one expat.

Another expat added, "Absolutely true! It happened to me. After being in the hospital for approximately 3 weeks or so I commented to a friend that I never had a wash (I was bedridden) and she laughed saying the nurses don't do that, your family does....oh ??! Single people be warned! P.S.: I believe you can hire someone to help you. A friend told me I could find work doing that when I was unemployed. From what I understand however it will cost you a pretty penny."

"Yes indeed there are ants and you DO have to bring things like soap, towels, and so on even in the Northern teaching hospitals (and yes i have 1st hand experience). Lucky you if you have someone to help you. I was unable to move and yet they put the food tray near my feet. The other patient in the room would feed me and no I am NOT being sarcastic! I should say that where I live I both trust and respect the Drs but that's not to say the care is perfect and you shouldn't lead people to believe that it is," explained one expat.

"Agreed. We are in the Chieti region. Atessa is our nearest Pronto Soccorso. If you need more than they can give you they take you via ambulance to either Lanciano or Chieti where there is a large teaching hospital. The facilities in Atessa have clearly seen better days, they are not putting the money into cosmetic upgrades but the the people were very nice and efficient at their jobs. I dare say I spent more time with a doctor than the five minutes and a script for antibiotics that always seemed to be the result in a US walk in clinic. I think alot of people anxiety comes from knowing it will be different than what they are used to, the fear that comes from a language barrier," said another.

Enrolling in the Servizio Sanitario Nazionale (SSN)

Servizio Sanitario Nazionale (SSN) is the national healthcare system in Italy. According to the Italian government, "Foreign citizens [non-EU] with regular stay permit and their regularly staying dependent family members are entitled to registration with the National Health Service and to the same treatment as Italian citizens with reference to contributory burden and the health care provided." For information about obtaining residency in Italy, see our article, 7 Tips for Obtaining Residency in Italy.

When you apply for residency, you should be given the paperwork to apply for your Tessera Sanitaria. Tessera Sanitaria or Carta Sanitaria is the Italian healthcare card that is required when using the Servizio Sanitario Nazionale. Once you obtain your Permesso di Soggiorno, or residency permit, you may apply for the Tessera Sanitaria.

Italy Vaccines

According to the CDC, you need to make sure that you are up-to-date on routine vaccines before moving to Italy. These include measles-mumps-rubella (MMR) vaccine, diphtheria-tetanus-pertussis vaccine, varicella (chickenpox) vaccine, polio vaccine, and your yearly flu shot. It is also advised that you have Hepatitis A and Hepatitis B vaccines.

Is the Quality of Healthcare in Southern Italy different than in Northern Italy?

This question sparked some debate on the Italy forum:

"I live in Umbria where the healthcare is so-so. The farther south you go, the worse the healthcare system. I have first hand knowledge that you do need to bring most things you need to then hospitals in the south. Even here in Umbria you bring coffee cup, utensils, toilet paper towels, bowls for washing. If you need crutches someone in your family must buy and bring to you. You must provide your own water and someone to bring it to you. The nurses are too busy with medical things to help with everyday care. Here, they encourage family to spend the night on a cot to help with bed pans etc. Quite different than in the US for sure. But it cuts costs," stated one expat.

Another replied, "I am sorry but I have to disagree with you. This whole notion that healthcare in the South is sub-par is ridiculous. I live in Puglia and both my daughter-in-laws have had babies in local hospitals and my grandson spent a week in a local hospital. Both provided excellent care and believe it or not had sheets, utensils, and they actually fed them!!! (Yes I am being sarcastic). But what you said is not true for the hospitals here in Puglia. I have visited family members in Francavilla, Lecce, Ostuni, Brindisi and Martina-Franca. While they may not look great and not be pristine with amenities, the care was excellent. No ants, no bugs, and they provided water!" Another added, "Used several hospitals and clinics both private and state run, some newly built and some old buildings -- all in Puglia, well south of Rome. What you dedcribe is NOT true. And the care I received across the board was excellent. All bed sheets included. Just needed my own bath towel and toiletries."

Call 112 For an Ambulance in Italy

"In case of an emergency, for immediate medical attention or to call an ambulance dial 112 from any telephone in Italy. No country code is necessary if calling from within Europe," wrote the US Embassy in Italy.

Paying Your Bill at a Hospital or Clinic

"Private hospitals normally have higher fees than public hospitals. Patients in private hospitals are generally required to pay fees upfront before leaving the hospital. (Patients with insurance may subsequently seek reimbursement from their insurance companies.) Some private hospitals may be 'accredited' which means that fees can be reimbursed by the Italian National Health Service if the patient is an official resident in Italy and affiliated with the National Health System," stated the US Embassy in Italy.

In a thread on the Italy forum about paying for healthcare in Italy, one member posted, "My husband and I live in Piemonte 5 1/2 months a year traveling on tourist visas and our US health insurance covers us when we are outside the country. We do not have a permesso soggiorno. I recently had a health emergency that resulted in a visit to our local pronto soccorso, followed by an ambulance ride to a bigger hospital in a bigger town and 4 nights in the hospital. My purpose here is not to discuss the facilities or medical care, but to talk about the adventures of paying. The folks in the Accettazione, the payment office, kept asking for my Permesso and finally lacking that my passport, drivers license and insurance card. So far so good, but then came paying. There is no way under any circumstances to pay with a credit card. Luckily, we have a bank account here and they agreed to bank transfer. The bill was 3500 euro for care that would have cost 35K$ in the US."

"The only snag I have had was not with them, but rather figuring out how to pay the Novi Liguri hospital after a 4 night stay. The billing department would not accept a credit card and initially wanted cash (about $4K), but eventually allowed us to make a bank transfer from our Italian account. BTW the care I received was excellent, though the facility was a bit spartan," said one expat.

Prescription Medicine in Italy

"All common prescriptions are available here, generally a prescription is necessary but the pharmacists have a lot of discretion. I have been able to get antibiotics without a prescription for recurring sinus infections for example," commented one expat in a report about healthcare in Arezzo.

Expat Health Insurance in Italy

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

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Expats-in-Italy5 Expat Moms Talk about Having a Baby in Italy

5 expat moms offer candid insight into what it's like giving birth in Italy - from bringing towels and toilet paper with you to the hospital to being refused pain medication. And, like most advice in Italy, word of mouth is the best way to find a good OB/GYN.

5 expat moms offer candid insight into what it's like giving birth in Italy - from bringing towels and toilet paper with you to the hospital to being refused pain medication. And, like most advice in...

Expats-in-Italy9 Healthcare & Health Insurance Tips for Expats in Italy

Expats in Italy share tips and advice about healthcare and health insurance in Italy. Advice about finding an English-speaking doctor, using The Sistema Sanitario Nazionale (SSN) and more.

Expats in Italy share tips and advice about healthcare and health insurance in Italy. Advice about finding an English-speaking doctor, using The Sistema Sanitario Nazionale (SSN) and more....

italy Healthcare FAQItaly Healthcare FAQ

Answers to some of the most commonly asked questions about healthcare and health insurance for expats in Italy.

italy Healthcare InfoItaly Healthcare Info

Additional information about healthcare and health insurance for foreigners in Italy.

Healthcare in Healthcare in Italy

An expat in Italy discusses health care, pharmacies and health insurance costs. She explains that the cost of health insurance is nominal compared to the US and prescription medicine is very inexpens

Healthcare in ArezzoHealthcare in Arezzo, Italy

Get established with a local doctor before you actually need one--you will need a primary car doctor to refer you to specialists.

expat healthcare surveyAnswer Questions about Healthcare in Italy

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

Having-a-Baby-In-ItalyExpats Talk about What it's Like Having a Baby in Italy

Read recent baby reports submitted for Montesilvano, Pescara and Genoa.

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 Italy Expat Forum

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

Read Next

RomeRome

If you're moving to Rome, our Guide to Living in Rome provides answers to the questions most often asked by newcomers. Is living in Rome expensive? Which are the best International Schools in Rome? What if my apartment is a little smaller than the size required for obtaining a Residency Card? Where do expats live in Rome? The list goes on.

Puglia,-ItalyPuglia, Italy

Why is Puglia described as the new Tuscany? People are drawn to Puglia's low cost of living, amazing climate, beautiful beaches hidden away in coves, and, most importantly, the wonderful Pugliese people. If Puglia is on your shortlist, this overview of life in Puglia, Italy is an essential read.

10-Best-Places-to-Live-in-Puglia10 Best Places to Live in Puglia

Pulia or Apulia is sometimes referred to as the new Tuscany. With its low cost of living, friendly Pugliese people, beautiful beaches and villages of whitewashed homes, Puglia is a hidden gem among expats. If you're thinking about moving to Puglia, our list of the 10 best places to live in Puglia is based upon expat advice and recommendations.

5-Expat-Moms-Talk-about-Having-a-Baby-in-Italy5 Expat Moms Talk about Having a Baby in Italy

5 expat moms offer candid insight into what it's like giving birth in Italy - from bringing towels and toilet paper with you to the hospital to being refused pain medication. And, like most advice in Italy, word of mouth is the best way to find a good OB/GYN.

Tips-for-Expats-in-ItalyExpat Banking: Tips for Expats in Italy

All expats in Italy face managing their finances while living there, and that always starts with finding a bank. Here are some tips from expats already living in Italy based on their actual experiences with banks there.

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.

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Updated On: May 14, 2019

First Published: May 14, 2019

Cigna Expat Health InsuranceExpatriate Health Insurance

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

5-Expat-Moms-Talk-about-Having-a-Baby-in-Italy5 Expat Moms Talk about Having a Baby in Italy

5 expat moms offer candid insight into what it's like giving birth in Italy - from bringing towels and toilet paper with you to the hospital to being refused pain medication. And, like most advice in Italy, word of mouth is the best way to find a good OB/GYN.

5 expat moms offer candid insight into what it's like giving birth in Italy - from bringing towels and toilet paper with you to the hospital to being refused pain medication. And, like most advice in...

9-Healthcare--Health-Insurance-Tips-for-Expats-in-Italy9 Healthcare & Health Insurance Tips for Expats in Italy

Expats in Italy share tips and advice about healthcare and health insurance in Italy. Advice about finding an English-speaking doctor, using The Sistema Sanitario Nazionale (SSN) and more.

Expats in Italy share tips and advice about healthcare and health insurance in Italy. Advice about finding an English-speaking doctor, using The Sistema Sanitario Nazionale (SSN) and more....

italy healthcare faqItaly Healthcare FAQ

Answers to some of the most commonly asked questions about healthcare and health insurance for expats in Italy.

italy healthcare infoItaly Healthcare Info

Additional information about healthcare and health insurance for foreigners in Italy.

healthcare in Healthcare in Italy

An expat in Italy discusses health care, pharmacies and health insurance costs. She explains that the cost of health insurance is nominal compared to the US and prescription medicine is very inexpens -

healthcare in ArezzoHealthcare in Arezzo, Italy

Get established with a local doctor before you actually need one--you will need a primary car doctor to refer you to specialists. -

healthcare surveyAnswer Questions about Healthcare in Italy

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

Having-a-Baby-In-ItalyExpats Talk about What it's Like Having a Baby in Italy

Read recent baby reports submitted for Montesilvano, Pescara and Genoa.

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

Italy 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 28-May-20 07:35 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.25
Host Name 173.245.54.25


Execution Time

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

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

and natsentenceweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:35:34.034
SELECT resourceid, natsentence as adcode, natsentenceweight, natadid
FROM natads 
WHERE natadid = 1
and natsentencetype = 2 
getnatadtopull (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:35:34.034
SELECT *
FROM natadoptions 
WHERE 'hianchor' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:35:34.034
SELECT *
FROM natadoptions 
WHERE natadtypeid = 5 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 07:35:34.034
SELECT resourceid,  natanchorlink as adcode,natanchorlinkweight, natads.natadid
FROM natads, natadPlacement
WHERE natanchorlinktype = 5
and natadPlacement.networkID = 58
and natadPlacement.natadid = natads.natadid
and natanchorlinkend > "2020-05-27"
and natanchorlinkstart < "2020-05-28"
and natanchorstatus = 'live'

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

    ORDER by allreports.answerid desc
    
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 07:35:34.034
SELECT *
FROM topics
WHERE topicid = 7 
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 07:35:34.034
	SELECT summary as answer
	FROM answers
	WHERE answerid = 77305 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 07:35:34.034
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 77305 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 07:35:34.034
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 77305 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 07:35:34.034
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '58'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 07:35:34.034
	SELECT summary as answer
	FROM answers
	WHERE answerid = 76837 
getbrief (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 07:35:34.034
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 76837 
	AND answerstext.qid = 409
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 07:35:34.034
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 76837 
getphoto (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 07:35:34.034
	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 58
	and fbimg <> ''
	
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 07:35:34.034
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 76837 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 07:35:34.034
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '58'
checkbabyfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 07:35:34.034
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
      
         and networkid = 58 
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 07:35:34.034
		Select summary, hiimg 
		FROM answers
         where answerid = 75930
         and summary <> ''
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd_readnext.cfm @ 07:35:34.034
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5377 
gettaxgeneral (Datasource=expert, Time=5ms, Records=5) in /home/www/html/lib_rd_readnext.cfm @ 07:35:34.034
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 58 
	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 <> 5377
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-28"

    ORDER by articles.articleID desc
    
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 07:35:34.034
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-05-27"
    and fromDate < "2020-05-28"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 07:35:34.034
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 07:35:34.034
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-05-27 07:35:34'}
    and fromDate <{ts '2020-05-28 07:35:34'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 07:35:34.034
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 07:35:34.034
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 5377 
  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 @ 07:35:34.034
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5377 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 07:35:34.034
	SELECT summary as answer
	FROM answers
	WHERE answerid = 77305 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 07:35:34.034
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 77305 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 07:35:34.034
	SELECT summary as answer
	FROM answers
	WHERE answerid = 76837 
getbrief (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 07:35:34.034
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 76837 
	AND answerstext.qid = 409
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 07:35:34.034
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 76837 
getphoto (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 07:35:34.034
	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 58
	and fbimg <> ''
	
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 07:35:34.034
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 7 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcarepc.cfm @ 07:35:34.034
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 76837 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 07:35:34.034
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '58'
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 07:35:34.034
		Select summary, hiimg 
		FROM answers
         where answerid = 75930
         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=5377&networkid=58
REMOTE_ADDR=173.245.54.25
REMOTE_HOST=173.245.54.25
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=28570845
cftoken=66637189
sessionid=IBEXPATEXCHANGE.COM_28570845_66637189
urltoken=CFID=28570845&CFTOKEN=66637189
URL Parameters:
articleID=5377
networkid=58
Debug Rendering Time: 10 ms