Home Indonesia Forum Indonesia Guide Moving to Indonesia Real Estate Healthcare in Indonesia
Indonesia
Resources
City Guides
JoinSign In
AGS Worldwide Movers
Expat Coronavirus Report

Coronavirus in Bali, Indonesia

By barefootlotuss

Read & Post Comments

Coronavirus-in-Bali,-Indonesia

Mar 19, 2020 Update

We Asked: What is currently happening with regard to the Coronavirus outbreak in your area? Please provide as much detail as possible. She replied...

Information is written in Bahasa, so not in English. Generally, there is information for people about containing the virus, with school closings. It’s not clear how seriously people take this advise. Bali, where I am, is definitely not in lock down. Seemed like people were very slow to start tracking this and now seemed dazed that suddenly there are changes in their jobs with a dramatic slow down in tourists. There is no large scale testing, and everything here is kind of vague. Fortunately, one can get things delivered easily, with a $35 minimum purchase at a grocery store. I can order organic veggies online for delivery, and there’s plenty of delivery options for food of all kinds here. Bali is getting quiet now with the outflux of tourists, especially Chinese who are the largest population of tourists here normally. So for being an expat right now, it is quite pleasant with the drop in traffic. I can find a rental now much more inexpensively, too.

How People are Coping

We Asked: How are people handling the situation in your area? She replied...

Balinese are reluctant to accept this since their economy is tourist based. Economic concerns seem to supercede other health issues. The Balinese up until recently thought the country was immune to the virus because of their ceremonies and prayers. In fact the government had initially advised prayer as the primary antidote. They said they believed that the animals would take the virus instead of humans, which is odd logic considering the virus comes from animals. Or bats? Anyway, I’m not sure the Balinese have the same approach to issues people in the US do where there is a lot of attention to media, and a free discussion of issues. Indonesia was ruled by a dictator for a long time and authoritarianism is slow to surrender to the Worlds’ 3rd largest democracy, which seems like a very young democracy. Nevertheless, there are apparently more vocal outbursts from some sectors demanding more access to testing, but not so much in Bali. Generally the government was slow to act, slow to release data, etc. Part of that is Public Healthcare policy is not super proactive. I'm sure they are rising to the occasion as the rest of the world’s responses are seen to unfold.

Changing Conditions as coronavirus Spreads

We Asked: How has the situation changed as the Coronavirus has spread? She replied...

The issue is that the spread of the virus here is not tracked well. Who knows how many people actually have this virus when testing is inadequate as well as public information being slow to emerge. People probably think they just have a flu, or sickness. Something seasonal. They are not alerted to this disease. So, I am not sure what the actual figure is and definitely don’t think people know what it is here in Bali. This sort of less than realistic atmosphere is prevalent. They are very slow to get that this is a big issue. They thought that being in a tropical country was the antidote and it wasn’t going to be a problem here.

Government Response

We Asked: Describe how the government of the country about which you are reporting is handling this situation. She replied...

I’m not sure. I only read new reports.

Government Response with Regard to Expats

We Asked: Describe how your home country's government has handled the outbreak situation with regards to its expatriate citizens. She replied...

I get emails from the US consulate with phone numbers and hotlines to call. I contacted the consulate to find out where I could go to get tested if I needed to.

Supplies and Shortages

We Asked: Is there a shortage of supplies in your location? She replied...

Supplies of hand sanitizer are going down. There’s plenty of produce, and most everything.

Preparing for the Future

We Asked: What are you doing in terms of preparations in case the situation deteriorates in your location? She replied...

I am already hunkering down. I am currently planning to stay as I’m safer here than on a plane home. It’s not great. I’ve been ordering supplements I can take if I needed to. I think there will be food available. I know an organic farmer I can contact for veggies, and can order things online.

Lockdown & Passing the Time

We Asked: Are you staying home? If so, how are you passing the time? She replied...

I'm staying home. I'm building my network of numbers to call for grocery deliveries, and have a driver who can run errands for me. I’ve been busy renewing my retirement visa for another year, taking care of some business, and ordering supplements. I've been researching how to apply for D7 visa to Portugal from Bali. After that, I do yoga from some posts on Instagram by teachers I follow, i take walks around here, talk to my daughters, listen to a ton of podcasts on ITunes and YouTube from US about politics, the primary, the Covid drama in the US, and some more spiritually oriented podcasts about manifesting and astrology.. I wash my clothes, cook my food, clean my quarters as I asked the staff not to come into my room to clean anymore. I’ve been getting well from a bout with parasites and candida that lasted two years, and am now much better, but exploring a new bean protocol to continue to heal my intestines. So that involves tracking some updates about it on Instagram.

Public Healthcare & Public Hospitals

We Asked: Are you enrolled in the public healthcare system where you live? Do you feel that the public hospitals are handling or preparing for the Coronavirus outbreak effectively? She replied...

I am not enrolled. The government is trying to expand the locations for getting the texts sent for results. I am concerned that they don't have enough tests, not enough ventilators, etc. I certainly as an older person don’t want to be the one deprioritized in such a situation where I needed one, if it came to that. So. I’m hoping that should I contract the virus that I could manage it myself.

Private Health Insurance & Private Hospitals

We Asked: Do you have private health insurance? If you have private insurance, does this give you access to private hospitals? Are private hospitals or clinics better prepared, less prepared, or the same? Please explain. She replied...

I have travel insurance.

Hospital of Choice for Coronavirus Treatment

We Asked: Would you choose a public or private hospital if you needed treatment for Coronavirus? Why? If there is a specific hospital that you would go to in the event of severe illness? Which hospital and why? She replied...

I am not sure on hospitals. I have gone to a public hospital near Ubud a couple of times. Good question.

Returning Home

We Asked: Are you considering returning to your home country due to the Coronavirus? Would this be a temporary move or a permanent repatriation? Please explain. She replied...

I am not considering returning to live in the US at this time due to the cost. My youngest daughter wants me to come back. I will travel there if possible in late Summer. It would definitely be nice to be on one’s own ground in a situation like this. I have Medicare, too. But I am sticking things out here for now. I don't want to board a plane. That scares me more than staying here. I need to continue to work on getting healthy before venturing out. So I’m just isolating here and hoping for the best.

Expat Health Insurance in Indonesia

Expats interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA.

Submitted By

barefootlotuss

barefootlotuss

View barefootlotuss's Profile

Living as an expat. From United States. Single woman. Have two daughters. Do yoga. Healthy lifestyle.

Sign In or Sign Up to reply

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Moving-to-IndonesiaMoving to Indonesia

Expats discuss what they wish they had known before moving to Indonesia. Locals say "yes" even when they really mean to say "no" and traffic can be a nightmare. But, there are many of positives, too.

Expats discuss what they wish they had known before moving to Indonesia. Locals say "yes" even when they really mean to say "no" and traffic can be a nightmare. But, there are many of positives, too....

Healthcare-in-IndonesiaHealthcare in Indonesia

Expats talk about healthcare conditions in Indonesia, the importance of health insurance, traveling abroad for medical care and more.

Expats talk about healthcare conditions in Indonesia, the importance of health insurance, traveling abroad for medical care and more....

Indonesia Guide
Other Links
Our Story Our Team Contact Us Submit an Article Advertising Travel Warnings

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /eetr/tip.cfm
Time Stamp 06-Jun-20 02:23 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.173
Host Name 173.245.54.173


Execution Time

Total Time Avg Time Count Template
327 ms 327 ms 1 /home/www/html/eetr/tip.cfm
290 ms 290 ms 1 /home/www/html/eetr/Application.cfm
105 ms 105 ms 1 /home/www/html/navtop_rdesign5.cfm
99 ms 99 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
45 ms 45 ms 1 /home/www/html/eetr/tipcoronavirus.cfm
24 ms 24 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
23 ms 23 ms 1 /home/www/html/navcontentbox.cfm
23 ms 23 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/eetr/navgettiplink.cfm
2 ms 2 ms 1 /home/www/html/nativerotationtop_tester13.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 2 /home/www/html/eetr/navinjection.cfm
0 ms 0 ms 1 /home/www/html/eetr/qry_GeneralSet.cfm
0 ms 0 ms 2 /home/www/html/eetr/rewritealtimage.cfm
0 ms 0 ms 1 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 2 /home/www/html/eetr/rewritetipheadingstate.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 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/rewritearticle.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
618 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 @ 14:23:56.056
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=288ms, Records=1) in /home/www/html/eetr/Application.cfm @ 14:23:56.056
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=2ms, Records=153) in /home/www/html/eetr/eetr_navmeta.cfm @ 14:23:56.056
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=1ms, Records=4) in /home/www/html/eetr/eetr_navmeta.cfm @ 14:23:56.056
	Select *
	From citynetworks
	Where networkID = 55
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 14:23:56.056
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 55 
getpropertycountries (Datasource=tipripper, Time=47ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 14:23:56.056
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 @ 14:23:56.056
SELECT * 
FROM sitecategories, qoptions, allreports
WHERE qoptions.qoid = sitecategories.tipcategoryid
and qoptions.parent = 0
and allreports.hide <> 'y'
and sitecategories.siteid = 3
and sitecategories.tipcategoryid <> 2791
and sitecategories.tipcategoryid <> 2797
and sitecategories.tipcategoryid <> ''
and sitecategories.tipcategoryid <> 2793
and sitecategories.tipcategoryid <> 2792
and allreports.tipcategoryid = sitecategories.tipcategoryid
group by sitecategories.tipcategoryid 
GetClassifieds (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 14:23:56.056
SELECT allreports.networkname, allreports.networkid, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allowcomments, allreports.citynetworkid, allreports.citynetworkid2, sitecategories.categoryslug, allreports.statenetworkid, allreports.topicid, allreports.city, sitecategories.headingnav, allreports.topicid as topicid, allreports.state, allreports.rid
FROM allreports, sitecategories
WHERE allreports.answerid = 80641 
and sitecategories.tipcategoryid = allreports.tipcategoryid
GetClassified (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/eetr_navmeta.cfm @ 14:23:56.056
SELECT allreports.networkname, allreports.networkid, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allowcomments, Networks.networkid, Networks.shortname, Networks.networkname, citynetworks.shortname, allreports.citynetworkid, allreports.citynetworkid2, allreports.topicid as topicid, allreports.city, allreports.state, allreports.answerid, allreports.topicid 
FROM allreports, Networks, citynetworks
WHERE rid = 100
and allreports.answerid = 80641
and allreports.statenetworkid = Networks.networkid
and allreports.citynetworkid = citynetworks.citynetworkid
GetClassified (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 14:23:56.056
SELECT allreports.networkname, allreports.networkid, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allowcomments, allreports.citynetworkid, allreports.citynetworkid2, allreports.topicid as topicid, allreports.city, allreports.state, allreports.answerid, allreports.topicid 
FROM allreports
WHERE rid = 100
and allreports.answerid = 80641 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 14:23:56.056
SELECT *
FROM topics

WHERE topicid = 17 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/navgettiplink.cfm @ 14:23:56.056
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '55'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/navgettiplink.cfm @ 14:23:56.056
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '55'
getlocationtag3 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/navgettiplink.cfm @ 14:23:56.056
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '1029'
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 14:23:56.056
	SELECT DISTINCT hpimg as photo, fbimg
	FROM answers
	WHERE answerid = 80641 
getsummary (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 14:23:56.056
	SELECT DISTINCT summaryprop as summary
	FROM answers
	WHERE answerid = 80641 
getbrief (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/eetr_navmeta.cfm @ 14:23:56.056
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 80641 
	AND answerstext.qid = 392
	
getsummary (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 14:23:56.056
	SELECT summary 
	FROM answers
	WHERE answerid = 80641 
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 14:23:56.056
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80641'
	and qid = 391
	
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 14:23:56.056
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.173'
and logtime > "2020-03-07"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 14:23:56.056
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.173'
and logtime > "2020-06-06 00:00:00.000"
and logtime < "2020-06-06 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 14:23:56.056
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.173'
and logtime > "2020-05-30"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 14:23:56.056
	SELECT *
	From contentcountcountry
	Where networkid = 55 
gettopbanner (Datasource=expert, Time=0ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 14:23:56.056
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-06-05"
    and fromDate < "2020-06-06"
    and bannerPlacement.networkid = 55
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 14:23:56.056
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
getpropertycountries (Datasource=tipripper, Time=25ms, Records=130) in /home/www/html/eetr/tip.cfm @ 14:23:56.056
SELECT allreports.networkname, allreports.networkid, shortname, allreports.date
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = allreports.networkid
group by allreports.networkid
order by allreports.networkname ASC
gettipcategories (Datasource=tipripper, Time=1ms, Records=2) in /home/www/html/eetr/tip.cfm @ 14:23:56.056
SELECT allreports.tipcategory, allreports.tipcategoryid, topicid
FROM allreports
WHERE rid = 100
AND allreports.networkid = 55
group by allreports.tipcategoryid 
CheckTrackings (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tip.cfm @ 14:23:56.056
  SELECT t.tpcid, tk.tpcid as tpcid, tk.trackingdate, tk.trackingtype, tk.trackingid, tk.dbname, tk.shared, tk.userid
  FROM commenttrackings tk, comments t 
  WHERE tk.tpcid = 80641
  and t.tpcid = 80641
  and tk.commenttype = 9
  AND tk.trackingtype = "S"
  AND tk.userid = "2"
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tip.cfm @ 14:23:56.056
SELECT *
FROM topics
WHERE topicid = 17 
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tip.cfm @ 14:23:56.056
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 80641
	AND answerstext.qid = 391
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tip.cfm @ 14:23:56.056
SELECT userphoto, tipcount, username, aboutme 
FROM users
WHERE userid = 194663 
GetUserProfile (Datasource=forum, Time=111ms, Records=1) in /home/www/html/eetr/tip.cfm @ 14:23:56.056
  SELECT *
  FROM userprofiles
  WHERE userid = 194663 
getbrief (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tip.cfm @ 14:23:56.056
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 80641
	AND answerstext.qid = 392
getcategory (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tip.cfm @ 14:23:56.056
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 80641
	AND answerstext.qid = 390
getmostpostsreply (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tip.cfm @ 14:23:56.056
  SELECT msgtext, m.msgdate as commentdate, msgid, userid
  FROM comments m 
  WHERE m.tpcid = 80641
  and m.commenttype = 9
  and m.isapproved = 1
  ORDER BY m.msgid DESC
getanswerstext (Datasource=tipripper, Time=5ms, Records=12) in /home/www/html/eetr/tipcoronavirus.cfm @ 14:23:56.056
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, answers.summaryprop, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 80641
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 80641 = answerstext.answerid 
ORDER BY topicquestions.order ASC
checkifexpert (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipcoronavirus.cfm @ 14:23:56.056
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.startdate <{ts '2020-06-05 14:23:56'}
and expertusers.enddate > {ts '2020-06-06 14:23:56'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 194663
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
checkexpertexpired (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipcoronavirus.cfm @ 14:23:56.056
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.enddate <{ts '2020-06-06 14:23:56'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 194663
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
getexpatusername (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tipcoronavirus.cfm @ 14:23:56.056
SELECT username
FROM users
WHERE userid = 194663 
getauthorfirst (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tipcoronavirus.cfm @ 14:23:56.056
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 194663
and answerstext.qid = 95
and answers.reviewed = 'y'
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tipcoronavirus.cfm @ 14:23:56.056
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 194663
and answerstext.qid = 96
and answers.reviewed = 'y'
and answerstext.answerid = answers.answerid
 
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipcoronavirus.cfm @ 14:23:56.056
	SELECT *
	FROM markers
	WHERE answerid = '80641'
	and lat <> ''
	and lng <> ''
getgender (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipcoronavirus.cfm @ 14:23:56.056
	SELECT DISTINCT qoid
	FROM answersmc
	WHERE answerid = 80641
	and qid = 302
	
gettour1 (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/eetr/tipcoronavirus.cfm @ 14:23:56.056
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80641'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
gettour2 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipcoronavirus.cfm @ 14:23:56.056
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80641'
	AND answersphoto.qid = '105'
	AND answersphoto.photo <> 'none'
gettour3 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipcoronavirus.cfm @ 14:23:56.056
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80641'
	AND answersphoto.qid = '106'
	AND answersphoto.photo <> 'none'
gettour4 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipcoronavirus.cfm @ 14:23:56.056
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80641'
 	AND answersphoto.qid = '107'
	AND answersphoto.photo <> 'none'
gettour5 (Datasource=tipripper, Time=2ms, Records=0) in /home/www/html/eetr/tipcoronavirus.cfm @ 14:23:56.056
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80641'
	AND answersphoto.qid = '108'
	AND answersphoto.photo <> 'none'
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 14:23:56.056
SELECT *
FROM natadoptions 
WHERE 'hiheader' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 14:23:56.056
	Select *
	From Networks
	Where networkid = 55 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 14:23:56.056
SELECT *
FROM natadoptions 
WHERE natadtypeid = 1 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 14:23:56.056
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 1
and natadPlacement.networkID = 55
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-06-05"
and headerparagraphstart < "2020-06-06"
and headerparagraphstatus = 'live'

and (headerparagraphweight = 'medium' or headerparagraphweight = 'high')
checkculturefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 14:23:56.056
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 55 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
checklivingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 14:23:56.056
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 55 
        and date > '2013-04-01'
		order by date DESC
gettaxgeneral2 (Datasource=expert, Time=7ms, Records=2) in /home/www/html/navcontentbox.cfm @ 14:23:56.056
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 55 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-06"

    ORDER by articles.articleID desc
    
checkrptarticles (Datasource=reports, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 14:23:56.056
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-06"
     
         and rptarticlenetworks.networkid = 55 
    ORDER by rptarticles.rptarticleID desc
    


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/eetr/tip.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.expatexchange.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/home/www/html/eetr/tip.cfm
QUERY_STRING=answerid=80641&networkid=55&topicid=17
REMOTE_ADDR=173.245.54.173
REMOTE_HOST=173.245.54.173
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/eetr/tip.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Client Variables:
cfid=29106771
cftoken=35369834
hitcount=1
lastvisit={ts '2020-06-06 14:23:56'}
timecreated={ts '2020-06-06 14:23:56'}
urltoken=CFID=29106771&CFTOKEN=35369834
Cookie Variables:
CFID=29106771
CFTOKEN=35369834
Session Variables:
cfid=29106771
cftoken=35369834
sessionid=IBEXPATEXCHANGE_29106771_35369834
urltoken=CFID=29106771&CFTOKEN=35369834
URL Parameters:
answerid=80641
networkid=55
topicid=17
Debug Rendering Time: 10 ms