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

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

Expat Health Insurance & Healthcare Guide to Ukraine

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

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

Expat Healthcare & Health Insurance in Kiev, Ukraine

Expat-Healthcare--Health-Insurance

An expat living in Kiev, Ukraine talks about international health insurance, the expat-friendly IMP clinic in Kiev and more.

Submitted By

angelagnesangelagnes
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 Kiev, Ukraine

Expat-Health-Insurance-and-Healthcare

An expat in Kiev advises expats to make sure that they have good medical insurance. He also forewarned newcomers about hospitals requiring payment before any service is granted.

Submitted By

KINGCITY1949KINGCITY1949

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Healthcare in KievHealthcare in Kiev, Ukraine

An expat in Kiev advises expats to make sure that they have good medical insurance. He also forewarned newcomers about hospitals requiring payment before any service is granted.

Healthcare in KievHealthcare in Kiev, Ukraine

An expat living in Kiev, Ukraine talks about international health insurance, the expat-friendly IMP clinic in Kiev and more.

expat healthcare surveyAnswer Questions about Healthcare in Ukraine

Help others moving to Ukraine by answering a set of questions about health insurance, public healthcare in Ukraine, 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 Ukraine from our partner, Cigna Global Health.
Get a Quote

healthcare in KievHealthcare in Kiev, Ukraine

An expat in Kiev advises expats to make sure that they have good medical insurance. He also forewarned newcomers about hospitals requiring payment before any service is granted. -

healthcare in KievHealthcare in Kiev, Ukraine

An expat living in Kiev, Ukraine talks about international health insurance, the expat-friendly IMP clinic in Kiev and more. -

healthcare surveyAnswer Questions about Healthcare in Ukraine

Help others moving to Ukraine by answering a set of questions about health insurance, public healthcare in Ukraine, 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.

Ukraine 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 01:18 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.194
Host Name 162.158.78.194


Execution Time

Total Time Avg Time Count Template
294 ms 294 ms 1 /home/www/html/eetr/Application.cfm
194 ms 194 ms 1 top level /home/www/html/eetr/tips.cfm
97 ms 97 ms 1 /home/www/html/navtop_rdesign5.cfm
91 ms 91 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
27 ms 27 ms 1 /home/www/html/navcontentboxhealthcaremobile.cfm
23 ms 12 ms 2 /home/www/html/eetr/tipshealthcare.cfm
16 ms 4 ms 4 /home/www/html/eetr/rewritetipheadingstate.cfm
5 ms 5 ms 1 /home/www/html/eetr/tipshealthcarebaby.cfm
3 ms 3 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/nativerotationtop_tester13.cfm
2 ms 2 ms 1 /home/www/html/navcontentboxhealthcarepc.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navrightmidcolumn_rdesign5.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/constants.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
489 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 @ 13:18:42.042
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=292ms, Records=1) in /home/www/html/eetr/Application.cfm @ 13:18:43.043
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=2ms, Records=153) in /home/www/html/eetr/eetr_navmeta.cfm @ 13:18:43.043
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/eetr/eetr_navmeta.cfm @ 13:18:43.043
	Select *
	From citynetworks
	Where networkID = 114
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/eetr/eetr_navmeta.cfm @ 13:18:43.043
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 114 
getpropertycountries (Datasource=tipripper, Time=45ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 13:18:43.043
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 @ 13:18:43.043
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=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 13:18:43.043
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 @ 13:18:43.043
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 114 
GetClassifieds (Datasource=tipripper, Time=5ms, Records=2) in /home/www/html/eetr/eetr_navmeta.cfm @ 13:18:43.043
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 = 114 
AND allreports.networkid = 114 
and allreports.tipcategoryid <> 2791

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

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

WHERE topicid = 7 
getcountryphoto (Datasource=expert, Time=0ms, Records=7) in /home/www/html/eetr/eetr_navmeta.cfm @ 13:18:43.043
SELECT *
FROM countryphotos
WHERE networkid = 114 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 13:18:43.043
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-03-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 13:18:43.043
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
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=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 13:18:43.043
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-05-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 13:18:43.043
	SELECT *
	From contentcountcountry
	Where networkid = 114 
gettopbanner (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 13:18:43.043
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
    and bannerPlacement.networkid = 114
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 13:18:43.043
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
getcount (Datasource=tipripper, Time=1ms, Records=6) in /home/www/html/eetr/tips.cfm @ 13:18:43.043
SELECT answerid
FROM allreports, sitecategories
WHERE rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
and networkid = 114 
order by city ASC, answerid DESC
gethealthintro (Datasource=expert, Time=5ms, Records=0) in /home/www/html/eetr/tips.cfm @ 13:18:43.043
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 114 
	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 asc   
    
getname (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tippaginglinkmaker.cfm @ 13:18:43.043
	Select *
	From Networks
	Where networkid = 114 
gettaxgeneral (Datasource=expert, Time=5ms, Records=0) in /home/www/html/eetr/tips.cfm @ 13:18:43.043
	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 = 114
    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 @ 13:18:43.043
SELECT *
FROM users
WHERE userid = '215550'
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:18:43.043
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '114'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:18:43.043
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '114'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:18:43.043
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '4250'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:18:43.043
	SELECT summary 
	FROM answers
	WHERE answerid = 80085 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:18:43.043
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80085 
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 13:18:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80085'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 13:18:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80085'
	and qid = 391
	
gettext402 (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 13:18:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '80085'	and qid = 402
gettext401 (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 13:18:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '80085'	and qid = 401
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipshealthcare.cfm @ 13:18:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = 80085	AND answerstext.qid = 391
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 13:18:43.043
SELECT *
FROM natadoptions 
WHERE 'hibox' = tag
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 13:18:43.043
	Select *
	From Networks
	Where networkid = 114 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 13:18:43.043
SELECT *
FROM natadoptions 
WHERE natadtypeid = 4 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 13:18:43.043
SELECT resourceid, natbox as adcode, natboxweight, natads.natadid
FROM natads, natadPlacement
WHERE natboxtype = 4
and natadPlacement.networkID = 114
and natadPlacement.natadid = natads.natadid
and natboxend > "2020-06-02"
and natboxstart < "2020-06-03"
and natboxstatus = 'live'

and (natboxweight = 'medium' or natboxweight = 'high')
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:18:43.043
SELECT *
FROM users
WHERE userid = '59655'
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:18:43.043
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '114'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:18:43.043
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '114'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:18:43.043
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '4250'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:18:43.043
	SELECT summary 
	FROM answers
	WHERE answerid = 65965 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:18:43.043
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 65965 
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 13:18:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65965'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 13:18:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65965'
	and qid = 391
	
gettext402 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 13:18:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '65965'	and qid = 402
gettext401 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 13:18:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '65965'	and qid = 401
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipshealthcare.cfm @ 13:18:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = 65965	AND answerstext.qid = 391
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 13:18:43.043
SELECT networkname as ctry, city, networkid, rid, answerid, networkname, userid
FROM allreports
WHERE rid = 88
and networkid = 114
GROUP BY answerid
ORDER BY answerid desc
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 13:18:43.043
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 114 
	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 @ 13:18:43.043
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 114 
		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=10ms, Records=2) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 13:18:43.043
SELECT *
FROM allreports, Networks, answers
WHERE allreports.rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 7
and hide <> 'y'
and allreports.networkid = 114 
and answers.answerid = allreports.answerid
and answers.reviewed = 'y'

    ORDER by allreports.answerid asc   
    
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 13:18:43.043
SELECT *
FROM topics
WHERE topicid = 7 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 13:18:43.043
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65965 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 13:18:43.043
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65965 
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 13:18:43.043
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65965 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 13:18:43.043
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '114'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 13:18:43.043
	SELECT summary as answer
	FROM answers
	WHERE answerid = 80085 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 13:18:43.043
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 80085 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 13:18:43.043
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 80085 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 13:18:43.043
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '114'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 13:18:43.043
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65965 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 13:18:43.043
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65965 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 13:18:43.043
	SELECT summary as answer
	FROM answers
	WHERE answerid = 80085 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 13:18:43.043
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 80085 


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=114&s=1&sort=r&slug=healthcare-in&slug2=ukraine
REMOTE_ADDR=162.158.78.194
REMOTE_HOST=162.158.78.194
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=28940403
cftoken=24314450
hitcount=1
lastvisit={ts '2020-06-03 13:18:42'}
timecreated={ts '2020-06-03 13:18:42'}
urltoken=CFID=28940403&CFTOKEN=24314450
Cookie Variables:
CFID=28940403
CFTOKEN=24314450
Session Variables:
cfid=28940403
cftoken=24314450
sessionid=IBEXPATEXCHANGE_28940403_24314450
urltoken=CFID=28940403&CFTOKEN=24314450
URL Parameters:
networkid=114
s=1
slug=healthcare-in
slug2=ukraine
sort=r
tipcategoryid=0
topicid=7
Debug Rendering Time: 11 ms