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

Healthcare in Costa Rica > Cortez, Costa Rica

Expat Health Insurance and Healthcare in Cortez, Costa Rica

Add to Favorites (1 Favorites)

An expat in Costa Rica enjoys the low cost of healthcare (a fraction of the cost in the US) and is impressed with the new CAJA Hospital de Osa in Cortez. He offers advice about how an expat qualifies for the public healthcare system (CAJA).

Expat-Health-Insurance-and-Healthcare

Expat Healthcare Advice for Cortez

Costa Rica has excellent medical care with a two prong system, both public and private. All legal residents and citizens of Costa Rica are eligible to participate in the public healthcare system which is basically free although you have to be a member of the CAJA and pay a % based on the income level you declared when you applied for residency. A tip for expats is to show evidence of enough income to qualify for their residency programs but perhaps not to show all your income if not needed to qualify. (You have to show proof of a pension, annuity or government program that pays you at least $1000 per couple to qualify for their pensionado program). If you don't qualify by those means, you can also apply as a rentista, (renter), an inversionista (an investor) or as a foreign sponsored national with a work visa. You can also marry a Costa Rican... Keep in mind that there is also a private healthcare network available, which is often the preferred option to many expats. There is often a waiting time to get seen under the public system, even things like lab work might take longer than you want to wait. The private healthcare system is generally available immediately and insurance can be purchased to cover you in those facilities. You can also often offer to pay at the CAJA and be seen quicker than those not paying for service. In an emegency, the CAJA will take anyone. Costa Rica uses a local clinic methodology where they locate clinics nearly everywhere based on population needs. These clinics are referred to as the EBAIS clinics and can be found in nearly every town of any size. Major operations, whether in the public or private healthcare system, will likely be performed in San Jose. The private healthcare networks consisting of Clinica Biblica, CIMA and Hospital Mexico, offer great service for a fraction of the cost in the US. Clinica Biblica has an international medicine center, assigns patients a health navigator to help with things like language barriers and offers services that may not even be available in the states. I have had nothing but great experiences there, everything from blood work, orthapedics, dentistry, colonoscopy, endoscopy, stress test and EKG, bone density scans, lipids exams, urinalysis, hearing and eye tests, ultrasounds and more. I have stuff done that I could never afford to do in the states and pay a fraction of the cost I would in the US. The facilities are all impeccably clean and the doctors don't seem to be afraid of their patients and lawsuits. In our area in the southern Pacific region of Costa Rica, we have one of the newest CAJA hospitals in all of Costa Rica. The Hospital de Osa is an 88 bed, 80,000 square foot facility complete with emergency room, pharmacy and more. I recommend everyone should try the Costa Rican healthcare system to see what we are missing in the US.

Emergency Medical Care in Cortez

We are located almost across the highway from the Hospital de Osa in Cortez. It is a public hospital, 80,000 square feet and offers everything we need for the entire region.

Expat Health Insurance in Costa Rica

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

In Costa Rica I almost always go to San Jose for specialist care...

Prescription Medicines

Prescriptions are easy to get and easy to fill. Many drugs requiring a perscription in the US don't need one in Costa Rica. I have found that most drugs are 1/3 to 1/4 of the price than in the US.

Expats living in Costa Rica 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 Costa Rica 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 Costa Rica

Amazingly inexpensive. My personal experience with costs without insurance include a colonoscopy that was quoted at $3300 in the states that was done in Costa Rica for $300. I have a number of crowns in my mouth that I paid $300 to $400 including the root canal and crown.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Expats-in-Costa-RicaHealthcare in Costa Rica

Costa Rica is has both public and private healthcare systems. When you become a resident, you must enroll in the public healthcare system (CAJA). Many expats use the public system for routine healthcare and have private expat health insurance for specialists, surgeries and emergencies.

Costa Rica is has both public and private healthcare systems. When you become a resident, you must enroll in the public healthcare system (CAJA). Many expats use the public system for routine health...

Expat-Costa-Rica8 Things to Know Before Having a Baby in Costa Rica

Expats discuss their experiences giving birth in Costa Rica. Topics covered include public (CAJA) hospitals vs. private hospitals,high C-section rates, maternity coverage, dual citizenship, permanent residency for expat parents with babies born in Costa Rica, baby stores and formula options.

Expats discuss their experiences giving birth in Costa Rica. Topics covered include public (CAJA) hospitals vs. private hospitals,high C-section rates, maternity coverage, dual citizenship, permanent...

costa-rica Healthcare FAQCosta Rica Healthcare FAQ

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

costa-rica Healthcare InfoCosta Rica Healthcare Info

Additional information about healthcare and health insurance for foreigners in Costa Rica.

expat healthcare surveyAnswer Questions about Healthcare in Costa Rica

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

Having-a-Baby-In-San-JoseHaving a Baby in San Jose, Costa Rica

An expat mom in Costa Rica talks about her experiences finding a doctor, at the hospital, during childbirth and more.

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 Costa Rica from our partner, Cigna Global Health.
Get a Quote

Healthcare-in-Costa-RicaHealthcare in Costa Rica

Costa Rica is has both public and private healthcare systems. When you become a resident, you must enroll in the public healthcare system (CAJA). Many expats use the public system for routine healthcare and have private expat health insurance for specialists, surgeries and emergencies.

Costa Rica is has both public and private healthcare systems. When you become a resident, you must enroll in the public healthcare system (CAJA). Many expats use the public system for routine health...

8-Things-to-Know-Before-Having-a-Baby-in-Costa-Rica8 Things to Know Before Having a Baby in Costa Rica

Expats discuss their experiences giving birth in Costa Rica. Topics covered include public (CAJA) hospitals vs. private hospitals,high C-section rates, maternity coverage, dual citizenship, permanent residency for expat parents with babies born in Costa Rica, baby stores and formula options.

Expats discuss their experiences giving birth in Costa Rica. Topics covered include public (CAJA) hospitals vs. private hospitals,high C-section rates, maternity coverage, dual citizenship, permanent...

costa-rica healthcare faqCosta Rica Healthcare FAQ

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

costa-rica healthcare infoCosta Rica Healthcare Info

Additional information about healthcare and health insurance for foreigners in Costa Rica.

healthcare surveyAnswer Questions about Healthcare in Costa Rica

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

Having-a-Baby-In-San-JoseHaving a Baby in San Jose, Costa Rica

An expat mom in Costa Rica talks about her experiences finding a doctor, at the hospital, during childbirth and more.

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

Costa Rica 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 06-Jun-20 09:39 PM
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
326 ms 326 ms 1 /home/www/html/eetr/tip.cfm
290 ms 290 ms 1 /home/www/html/eetr/Application.cfm
110 ms 110 ms 1 /home/www/html/navtop_rdesign5.cfm
101 ms 101 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
40 ms 40 ms 1 /home/www/html/navcontentboxhealthcaremobile.cfm
18 ms 18 ms 1 /home/www/html/eetr/tiphealthcare.cfm
10 ms 10 ms 1 /home/www/html/eetr/navgettiplink.cfm
9 ms 5 ms 2 /home/www/html/eetr/rewritetipheadingstate.cfm
7 ms 7 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/navcontentboxhealthcarepc.cfm
5 ms 5 ms 1 /home/www/html/navleader_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
3 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
1 ms 1 ms 1 /home/www/html/eetr/constants.cfm
0 ms 0 ms 1 /home/www/html/boolsearch.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/eetr/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 7 /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/navinjection.cfm
0 ms 0 ms 4 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereport.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 @ 21:39:19.019
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=288ms, Records=1) in /home/www/html/eetr/Application.cfm @ 21:39:19.019
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=0ms, Records=153, Cached Query) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:39:19.019
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=1ms, Records=9) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:39:19.019
	Select *
	From citynetworks
	Where networkID = 33
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:39:19.019
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 33 
getpropertycountries (Datasource=tipripper, Time=43ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:39:19.019
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=32ms, Records=12) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:39:19.019
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 @ 21:39:19.019
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 = 77180 
and sitecategories.tipcategoryid = allreports.tipcategoryid
GetClassified (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:39:19.019
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 = 77180
and allreports.statenetworkid = Networks.networkid
and allreports.citynetworkid = citynetworks.citynetworkid
GetClassified (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:39:19.019
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 = 77180 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:39:19.019
SELECT *
FROM topics

WHERE topicid = 7 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/navgettiplink.cfm @ 21:39:19.019
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '33'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/navgettiplink.cfm @ 21:39:19.019
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '33'
getlocationtag3 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/navgettiplink.cfm @ 21:39:19.019
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '957'
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 21:39:19.019
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '77180'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 21:39:19.019
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '77180'
	and qid = 391
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:39:19.019
	SELECT DISTINCT hpimg as photo, fbimg
	FROM answers
	WHERE answerid = 77180 
getsummary (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:39:19.019
	SELECT DISTINCT summary
	FROM answers
	WHERE answerid = 77180 
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:39:19.019
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 77180 
	AND answerstext.qid = 409
	
getsummary (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:39:19.019
	SELECT summary 
	FROM answers
	WHERE answerid = 77180 
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:39:19.019
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '77180'
	and qid = 391
	
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 21:39:20.020
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.143'
and logtime > "2020-03-07"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 21:39:20.020
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.143'
and logtime > "2020-06-06 00:00:00.000"
and logtime < "2020-06-06 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 @ 21:39:20.020
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.143'
and logtime > "2020-05-30"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 21:39:20.020
	SELECT *
	From contentcountcountry
	Where networkid = 33 
gettopbanner (Datasource=expert, Time=2ms, Records=0) in /home/www/html/navleader_rdesign5.cfm @ 21:39:20.020
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-06-05"
    and fromDate < "2020-06-06"
gettopbanner (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 21:39:20.020
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-06-05"
    and fromDate < "2020-06-06"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 21:39:20.020
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getpropertycountries (Datasource=tipripper, Time=25ms, Records=130) in /home/www/html/eetr/tip.cfm @ 21:39:20.020
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=10) in /home/www/html/eetr/tip.cfm @ 21:39:20.020
SELECT allreports.tipcategory, allreports.tipcategoryid, topicid
FROM allreports
WHERE rid = 100
AND allreports.networkid = 33
group by allreports.tipcategoryid 
CheckTrackings (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tip.cfm @ 21:39:20.020
  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 = 77180
  and t.tpcid = 77180
  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 @ 21:39:20.020
SELECT *
FROM topics
WHERE topicid = 7 
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tip.cfm @ 21:39:20.020
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 77180
	AND answerstext.qid = 391
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tip.cfm @ 21:39:20.020
SELECT userphoto, tipcount, username, aboutme 
FROM users
WHERE userid = 23029 
GetUserProfile (Datasource=forum, Time=109ms, Records=1) in /home/www/html/eetr/tip.cfm @ 21:39:20.020
  SELECT *
  FROM userprofiles
  WHERE userid = 23029 
getbrief (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tip.cfm @ 21:39:20.020
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 77180
	AND answerstext.qid = 392
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tip.cfm @ 21:39:20.020
	SELECT DISTINCT hpimg as photo, tiplibraried, hpimg
	FROM answers
	WHERE answerid = 77180 
getcategory (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tip.cfm @ 21:39:20.020
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 77180
	AND answerstext.qid = 390
getmostpostsreply (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tip.cfm @ 21:39:20.020
  SELECT msgtext, m.msgdate as commentdate, msgid, userid
  FROM comments m 
  WHERE m.tpcid = 77180
  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 @ 21:39:20.020
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 = '77180'
getmc302 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tiphealthcare.cfm @ 21:39:20.020
SELECT *FROM qoptions, answersmc WHERE 302 = qoptions.qidand answersmc.qoid = qoptions.qoidand answersmc.qid = 302and answersmc.answerid = '77180'
getmcoptions407 (Datasource=tipripper, Time=1ms, Records=5) in /home/www/html/eetr/tiphealthcare.cfm @ 21:39:20.020
SELECT *FROM qoptions WHERE 407 = qoptions.qidorder by qorder
getmc407 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tiphealthcare.cfm @ 21:39:20.020
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 = '77180'
getmcoptions408 (Datasource=tipripper, Time=1ms, Records=5) in /home/www/html/eetr/tiphealthcare.cfm @ 21:39:20.020
SELECT *FROM qoptions WHERE 408 = qoptions.qidorder by qorder
getmc408 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tiphealthcare.cfm @ 21:39:20.020
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 = '77180'
getmcoptions406 (Datasource=tipripper, Time=1ms, Records=5) in /home/www/html/eetr/tiphealthcare.cfm @ 21:39:20.020
SELECT *FROM qoptions WHERE 406 = qoptions.qidorder by qorder
getmc406 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tiphealthcare.cfm @ 21:39:20.020
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 = '77180'
getanswerstext (Datasource=tipripper, Time=5ms, Records=5) in /home/www/html/eetr/tiphealthcare.cfm @ 21:39:20.020
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 = 77180AND (100 = answers.rid or 99 = answers.rid)AND topicquestions.topicid = answers.topicidAND topicquestions.qid = questions.qidAND topicquestions.qid = answerstext.qidAND 77180 = 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 @ 21:39:20.020
SELECT topicquestions.question, answerstext.answerFROM answerstext, topicquestions, answersWHERE answerstext.answerid = 77180AND topicquestions.topicid = answers.topicidAND answers.answerid = 77180GROUP BY answerstext.aidORDER BY topicquestions.order ASC
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tiphealthcare.cfm @ 21:39:20.020
	SELECT *	FROM markers	WHERE answerid = '77180'	and lat <> ''	and lng <> ''
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:39:20.020
SELECT *
FROM natadoptions 
WHERE 'hiheader' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:39:20.020
	Select *
	From Networks
	Where networkid = 33 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:39:20.020
SELECT *
FROM natadoptions 
WHERE natadtypeid = 1 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:39:20.020
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 1
and natadPlacement.networkID = 33
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-06-05"
and headerparagraphstart < "2020-06-06"
and headerparagraphstatus = 'live'

and (headerparagraphweight = 'medium' or headerparagraphweight = 'high')
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:39:20.020
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:39:20.020
	Select *
	From Networks
	Where networkid = 33 
getnatadtype (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:39:20.020
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:39:20.020
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 33
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-06-05"
and natsentencestart < "2020-06-06"
and natsentencestatus = 'live'

and (natsentenceweight = 'medium' or natsentenceweight = 'high')
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:39:20.020
SELECT resourceid, natsentence as adcode, natsentenceweight, natadid
FROM natads 
WHERE natadid = 1
and natsentencetype = 2 
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 33 
	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-06-06"
     ORDER by articles.sectionintro DESC, articles.articleID desc 
 
gethospitals (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 33 
		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-06-06"
     ORDER by articles.title
 
GetClassifieds (Datasource=tipripper, Time=11ms, Records=3) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
SELECT *
FROM allreports, Networks, answers
WHERE allreports.rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 7
and hide <> 'y'
and allreports.networkid = 33 
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 @ 21:39:20.020
SELECT *
FROM topics
WHERE topicid = 7 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79756 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79756 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 79756 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '33'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79639 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79639 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 79639 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '33'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79257 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79257 
getphotos (Datasource=reports, Time=1ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 79257 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '33'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79756 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79756 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 79756 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '33'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79639 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79639 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 79639 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '33'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79257 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79257 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 79257 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '33'
checkbabyfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
      
         and networkid = 33 
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:39:20.020
		Select summary, hiimg 
		FROM answers
         where answerid = 25251
         and summary <> ''
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:39:20.020
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79756 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:39:20.020
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79756 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:39:20.020
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79639 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:39:20.020
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79639 
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:39:20.020
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79257 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:39:20.020
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79257 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:39:20.020
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79756 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:39:20.020
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79756 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:39:20.020
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79639 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:39:20.020
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79639 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:39:20.020
	SELECT summary as answer
	FROM answers
	WHERE answerid = 79257 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:39:20.020
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 79257 
checkbabyfeature (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:39:20.020
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
      
         and networkid = 33 
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=0) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:39:20.020
		Select summary, hiimg 
		FROM answers
         where answerid = 25251
         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=77180&networkid=33&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=29124364
cftoken=41355061
hitcount=1
lastvisit={ts '2020-06-06 21:39:19'}
timecreated={ts '2020-06-06 21:39:19'}
urltoken=CFID=29124364&CFTOKEN=41355061
Cookie Variables:
CFID=29124364
CFTOKEN=41355061
Session Variables:
cfid=29124364
cftoken=41355061
sessionid=IBEXPATEXCHANGE_29124364_41355061
urltoken=CFID=29124364&CFTOKEN=41355061
URL Parameters:
answerid=77180
networkid=33
topicid=7
Debug Rendering Time: 11 ms