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

Healthcare in Spain > Madrid, Spain

Expat Health Insurance and Healthcare in Madrid, Spain

Add to Favorites (0 Favorites)

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-Health-Insurance-and-Healthcare

Expat Healthcare Advice for Madrid

Try to find someone who speaks your language or have an interpreter.

Emergency Medical Care in Madrid

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.

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 Healthcare in Surrounding Area

HM has many specialists here. I am i a serious situation now and all the doctors are working as a team.

Prescription Medicines

All of my medicines are available here. Often much lower in cost than the US. I take Advair 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.

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.

Expat Health Insurance in Spain

Buyer beware. The US insurance company I have is trying to find every reason to not pay for my surgery. They are trying to find an exclusion for everything. I will switch companies as soon as possible.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Expats-in-Spain7 Important Tips about Healthcare for Expats in Spain

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

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

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

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.

Comments & Questions

Sign In or Sign Up to reply

Cigna Expat Health InsuranceExpatriate Health Insurance

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

7-Important-Tips-about-Healthcare7 Important Tips about Healthcare for Expats in Spain

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

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

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 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 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 /eetr/tip.cfm
Time Stamp 30-May-20 05:42 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
319 ms 319 ms 1 /home/www/html/eetr/tip.cfm
297 ms 297 ms 1 /home/www/html/eetr/Application.cfm
109 ms 109 ms 1 /home/www/html/navtop_rdesign5.cfm
103 ms 103 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
34 ms 34 ms 1 /home/www/html/navcontentboxhealthcaremobile.cfm
18 ms 18 ms 1 /home/www/html/eetr/tiphealthcare.cfm
9 ms 9 ms 1 /home/www/html/eetr/navgettiplink.cfm
6 ms 3 ms 2 /home/www/html/eetr/rewritetipheadingstate.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
4 ms 4 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navcontentboxhealthcarepc.cfm
3 ms 3 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/eetr/constants.cfm
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.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/datasources.cfm
0 ms 0 ms 3 /home/www/html/eetr/navconstants.cfm
0 ms 0 ms 2 /home/www/html/eetr/navinjection.cfm
0 ms 0 ms 1 /home/www/html/eetr/qry_GeneralSet.cfm
0 ms 0 ms 2 /home/www/html/eetr/rewritealtimage.cfm
0 ms 0 ms 3 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/navinjection.cfm
0 ms 0 ms 2 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereportscountry.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
616 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/eetr/qry_GeneralSet.cfm @ 05:42:28.028
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=295ms, Records=1) in /home/www/html/eetr/Application.cfm @ 05:42:28.028
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=3ms, Records=153) in /home/www/html/eetr/eetr_navmeta.cfm @ 05:42:28.028
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=1ms, Records=8) in /home/www/html/eetr/eetr_navmeta.cfm @ 05:42:28.028
	Select *
	From citynetworks
	Where networkID = 101
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 05:42:28.028
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 101 
getpropertycountries (Datasource=tipripper, Time=44ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 05:42:28.028
SELECT allreports.networkname, allreports.networkid, shortname, allreports.date
FROM allreports, Networks, sitecategories
WHERE rid = 100
and Networks.networkid = allreports.networkid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3
and allreports.hide <> 'y'

and allreports.tipcategoryid <> 2791

and allreports.tipcategoryid <> 2797
and allreports.networkid <> 159
group by allreports.networkid
order by allreports.networkname ASC
gettipcategories (Datasource=tipripper, Time=33ms, Records=12) in /home/www/html/eetr/eetr_navmeta.cfm @ 05:42:28.028
SELECT * 
FROM sitecategories, qoptions, allreports
WHERE qoptions.qoid = sitecategories.tipcategoryid
and qoptions.parent = 0
and allreports.hide <> 'y'
and sitecategories.siteid = 3
and sitecategories.tipcategoryid <> 2791
and sitecategories.tipcategoryid <> 2797
and sitecategories.tipcategoryid <> ''
and sitecategories.tipcategoryid <> 2793
and sitecategories.tipcategoryid <> 2792
and allreports.tipcategoryid = sitecategories.tipcategoryid
group by sitecategories.tipcategoryid 
GetClassifieds (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 05:42:28.028
SELECT allreports.networkname, allreports.networkid, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allowcomments, allreports.citynetworkid, allreports.citynetworkid2, sitecategories.categoryslug, allreports.statenetworkid, allreports.topicid, allreports.city, sitecategories.headingnav, allreports.topicid as topicid, allreports.state, allreports.rid
FROM allreports, sitecategories
WHERE allreports.answerid = 77274 
and sitecategories.tipcategoryid = allreports.tipcategoryid
GetClassified (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/eetr_navmeta.cfm @ 05:42:28.028
SELECT allreports.networkname, allreports.networkid, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allowcomments, Networks.networkid, Networks.shortname, Networks.networkname, citynetworks.shortname, allreports.citynetworkid, allreports.citynetworkid2, allreports.topicid as topicid, allreports.city, allreports.state, allreports.answerid, allreports.topicid 
FROM allreports, Networks, citynetworks
WHERE rid = 100
and allreports.answerid = 77274
and allreports.statenetworkid = Networks.networkid
and allreports.citynetworkid = citynetworks.citynetworkid
GetClassified (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 05:42:28.028
SELECT allreports.networkname, allreports.networkid, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allowcomments, allreports.citynetworkid, allreports.citynetworkid2, allreports.topicid as topicid, allreports.city, allreports.state, allreports.answerid, allreports.topicid 
FROM allreports
WHERE rid = 100
and allreports.answerid = 77274 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 05:42:28.028
SELECT *
FROM topics

WHERE topicid = 7 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/navgettiplink.cfm @ 05:42:28.028
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '101'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/navgettiplink.cfm @ 05:42:28.028
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '101'
getlocationtag3 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/navgettiplink.cfm @ 05:42:28.028
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '3'
getheading (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 05:42:28.028
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '77274'
	and qid = 391
	
getheading (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 05:42:28.028
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '77274'
	and qid = 391
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 05:42:28.028
	SELECT DISTINCT hpimg as photo, fbimg
	FROM answers
	WHERE answerid = 77274 
getsummary (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 05:42:28.028
	SELECT DISTINCT summary
	FROM answers
	WHERE answerid = 77274 
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 05:42:28.028
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 77274 
	AND answerstext.qid = 409
	
getsummary (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 05:42:28.028
	SELECT summary 
	FROM answers
	WHERE answerid = 77274 
getheading (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/eetr_navmeta.cfm @ 05:42:28.028
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '77274'
	and qid = 391
	
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 05:42:28.028
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.143'
and logtime > "2020-02-29"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 05:42:28.028
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.143'
and logtime > "2020-05-30 00:00:00.000"
and logtime < "2020-05-30 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 @ 05:42:28.028
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.143'
and logtime > "2020-05-23"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 05:42:28.028
	SELECT *
	From contentcountcountry
	Where networkid = 101 
gettopbanner (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 05:42:28.028
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 05:42:28.028
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 05:42:28.028
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getpropertycountries (Datasource=tipripper, Time=27ms, Records=130) in /home/www/html/eetr/tip.cfm @ 05:42:28.028
SELECT allreports.networkname, allreports.networkid, shortname, allreports.date
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = allreports.networkid
group by allreports.networkid
order by allreports.networkname ASC
gettipcategories (Datasource=tipripper, Time=1ms, Records=11) in /home/www/html/eetr/tip.cfm @ 05:42:28.028
SELECT allreports.tipcategory, allreports.tipcategoryid, topicid
FROM allreports
WHERE rid = 100
AND allreports.networkid = 101
group by allreports.tipcategoryid 
CheckTrackings (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tip.cfm @ 05:42:28.028
  SELECT t.tpcid, tk.tpcid as tpcid, tk.trackingdate, tk.trackingtype, tk.trackingid, tk.dbname, tk.shared, tk.userid
  FROM commenttrackings tk, comments t 
  WHERE tk.tpcid = 77274
  and t.tpcid = 77274
  and tk.commenttype = 9
  AND tk.trackingtype = "S"
  AND tk.userid = "2"
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tip.cfm @ 05:42:28.028
SELECT *
FROM topics
WHERE topicid = 7 
getheading (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tip.cfm @ 05:42:28.028
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 77274
	AND answerstext.qid = 391
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tip.cfm @ 05:42:28.028
SELECT userphoto, tipcount, username, aboutme 
FROM users
WHERE userid = 120767 
GetUserProfile (Datasource=forum, Time=111ms, Records=1) in /home/www/html/eetr/tip.cfm @ 05:42:28.028
  SELECT *
  FROM userprofiles
  WHERE userid = 120767 
getbrief (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tip.cfm @ 05:42:28.028
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 77274
	AND answerstext.qid = 392
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tip.cfm @ 05:42:28.028
	SELECT DISTINCT hpimg as photo, tiplibraried, hpimg
	FROM answers
	WHERE answerid = 77274 
getcategory (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tip.cfm @ 05:42:28.028
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 77274
	AND answerstext.qid = 390
getmostpostsreply (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tip.cfm @ 05:42:28.028
  SELECT msgtext, m.msgdate as commentdate, msgid, userid
  FROM comments m 
  WHERE m.tpcid = 77274
  and m.commenttype = 9
  and m.isapproved = 1
  ORDER BY m.msgid DESC
getmc47 (Datasource=tipripper, Time=1ms, Records=2) in /home/www/html/eetr/tiphealthcare.cfm @ 05:42:28.028
SELECT qoptions.value, topicquestions.question, answersmc.qoidFROM qoptions, answersmc, topicquestionsWHERE 47 = qoptions.qidand 47 = topicquestions.qidand answersmc.qoid = qoptions.qoidand answersmc.qid = 47and answersmc.answerid = '77274'
getmc302 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tiphealthcare.cfm @ 05:42:28.028
SELECT *FROM qoptions, answersmc WHERE 302 = qoptions.qidand answersmc.qoid = qoptions.qoidand answersmc.qid = 302and answersmc.answerid = '77274'
getmcoptions407 (Datasource=tipripper, Time=0ms, Records=5) in /home/www/html/eetr/tiphealthcare.cfm @ 05:42:28.028
SELECT *FROM qoptions WHERE 407 = qoptions.qidorder by qorder
getmc407 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tiphealthcare.cfm @ 05:42:28.028
SELECT qoptions.value, topicquestions.question, answersmc.qoid, topicquestions.outputtextFROM qoptions, answersmc, topicquestions WHERE 407 = qoptions.qidand 407 = topicquestions.qidand answersmc.qoid = qoptions.qoidand answersmc.qid = 407and answersmc.answerid = '77274'
getmcoptions408 (Datasource=tipripper, Time=0ms, Records=5) in /home/www/html/eetr/tiphealthcare.cfm @ 05:42:28.028
SELECT *FROM qoptions WHERE 408 = qoptions.qidorder by qorder
getmc408 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tiphealthcare.cfm @ 05:42:28.028
SELECT qoptions.value, topicquestions.question, answersmc.qoid, topicquestions.outputtextFROM qoptions, answersmc, topicquestionsWHERE 408 = qoptions.qidand 408 = topicquestions.qidand answersmc.qoid = qoptions.qoidand answersmc.qid = 408and answersmc.answerid = '77274'
getmcoptions406 (Datasource=tipripper, Time=0ms, Records=5) in /home/www/html/eetr/tiphealthcare.cfm @ 05:42:28.028
SELECT *FROM qoptions WHERE 406 = qoptions.qidorder by qorder
getmc406 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tiphealthcare.cfm @ 05:42:28.028
SELECT qoptions.value, topicquestions.question, answersmc.qoid, topicquestions.outputtextFROM qoptions, answersmc, topicquestionsWHERE 406 = qoptions.qidand 406 = topicquestions.qidand answersmc.qoid = qoptions.qoidand answersmc.qid = 406and answersmc.answerid = '77274'
getanswerstext (Datasource=tipripper, Time=5ms, Records=5) in /home/www/html/eetr/tiphealthcare.cfm @ 05:42:28.028
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderpropFROM answerstext, answers, topicquestions, questions WHERE answers.answerid = 77274AND (100 = answers.rid or 99 = answers.rid)AND topicquestions.topicid = answers.topicidAND topicquestions.qid = questions.qidAND topicquestions.qid = answerstext.qidAND 77274 = answerstext.answerid and topicquestions.qid <> 62and topicquestions.qid <> 391ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tiphealthcare.cfm @ 05:42:28.028
SELECT topicquestions.question, answerstext.answerFROM answerstext, topicquestions, answersWHERE answerstext.answerid = 77274AND topicquestions.topicid = answers.topicidAND answers.answerid = 77274GROUP BY answerstext.aidORDER BY topicquestions.order ASC
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tiphealthcare.cfm @ 05:42:28.028
	SELECT *	FROM markers	WHERE answerid = '77274'	and lat <> ''	and lng <> ''
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:42:28.028
SELECT *
FROM natadoptions 
WHERE 'hiheader' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:42:28.028
	Select *
	From Networks
	Where networkid = 101 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:42:28.028
SELECT *
FROM natadoptions 
WHERE natadtypeid = 1 
getnatadbottom (Datasource=expert, Time=0ms, Records=2) in /home/www/html/nativerotationtop_tester13.cfm @ 05:42:28.028
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-05-29"
and headerparagraphstart < "2020-05-30"
and headerparagraphstatus = 'live'

and (headerparagraphweight = 'medium' or headerparagraphweight = 'high')
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:42:28.028
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:42:28.028
	Select *
	From Networks
	Where networkid = 101 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:42:28.028
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=0ms, Records=2) in /home/www/html/nativerotationtop_tester13.cfm @ 05:42:28.028
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-05-29"
and natsentencestart < "2020-05-30"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:42:28.028
SELECT resourceid, natsentence as adcode, natsentenceweight, natadid
FROM natads 
WHERE natadid = 1
and natsentencetype = 2 
gettaxgeneral2 (Datasource=expert, Time=7ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 05:42:28.028
	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 hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-30"
     ORDER by articles.sectionintro DESC, articles.articleID desc 
 
gethospitals (Datasource=expert, Time=4ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 05:42:28.028
	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.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-30"
     ORDER by articles.title
 
GetClassifieds (Datasource=tipripper, Time=11ms, Records=2) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 05:42:28.028
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 asc   
    
getslugs (Datasource=tipripper, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 05:42:28.028
SELECT *
FROM topics
WHERE topicid = 7 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 05:42:28.028
	SELECT summary as answer
	FROM answers
	WHERE answerid = 77274 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 05:42:28.028
	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 @ 05:42:28.028
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 77274 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 05:42:28.028
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '101'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 05:42:28.028
	SELECT summary as answer
	FROM answers
	WHERE answerid = 78381 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 05:42:28.028
	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 @ 05:42:28.028
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 78381 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 05:42:28.028
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '101'
checkbabyfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 05:42:28.028
		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 @ 05:42:28.028
		Select summary, hiimg 
		FROM answers
         where answerid = 24457
         and summary <> ''
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 05:42:28.028
	SELECT summary as answer
	FROM answers
	WHERE answerid = 77274 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 05:42:28.028
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 77274 
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 05:42:28.028
	SELECT summary as answer
	FROM answers
	WHERE answerid = 78381 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 05:42:28.028
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 78381 
getsummary (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcarepc.cfm @ 05:42:28.028
		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/eetr/tip.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/eetr/tip.cfm
QUERY_STRING=answerid=77274&networkid=101&topicid=7
REMOTE_ADDR=172.69.63.143
REMOTE_HOST=172.69.63.143
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/eetr/tip.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Client Variables:
cfid=28682174
cftoken=96129270
hitcount=1
lastvisit={ts '2020-05-30 05:42:28'}
timecreated={ts '2020-05-30 05:42:28'}
urltoken=CFID=28682174&CFTOKEN=96129270
Cookie Variables:
CFID=28682174
CFTOKEN=96129270
Session Variables:
cfid=28682174
cftoken=96129270
sessionid=IBEXPATEXCHANGE_28682174_96129270
urltoken=CFID=28682174&CFTOKEN=96129270
URL Parameters:
answerid=77274
networkid=101
topicid=7
Debug Rendering Time: 11 ms