Home Norway Forum Norway Guide Moving to Norway Real Estate Healthcare in Norway
Norway
Resources
City Guides
JoinSign In
AGS Worldwide Movers

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

Expat Health Insurance & Healthcare Guide to Norway

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

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

Expat Health Insurance and Healthcare in Kongsvinger, Norway

The main problem where I am in Norway, is that the doctor I have is too lax and laid back, basically I go in and sit in his office to chat. No exam, I have only had my blood pressure taken once in near 4 years now, my weight, TPR's and family history have never been taken. But the main problem is that seeking specialists can and will take anywhere from 6 months to 1 1/2 years. Doctors here will tell you lets see how you feel in 3 months or so....etc,etc, etc.....and then maybe you might be refered then or wait yet another 3 months before they set an appt for you 6 months down the road or longer. For instance I have been diagnosed with Hypothyroidism (thyroid disease) for near 4 years and am still yet to see an endocronologist, as my medication isn't doing a thing for my symptoms (constant headaches, extreme itching in ears and head, excessive weight gain, ear infections caused by itching irritations, tunnel syndrome, and round the clock tiredness and exhaustion from small tasks. And after 10 or more trips to the ear specialist, nothing has done anything to stop this endless madness.

Submitted By

TazzbabyTazzbaby
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 Oslo, Norway

Expat-Health-Insurance-and-Healthcare

An expat in Oslo, Norway shares some thoughts about her experiences with the health care system there. Her advice, based on hard experiences, is to definitely get private health insurance.

Submitted By

britinnorwaybritinnorway

Having a Baby in Stavanger, Norway

Having-a-Baby-In-Stavanger

I hear that if you have a normal delivery without any problems this can be a great place to give birth. However, any hick-ups and you will wish you were somewhere else. Too many bad stories to tell, but my own was a simple c-section. I had 2 previously in the USA and they were a breeze. I seriously don't think the surgeon knew what she was doing. She doubled the size of my incision and the baby was less than 8 lbs - the smallest baby I have had. My recovery was 2 or 3 days in the USA but it was more like 2 or 3 months here. I am glad this was our last child because if it had been the first then it would have been our only. Oh, and I had to have a spinal. It took the man 2 tries to be successful and then I developed a spinal headache that took the nurses 3 days to resolve. Sadly it was a horrible experience for me, but luckily our baby was just great!

Having a Baby in Oslo, Norway

Having-a-Baby-In-Oslo

While I experienced some anxiety during my pregnancy, my overall experience was very positive. Norway has an excellent health care system, though the fact that I would not be able to choose the doctor or midwife, who would deliver my baby, did cause me some anxiety.

I gave birth on May 9, 2008 in Baerum Sykhus, outside of the capital city of Oslo. The two midwives who worked with me were wonderful, both spoke perfect English, which was a blessing since my Norwegian was nearly nonexistent. They actually read the birthplan that I wrote and made a conscientious attempt to follow it. The birth went smoothly, I had an epidural as I had had with my previous two births (in the US). Six hours after arriving at the hospital I gave birth to a healthy baby boy. Because there were no complications I had the option of leaving after 6 hours of giving birth or staying in the hospital for up to 3 nights. I chose to stay with my husband and our new son in a family suite for just one night. The stipulation of staying in a family suite was that you had to fend for yourself. A nurse would be available to check on you and the baby but for the most part you were required to get your food for yourself, shower... I enjoyed the independence. The hospital was wonderful... I enjoyed the freedom of choice. The one weird aspect was that since I gave birth on a weekend a pediatrician was not there and we had to bring our baby back for a checkup two days after he was born. Overall giving birth in Norway was a terrific experience.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Healthcare in OsloHealthcare in Oslo, Norway

An expat in Oslo, Norway shares some thoughts about her experiences with the health care system there. Her advice, based on hard experiences, is to definitely get private health insurance.

Healthcare in KongsvingerHealthcare in Kongsvinger, Norway

The main problem where I am in Norway, is that the doctor I have is too lax and laid back, basically I go in and sit in his office to chat. No exam, I have only had my blood pressure taken once in nea

expat healthcare surveyAnswer Questions about Healthcare in Norway

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

Having-a-Baby-In-NorwayExpats Talk about What it's Like Having a Baby in Norway

Read recent baby reports submitted for Stavanger and Oslo.

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

healthcare in OsloHealthcare in Oslo, Norway

An expat in Oslo, Norway shares some thoughts about her experiences with the health care system there. Her advice, based on hard experiences, is to definitely get private health insurance. -

healthcare in KongsvingerHealthcare in Kongsvinger, Norway

The main problem where I am in Norway, is that the doctor I have is too lax and laid back, basically I go in and sit in his office to chat. No exam, I have only had my blood pressure taken once in nea -

healthcare surveyAnswer Questions about Healthcare in Norway

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

Having-a-Baby-In-NorwayExpats Talk about What it's Like Having a Baby in Norway

Read recent baby reports submitted for Stavanger and Oslo.

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

Norway 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:55 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
827 ms 827 ms 1 /home/www/html/eetr/Application.cfm
294 ms 294 ms 1 /home/www/html/eetr/tips.cfm
105 ms 105 ms 1 /home/www/html/navtop_rdesign5.cfm
98 ms 98 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
70 ms 70 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
69 ms 69 ms 1 /home/www/html/navcontentboxhealthcarepc.cfm
69 ms 69 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
34 ms 34 ms 1 /home/www/html/navcontentboxhealthcaremobile.cfm
23 ms 12 ms 2 /home/www/html/eetr/tipshealthcare.cfm
17 ms 4 ms 4 /home/www/html/eetr/rewritetipheadingstate.cfm
17 ms 17 ms 1 /home/www/html/eetr/tipshealthcarebaby.cfm
2 ms 2 ms 1 /home/www/html/nativerotationtop_tester13.cfm
2 ms 2 ms 1 /home/www/html/navleader_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/tippagingnew.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/tippaginglinkmaker.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
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1121 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:55:23.023
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=825ms, Records=1) in /home/www/html/eetr/Application.cfm @ 12:55:24.024
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=4ms, Records=153) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:55:24.024
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=2ms, Records=5) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:55:24.024
	Select *
	From citynetworks
	Where networkID = 85
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:55:24.024
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 85 
getpropertycountries (Datasource=tipripper, Time=47ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:55:24.024
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 @ 12:55:24.024
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:55:24.024
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:55:24.024
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 85 
GetClassifieds (Datasource=tipripper, Time=7ms, Records=2) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:55:24.024
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 = 85 
AND allreports.networkid = 85 
and allreports.tipcategoryid <> 2791

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

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

WHERE topicid = 7 
getcountryphoto (Datasource=expert, Time=1ms, Records=10) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:55:24.024
SELECT *
FROM countryphotos
WHERE networkid = 85 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:55:24.024
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 @ 12:55:24.024
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 @ 12:55:24.024
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 @ 12:55:24.024
	SELECT *
	From contentcountcountry
	Where networkid = 85 
gettopbanner (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 12:55:24.024
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
    and bannerPlacement.networkid = 85
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 12:55:24.024
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
getcount (Datasource=tipripper, Time=0ms, Records=6) in /home/www/html/eetr/tips.cfm @ 12:55:24.024
SELECT answerid
FROM allreports, sitecategories
WHERE rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
and networkid = 85 
order by city ASC, answerid DESC
gethealthintro (Datasource=expert, Time=5ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:55:24.024
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 85 
	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:55:24.024
	Select *
	From Networks
	Where networkid = 85 
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:55:24.024
	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 = 85
    and articleCategories.section = 9
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    ORDER by publishdate desc
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:55:24.024
SELECT *
FROM users
WHERE userid = '35329'
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:55:24.024
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '85'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:55:24.024
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '85'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:55:24.024
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '5407'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:55:24.024
	SELECT summary 
	FROM answers
	WHERE answerid = 65957 
getbrief (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:55:24.024
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65957 
	AND answerstext.qid = 409
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:55:24.024
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 65957 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:55:24.024
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 65957 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:55:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65957'
	and qid = 391
	
getheading (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:55:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65957'
	and qid = 391
	
gettext402 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 12:55:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '65957'	and qid = 402
gettext401 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 12:55:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '65957'	and qid = 401
getheading (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 12:55:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = 65957	AND answerstext.qid = 391
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:55:24.024
SELECT *
FROM natadoptions 
WHERE 'hibox' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:55:24.024
	Select *
	From Networks
	Where networkid = 85 
getnatadtype (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:55:24.024
SELECT *
FROM natadoptions 
WHERE natadtypeid = 4 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:55:24.024
SELECT resourceid, natbox as adcode, natboxweight, natads.natadid
FROM natads, natadPlacement
WHERE natboxtype = 4
and natadPlacement.networkID = 85
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=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:55:24.024
SELECT *
FROM users
WHERE userid = '94552'
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:55:24.024
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '85'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:55:24.024
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '85'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:55:24.024
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '4198'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:55:24.024
	SELECT summary 
	FROM answers
	WHERE answerid = 76840 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:55:24.024
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 76840 
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:55:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '76840'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:55:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '76840'
	and qid = 391
	
gettext402 (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 12:55:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '76840'	and qid = 402
gettext401 (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 12:55:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '76840'	and qid = 401
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipshealthcare.cfm @ 12:55:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = 76840	AND answerstext.qid = 391
checkbaby (Datasource=expert, Time=5ms, Records=2) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 12:55:24.024
SELECT networkname as ctry, city, networkid, rid, answerid, networkname, userid
FROM allreports
WHERE rid = 88
and networkid = 85
GROUP BY answerid
ORDER BY answerid desc
editorsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 12:55:24.024
SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 25063 
getsummary (Datasource=reports, Time=4ms, Records=1) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 12:55:24.024
SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 25063
AND answerstext.qid = 304
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 12:55:24.024
SELECT DISTINCT summary, fbimg, hiimg
FROM answers 
WHERE answers.answerid = 25063 
getcountryphotos (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 12:55:24.024
	SELECT DISTINCT hiimg
	FROM countryphotos
	WHERE networkid = 85
	and hiimg <> ''
	
editorsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 12:55:24.024
SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 24374 
getsummary (Datasource=reports, Time=4ms, Records=1) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 12:55:24.024
SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 24374
AND answerstext.qid = 304
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 12:55:24.024
SELECT DISTINCT summary, fbimg, hiimg
FROM answers 
WHERE answers.answerid = 24374 
getcountryphotos (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 12:55:24.024
	SELECT DISTINCT hiimg
	FROM countryphotos
	WHERE networkid = 85
	and hiimg <> ''
	
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:55:24.024
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 85 
	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:55:24.024
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 85 
		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:55:24.024
SELECT *
FROM allreports, Networks, answers
WHERE allreports.rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 7
and hide <> 'y'
and allreports.networkid = 85 
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:55:24.024
SELECT *
FROM topics
WHERE topicid = 7 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:55:24.024
	SELECT summary as answer
	FROM answers
	WHERE answerid = 76840 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:55:24.024
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 76840 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:55:24.024
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 76840 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:55:24.024
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '85'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:55:24.024
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65957 
getbrief (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:55:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65957 
	AND answerstext.qid = 409
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:55:24.024
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65957 
getphoto (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:55:24.024
	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 85
	and fbimg <> ''
	
getphotos (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:55:24.024
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65957 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:55:24.024
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '85'
checkbabyfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:55:24.024
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
      
         and networkid = 85 
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 12:55:24.024
		Select summary, hiimg 
		FROM answers
         where answerid = 25063
         and summary <> ''
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 12:55:24.024
	SELECT summary as answer
	FROM answers
	WHERE answerid = 76840 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 12:55:24.024
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 76840 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 12:55:24.024
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65957 
getbrief (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 12:55:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65957 
	AND answerstext.qid = 409
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 12:55:24.024
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65957 
getphoto (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 12:55:24.024
	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 85
	and fbimg <> ''
	
getslugs (Datasource=tipripper, Time=59ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 12:55:24.024
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 7 
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 12:55:24.024
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65957 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 12:55:24.024
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '85'
getsummary (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcarepc.cfm @ 12:55:24.024
		Select summary, hiimg 
		FROM answers
         where answerid = 25063
         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=85&s=1&sort=r&slug=healthcare-in&slug2=norway
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=28938852
cftoken=54568777
hitcount=1
lastvisit={ts '2020-06-03 12:55:23'}
timecreated={ts '2020-06-03 12:55:23'}
urltoken=CFID=28938852&CFTOKEN=54568777
Cookie Variables:
CFID=28938852
CFTOKEN=54568777
Session Variables:
cfid=28938852
cftoken=54568777
sessionid=IBEXPATEXCHANGE_28938852_54568777
urltoken=CFID=28938852&CFTOKEN=54568777
URL Parameters:
networkid=85
s=1
slug=healthcare-in
slug2=norway
sort=r
tipcategoryid=0
topicid=7
Debug Rendering Time: 10 ms