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

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

Expat Health Insurance & Healthcare Guide to Bulgaria

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

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

Expat Health Insurance and Healthcare in Ivaylovgrad, Bulgaria

Expat-Health-Insurance-and-Healthcare

An expat in Ivaylovgrad, Bulgaria offers some brief insights into the health care system and also advice on what to know and expect there.

Submitted By

EdislawEdislaw
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 Bulgaria

Expat-Health-Insurance-and-Healthcare

There are doctors clinics for general health issues that are easy to use as (for instance) if you need an ex-ray for a problem, it is done there within minutes and you then see the doctor again and the results and treatments are discussed. There is no need to book an appointment and the total cost of a visit such as this is approximately 40 Bulgarian Lev to include the ex-ray. Medication is then prescribed and it is very affordable compared with the UK.

Submitted By

staloneukstaloneuk

Cigna Expat Health InsuranceExpatriate Health Insurance

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

bulgaria Healthcare InfoBulgaria Healthcare Info

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

Healthcare in Healthcare in Bulgaria

There are doctors clinics for general health issues that are easy to use as (for instance) if you need an ex-ray for a problem, it is done there within minutes and you then see the doctor again and th

Healthcare in IvaylovgradHealthcare in Ivaylovgrad, Bulgaria

An expat in Ivaylovgrad, Bulgaria offers some brief insights into the health care system and also advice on what to know and expect there.

expat healthcare surveyAnswer Questions about Healthcare in Bulgaria

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

Having a Baby AbroadHaving a Baby Abroad Report

Being pregnant and giving birth abroad can be a bit unnerving. If you've had a baby abroad, please take a few minutes to answer a few questions about your experiences. Your insight will help to prepare other expat parents-to-be -- and hopefully calm their nerves.

Read Reports from Other Parents about their Childbirth experiences abroad.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

bulgaria healthcare infoBulgaria Healthcare Info

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

healthcare in Healthcare in Bulgaria

There are doctors clinics for general health issues that are easy to use as (for instance) if you need an ex-ray for a problem, it is done there within minutes and you then see the doctor again and th -

healthcare in IvaylovgradHealthcare in Ivaylovgrad, Bulgaria

An expat in Ivaylovgrad, Bulgaria offers some brief insights into the health care system and also advice on what to know and expect there. -

healthcare surveyAnswer Questions about Healthcare in Bulgaria

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

Having a Baby AbroadHaving a Baby Abroad Report

Being pregnant and giving birth abroad can be a bit unnerving. If you've had a baby abroad, please take a few minutes to answer a few questions about your experiences. Your insight will help to prepare other expat parents-to-be -- and hopefully calm their nerves.

Read Reports from Other Parents about their Childbirth experiences abroad.

Bulgaria 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 03-Jun-20 12:25 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.62.82
Host Name 172.69.62.82


Execution Time

Total Time Avg Time Count Template
295 ms 295 ms 1 /home/www/html/eetr/Application.cfm
208 ms 208 ms 1 top level /home/www/html/eetr/tips.cfm
101 ms 101 ms 1 /home/www/html/navtop_rdesign5.cfm
95 ms 95 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
27 ms 27 ms 1 /home/www/html/navcontentboxhealthcaremobile.cfm
21 ms 5 ms 4 /home/www/html/eetr/rewritetipheadingstate.cfm
21 ms 11 ms 2 /home/www/html/eetr/tipshealthcare.cfm
8 ms 8 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/navcontentboxhealthcarepc.cfm
7 ms 7 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/eetr/tipshealthcarebaby.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/nativerotationtop_tester13.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
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 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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
504 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 @ 12:25:16.016
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=293ms, Records=1) in /home/www/html/eetr/Application.cfm @ 12:25:17.017
      	  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 @ 12:25:17.017
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=2ms, Records=2) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:25:17.017
	Select *
	From citynetworks
	Where networkID = 26
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:25:17.017
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 26 
getpropertycountries (Datasource=tipripper, Time=45ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:25:17.017
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=34ms, Records=12) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:25:17.017
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 @ 12:25:17.017
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=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:25:17.017
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 26 
GetClassifieds (Datasource=tipripper, Time=8ms, Records=2) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:25:17.017
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 = 26 
AND allreports.networkid = 26 
and allreports.tipcategoryid <> 2791

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

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

WHERE topicid = 7 
getcountryphoto (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:25:17.017
SELECT *
FROM countryphotos
WHERE networkid = 26 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:25:17.017
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.82'
and logtime > "2020-03-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 12:25:17.017
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.82'
and logtime > "2020-06-03 00:00:00.000"
and logtime < "2020-06-03 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:25:17.017
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.82'
and logtime > "2020-05-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:25:17.017
	SELECT *
	From contentcountcountry
	Where networkid = 26 
gettopbanner (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 12:25:17.017
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 12:25:17.017
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 12:25:17.017
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getcount (Datasource=tipripper, Time=0ms, Records=22) in /home/www/html/eetr/tips.cfm @ 12:25:17.017
SELECT answerid
FROM allreports, sitecategories
WHERE rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
and networkid = 26 
order by city ASC, answerid DESC
gethealthintro (Datasource=expert, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:25:17.017
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 26 
	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-03"

    ORDER by articles.articleID desc
    
getname (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tippaginglinkmaker.cfm @ 12:25:17.017
	Select *
	From Networks
	Where networkid = 26 
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:25:17.017
	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-03"
    and articleCategories.articleID = articles.articleID
    and articlePlacement.articleID = articles.articleID
    and articlePlacement.networkID = 26
    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 @ 12:25:17.017
SELECT *
FROM users
WHERE userid = '75215'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:25:17.017
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '26'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:25:17.017
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '26'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:25:17.017
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '7977'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:25:17.017
	SELECT summary 
	FROM answers
	WHERE answerid = 65919 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:25:17.017
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 65919 
getheading (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:25:17.017
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65919'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:25:17.017
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65919'
	and qid = 391
	
gettext402 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 12:25:17.017
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '65919'	and qid = 402
gettext401 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 12:25:17.017
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '65919'	and qid = 401
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipshealthcare.cfm @ 12:25:17.017
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = 65919	AND answerstext.qid = 391
getnatadtopull (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:25:17.017
SELECT *
FROM natadoptions 
WHERE 'hibox' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:25:17.017
	Select *
	From Networks
	Where networkid = 26 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:25:17.017
SELECT *
FROM natadoptions 
WHERE natadtypeid = 4 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:25:17.017
SELECT resourceid, natbox as adcode, natboxweight, natads.natadid
FROM natads, natadPlacement
WHERE natboxtype = 4
and natadPlacement.networkID = 26
and natadPlacement.natadid = natads.natadid
and natboxend > "2020-06-02"
and natboxstart < "2020-06-03"
and natboxstatus = 'live'

and natboxweight = 'high'
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:25:17.017
SELECT *
FROM users
WHERE userid = '59233'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:25:17.017
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '26'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:25:17.017
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '26'
getlocationtag3 (Datasource=expert, Time=0ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:25:17.017
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '7982'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:25:17.017
	SELECT summary 
	FROM answers
	WHERE answerid = 65945 
getbrief (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:25:17.017
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65945 
	AND answerstext.qid = 409
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:25:17.017
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 65945 
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:25:17.017
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65945'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:25:17.017
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65945'
	and qid = 391
	
gettext402 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 12:25:17.017
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '65945'	and qid = 402
gettext401 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 12:25:17.017
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '65945'	and qid = 401
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipshealthcare.cfm @ 12:25:17.017
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = 65945	AND answerstext.qid = 391
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 12:25:17.017
SELECT networkname as ctry, city, networkid, rid, answerid, networkname, userid
FROM allreports
WHERE rid = 88
and networkid = 26
GROUP BY answerid
ORDER BY answerid desc
gettaxgeneral2 (Datasource=expert, Time=4ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:25:17.017
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 26 
	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-03"
     ORDER by articles.sectionintro DESC, articles.articleID desc 
 
gethospitals (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:25:17.017
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 26 
		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-03"
     ORDER by articles.title
 
GetClassifieds (Datasource=tipripper, Time=9ms, Records=2) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:25:17.017
SELECT *
FROM allreports, Networks, answers
WHERE allreports.rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 7
and hide <> 'y'
and allreports.networkid = 26 
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 @ 12:25:17.017
SELECT *
FROM topics
WHERE topicid = 7 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:25:17.017
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65945 
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:25:17.017
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65945 
	AND answerstext.qid = 409
	
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:25:17.017
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65945 
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:25:17.017
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65945 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:25:17.017
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '26'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:25:17.017
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65919 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:25:17.017
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65919 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:25:17.017
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65919 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:25:17.017
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '26'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 12:25:17.017
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65945 
getbrief (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 12:25:17.017
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65945 
	AND answerstext.qid = 409
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 12:25:17.017
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65945 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 12:25:17.017
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65919 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 12:25:17.017
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65919 


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=26&s=1&sort=r&slug=healthcare-in&slug2=bulgaria
REMOTE_ADDR=172.69.62.82
REMOTE_HOST=172.69.62.82
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=28937575
cftoken=64750674
hitcount=1
lastvisit={ts '2020-06-03 12:25:16'}
timecreated={ts '2020-06-03 12:25:16'}
urltoken=CFID=28937575&CFTOKEN=64750674
Cookie Variables:
CFID=28937575
CFTOKEN=64750674
Session Variables:
cfid=28937575
cftoken=64750674
sessionid=IBEXPATEXCHANGE_28937575_64750674
urltoken=CFID=28937575&CFTOKEN=64750674
URL Parameters:
networkid=26
s=1
slug=healthcare-in
slug2=bulgaria
sort=r
tipcategoryid=0
topicid=7
Debug Rendering Time: 11 ms