Home Argentina Forum Argentina Guide Argentina Resources Real Estate Healthcare in Argentina
Argentina
Resources
City Guides
JoinSign In
AGS Worldwide Movers

Healthcare in Argentina > Expat Health Insurance & Healthcare Guide to Argentina

Expat Health Insurance & Healthcare Guide to Argentina

Expats share their experiences with healthcare and expat health insurance in Argentina.

Share Your Healthcare Experiences Share Your Childbirth Experiences
Expat Health Insurance & Medical Care

Expat Health Insurance and Healthcare in Mendoza, Argentina

Expat-Health-Insurance-and-Healthcare

An expat in Mendoza, Argentina has had very good experiences with local doctors and Clinica de Cuyo downtown. She warns that some prescription medicines may not be available since the government severely restricts imports. For example, she knows a cancer patient who had to go to numerous pharmacies and wait weeks for a medication.

Submitted By

MendocinaMendocina
expat health insurance from CIGNA

Choosing an expat health insurance provider is an important decision. Get a quote from our trusted expat health insurance partner, CIGNA. With Cigna Global Health Options, you can create an international health insurance plan that's perfectly tailored for the needs of you and your family.

Learn More Get a Quote

Expat Health Insurance & Medical Care

Expat Health Insurance and Healthcare in Mendoza, Argentina

Expat-Health-Insurance-and-Healthcare

An expat talks about health care and health insurance in Mendoza. He advises that the government does not offer medical insurance to senior citizens. Also, he says that prescriptions cost about the same as in the United States.

Submitted By

TomPTomP

Having a Baby in Buenos Aires, Argentina

Having-a-Baby-In-Buenos-Aires

We had our baby in a Sanatorio in Buenos Aires. It was a wonderfull experience. I chose a healthcare team that really made me feel cared for. I felt I was in good hands since the moment we interviewed the obstetrician. When we arrived to the sanatorio the anesthesiologist was waiting for me. I got the epidural right away. The parteras where really nice and tried to comfort me.

Having a Baby in Buenos Aires, Argentina

Having-a-Baby-In-Buenos-Aires

I have private insurance with Medicus, one of the top insurance companies here. I had to take it two months prior to getting pregnant to be fully covered. We are paying 168 US or 535 pesos per month.

I was recommended to a obstetrician who specializes in C-sections. I've had only one visit with him, but he made sure to give me his cell phone. I've already had to use it when I had some slight issues. I was able to reach him on a Sunday night, and after a phone consultation, he sent me to the local "sanitario" which admitted me immediately for an ultrasound. I received excellent care and was amazed to be able to get not only my doctor, but actually to have him call and prep the doctor on staff at the sanitario.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Healthcare in MendozaHealthcare in Mendoza, Argentina

An expat talks about health care and health insurance in Mendoza. He advises that the government does not offer medical insurance to senior citizens. Also, he says that prescriptions cost about the s

Healthcare in MendozaHealthcare in Mendoza, Argentina

An expat in Mendoza, Argentina has had very good experiences with local doctors and Clinica de Cuyo downtown. She warns that some prescription medicines may not be available since the government sever

expat healthcare surveyAnswer Questions about Healthcare in Argentina

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

Having-a-Baby-In-ArgentinaExpats Talk about What it's Like Having a Baby in Argentina

Read recent baby reports submitted for Buenos Aires and Buenos Aires.

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

Cigna Expat Health InsuranceExpatriate Health Insurance

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

healthcare in MendozaHealthcare in Mendoza, Argentina

An expat talks about health care and health insurance in Mendoza. He advises that the government does not offer medical insurance to senior citizens. Also, he says that prescriptions cost about the s -

healthcare in MendozaHealthcare in Mendoza, Argentina

An expat in Mendoza, Argentina has had very good experiences with local doctors and Clinica de Cuyo downtown. She warns that some prescription medicines may not be available since the government sever -

healthcare surveyAnswer Questions about Healthcare in Argentina

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

Having-a-Baby-In-ArgentinaExpats Talk about What it's Like Having a Baby in Argentina

Read recent baby reports submitted for Buenos Aires and Buenos Aires.

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

Argentina 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/tips.cfm
Time Stamp 04-Jun-20 09:06 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.127
Host Name 172.69.63.127


Execution Time

Total Time Avg Time Count Template
292 ms 292 ms 1 /home/www/html/eetr/Application.cfm
207 ms 207 ms 1 top level /home/www/html/eetr/tips.cfm
98 ms 98 ms 1 /home/www/html/navtop_rdesign5.cfm
90 ms 90 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
30 ms 30 ms 1 /home/www/html/navcontentboxhealthcaremobile.cfm
21 ms 11 ms 2 /home/www/html/eetr/tipshealthcare.cfm
16 ms 4 ms 4 /home/www/html/eetr/rewritetipheadingstate.cfm
16 ms 16 ms 1 /home/www/html/eetr/tipshealthcarebaby.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navcontentboxhealthcarepc.cfm
2 ms 2 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/eetr/constants.cfm
1 ms 1 ms 1 /home/www/html/eetr/tippaginglinkmaker.cfm
1 ms 1 ms 1 /home/www/html/eetr/tippagingnew.cfm
1 ms 1 ms 1 /home/www/html/nativerotationtop_tester13.cfm
0 ms 0 ms 1 /home/www/html/boolsearch.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 1 /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 4 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/eetr/tippagingnewduplicate.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 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 4 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereport.cfm
0 ms 0 ms 2 /home/www/html/rewritereportscountry.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
500 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:06:29.029
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=290ms, Records=1) in /home/www/html/eetr/Application.cfm @ 21:06:29.029
      	  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:06:29.029
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=1ms, Records=4) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:06:29.029
	Select *
	From citynetworks
	Where networkID = 15
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:06:29.029
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 15 
getpropertycountries (Datasource=tipripper, Time=44ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:06:29.029
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 @ 21:06:30.030
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 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:06:30.030
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.promophoto600, topics.tipstemplate
FROM topics

WHERE topicid = 7 
getname (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:06:30.030
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 15 
GetClassifieds (Datasource=tipripper, Time=6ms, Records=2) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:06:30.030
SELECT Networks.networkname, allreports.networkid, shortname, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allreports.allowcomments, allreports.citynetworkid, allreports.citynetworkid2, allreports.statenetworkid, allreports.city, sitecategories.categoryslug, sitecategories.headingnav, allreports.topicid, allreports.state, allreports.networkname, allreports.enddate, allreports.networkname as country
FROM allreports, sitecategories, Networks
WHERE allreports.rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and hide <> 'y'
and sitecategories.siteid = 3
and allreports.tipcategoryid <> 2797

and allreports.topicid = 7 
AND Networks.networkid = 15 
AND allreports.networkid = 15 
and allreports.tipcategoryid <> 2791

order by allreports.enddate DESC
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:06:30.030
SELECT *
FROM topics

WHERE topicid = 7 
gettopic (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:06:30.030
SELECT *
FROM topics

WHERE topicid = 7 
getcountryphoto (Datasource=expert, Time=1ms, Records=12) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:06:30.030
SELECT *
FROM countryphotos
WHERE networkid = 15 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 21:06:30.030
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-03-05"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 21:06:30.030
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-06-04 00:00:00.000"
and logtime < "2020-06-04 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:06:30.030
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-05-28"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 21:06:30.030
	SELECT *
	From contentcountcountry
	Where networkid = 15 
gettopbanner (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 21:06:30.030
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-06-03"
    and fromDate < "2020-06-04"
    and bannerPlacement.networkid = 15
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 21:06:30.030
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
getcount (Datasource=tipripper, Time=1ms, Records=36) in /home/www/html/eetr/tips.cfm @ 21:06:30.030
SELECT answerid
FROM allreports, sitecategories
WHERE rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
and networkid = 15 
order by city ASC, answerid DESC
gethealthintro (Datasource=expert, Time=5ms, Records=0) in /home/www/html/eetr/tips.cfm @ 21:06:30.030
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 15 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
    and sectionintro = 'y'
   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-04"

    ORDER by articles.articleID asc   
    
getname (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tippaginglinkmaker.cfm @ 21:06:30.030
	Select *
	From Networks
	Where networkid = 15 
gettaxgeneral (Datasource=expert, Time=5ms, Records=0) in /home/www/html/eetr/tips.cfm @ 21:06:30.030
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, fbimg
	From articles, articleCategories, articlePlacement
	Where hitopic <> ''
    and hidescript <> ''
    and type = '3'
    and articles.hihp <> 'n'
    and articles.hinet <> 'n'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
        and summary <> ''
    and publishdate < "2020-06-04"
    and articleCategories.articleID = articles.articleID
    and articlePlacement.articleID = articles.articleID
    and articlePlacement.networkID = 15
    and articleCategories.section = 9
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    ORDER by publishdate desc
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:06:30.030
SELECT *
FROM users
WHERE userid = '55570'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:06:30.030
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '15'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:06:30.030
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '15'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:06:30.030
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '4278'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:06:30.030
	SELECT summary 
	FROM answers
	WHERE answerid = 65959 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:06:30.030
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 65959 
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 21:06:30.030
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65959'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 21:06:30.030
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65959'
	and qid = 391
	
gettext402 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 21:06:30.030
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '65959'	and qid = 402
gettext401 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 21:06:30.030
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '65959'	and qid = 401
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipshealthcare.cfm @ 21:06:30.030
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = 65959	AND answerstext.qid = 391
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:06:30.030
SELECT *
FROM natadoptions 
WHERE 'hibox' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:06:30.030
	Select *
	From Networks
	Where networkid = 15 
getnatadtype (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:06:30.030
SELECT *
FROM natadoptions 
WHERE natadtypeid = 4 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:06:30.030
SELECT resourceid, natbox as adcode, natboxweight, natads.natadid
FROM natads, natadPlacement
WHERE natboxtype = 4
and natadPlacement.networkID = 15
and natadPlacement.natadid = natads.natadid
and natboxend > "2020-06-03"
and natboxstart < "2020-06-04"
and natboxstatus = 'live'

and natboxweight = 'high'
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:06:30.030
SELECT *
FROM users
WHERE userid = '32321'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:06:30.030
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '15'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:06:30.030
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '15'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:06:30.030
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '4278'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:06:30.030
	SELECT summary 
	FROM answers
	WHERE answerid = 65921 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:06:30.030
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 65921 
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 21:06:30.030
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65921'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 21:06:30.030
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65921'
	and qid = 391
	
gettext402 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 21:06:30.030
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '65921'	and qid = 402
gettext401 (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 21:06:30.030
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '65921'	and qid = 401
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipshealthcare.cfm @ 21:06:30.030
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = 65921	AND answerstext.qid = 391
checkbaby (Datasource=expert, Time=5ms, Records=2) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 21:06:30.030
SELECT networkname as ctry, city, networkid, rid, answerid, networkname, userid
FROM allreports
WHERE rid = 88
and networkid = 15
GROUP BY answerid
ORDER BY answerid desc
editorsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 21:06:30.030
SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 21332 
getsummary (Datasource=reports, Time=4ms, Records=1) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 21:06:30.030
SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 21332
AND answerstext.qid = 304
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 21:06:30.030
SELECT DISTINCT summary, fbimg, hiimg
FROM answers 
WHERE answers.answerid = 21332 
getcountryphotos (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 21:06:30.030
	SELECT DISTINCT hiimg
	FROM countryphotos
	WHERE networkid = 15
	and hiimg <> ''
	
editorsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 21:06:30.030
SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 11319 
getsummary (Datasource=reports, Time=4ms, Records=1) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 21:06:30.030
SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 11319
AND answerstext.qid = 304
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 21:06:30.030
SELECT DISTINCT summary, fbimg, hiimg
FROM answers 
WHERE answers.answerid = 11319 
getcountryphotos (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 21:06:30.030
	SELECT DISTINCT hiimg
	FROM countryphotos
	WHERE networkid = 15
	and hiimg <> ''
	
gettaxgeneral2 (Datasource=expert, Time=4ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:06:30.030
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 15 
	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-04"
     ORDER by articles.sectionintro DESC, articles.articleID desc 
 
gethospitals (Datasource=expert, Time=4ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:06:30.030
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 15 
		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-04"
     ORDER by articles.title
 
GetClassifieds (Datasource=tipripper, Time=9ms, Records=2) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:06:30.030
SELECT *
FROM allreports, Networks, answers
WHERE allreports.rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 7
and hide <> 'y'
and allreports.networkid = 15 
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 @ 21:06:30.030
SELECT *
FROM topics
WHERE topicid = 7 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:06:30.030
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65921 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:06:30.030
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65921 
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:06:30.030
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65921 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:06:30.030
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '15'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:06:30.030
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65959 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:06:30.030
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65959 
getphotos (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:06:30.030
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65959 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:06:30.030
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '15'
checkbabyfeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:06:30.030
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
      
         and networkid = 15 
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 21:06:30.030
		Select summary, hiimg 
		FROM answers
         where answerid = 21332
         and summary <> ''
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:06:30.030
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65921 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:06:30.030
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65921 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:06:30.030
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65959 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:06:30.030
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65959 
getsummary (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcarepc.cfm @ 21:06:30.030
		Select summary, hiimg 
		FROM answers
         where answerid = 21332
         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/tips.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/tips.cfm
QUERY_STRING=topicid=7&tipcategoryid=0&networkid=15&s=1&sort=r&slug=healthcare-in&slug2=argentina
REMOTE_ADDR=172.69.63.127
REMOTE_HOST=172.69.63.127
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/eetr/tips.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=29016116
cftoken=17120312
hitcount=1
lastvisit={ts '2020-06-04 21:06:29'}
timecreated={ts '2020-06-04 21:06:29'}
urltoken=CFID=29016116&CFTOKEN=17120312
Cookie Variables:
CFID=29016116
CFTOKEN=17120312
Session Variables:
cfid=29016116
cftoken=17120312
sessionid=IBEXPATEXCHANGE_29016116_17120312
urltoken=CFID=29016116&CFTOKEN=17120312
URL Parameters:
networkid=15
s=1
slug=healthcare-in
slug2=argentina
sort=r
tipcategoryid=0
topicid=7
Debug Rendering Time: 11 ms