Home Chile Forum Chile Guide Moving to Chile Real Estate Healthcare in Chile
Chile
Resources
City Guides
JoinSign In
Cigna International Health Insurance
Expat Coronavirus Report


ClĂ­nica Alemana Valdivia , Chile english-speaking Doctor : NICOLE SUZANNE CAREY PETERS

Coronavirus in Valdivia, Chile

By CollegePath

Read & Post Comments

Mar 18, 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...

Schools & the university are closed, as are many restaurants and our gym at hotel Dreams. We went to Immigration today and they are only seeing people who made online appointments but it was quick and orderly. I saw a doctor on Monday at Clinica Alemana and again quick & orderly with an appointment. Pharmacies are sold out of Alcohol, Alcohol gel & Tylenol/paracetamol but otherwise fine. Antibacterial & Chlorox wipes seem to stay sold out. About 1/5 of people are wearing masks. Elbow bumps have replaced personal contact. Everything is organized and orderly but the streets still have more people than we expected. Notices on hand washing are everywhere. Our local supermarket is very well stocked.

How People are Coping

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

People are orderly and aware but only about 1/5 are wearing masks - At most. There are still significant numbers of people on the street and a lot of traffic. Buses, Colectivos & Taxis are running. Distance is being kept and people are bumping elbows instead of greeting with a kiss.

Changing Conditions as coronavirus Spreads

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

The change this week is very noticeable. Many Restaurants closed yesterday. The Dreams hotel closed their parking & Gym. Masks increase daily. Fewer people on the street and more people shopping more.

Government Response

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

Very very well. Organized, keeping everyone informed & closing public gathering spots like tourist venues, restaurants & malls. We visited immigration today and they changed to appointment only, no waiting in waiting room - only outside, extremely helpful and caring.

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...

Disaster! In California (my daughters live there) there is shelter in place but difficult to be tested. My family in Oklahoma & Florida have noticed NO CHANGE to life with bars and restaurants packed. My sister who teaches in Caligotnia was told some districts are open, others closed. And you can bring your kids to in-service events. My daughter was diagnosed at UCSF with bronchitis/pneumonia but they couldn't get access to Coronavirus test. Californians are flooding Tahoe area and no restrictions to movement. My daughter returned from London with respiratory problems and was not questioned at airport in anyway entering with global access. The US is doing nothing to effectively fight virus.

Supplies and Shortages

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

Here only shortage appears to be alcohol, gel and wipes. I purchased antibiotics two days ago.

Preparing for the Future

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

We are keeping 2-3 weeks of food. We have cash, full tank of gas, masks, alcohol, Listerine, Tylenol, Lysol, wipes which we keep in the car, toilet paper, extra laundry soap, and water.

Lockdown & Passing the Time

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

We can both work from home but we miss our gym . We are watching a lot more TV, YouTube and writing more email & teaching out to friends. We have joined an electronic library, and are improving our spanish.

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...

No - we have only US insurance but I visited the best hospital easily in Monday with an appointment I made Friday. It was busy but not very difficult and testing is on site. Visit was about US $25 & antibiotics were US $35

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...

All hospitals are private here. Mybinsurance covers me thoroughly in Chile but with co payments.

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...

Closest is Clinica Alemana and it is private but all Chilean hospitals are private.

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...

We are scheduled to depart June 3 rd anyway. If we can last we definitely prefer to be here.

Expat Health Insurance in Chile

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

Submitted By

CollegePath

CollegePath

View CollegePath's Profile

Comments & Questions

Sign In or Sign Up to reply

Cigna Expat Health InsuranceExpatriate Health Insurance

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

5-Expats-Talk-About-Living-in-Chile5 Expats Talk About Living in Chile

5 expats talk about what it's like living in Chile. Expats appreciate the focus on family in Chile, the strong work ethic and the slower pace of life.
5 expats talk about what it's like living in Chile. Expats appreciate the focus on family in Chile, the strong work ethic and the slower pace of life. ...

Expat-ChileExpat Chile: The Best Places to Live in Chile

Expats in Chile enjoy the country's beaches, beautiful cities and lower cost of living. Santiago, La Serena, Vina del Mar and other destinations top their favorite places to live in Chile.

Expats in Chile enjoy the country's beaches, beautiful cities and lower cost of living. Santiago, La Serena, Vina del Mar and other destinations top their favorite places to live in Chile....

Expats-in-Chile10 Tips for Living in Chile

Expats in Chile enjoy the stable economy, friendly people and relatively affordable cost-of-living. Many find becoming close friends with Chileans, who primarily socialize with family, a big challenge. But, the expat community in Chile is strong and offers a great support system for newcomers.

Expats in Chile enjoy the stable economy, friendly people and relatively affordable cost-of-living. Many find becoming close friends with Chileans, who primarily socialize with family, a big challeng...

Expats-in-Chile5 Important Tips about Healthcare for Expats in Chile

After considering their individual health, Expats moving to Chile should carefully consider the health care options where they'll live, and what else is available in the immediate vicinity.

After considering their individual health, Expats moving to Chile should carefully consider the health care options where they'll live, and what else is available in the immediate vicinity. ...

Moving-To-Puerto-VarasAn Expat Talks about Moving to Puerto Varas, Chile

An expat in Puerto Varas, Chile talks about moving to Chile with a few suitcases and a shipping container coming in six months. She and her husband lived in temporary housing and investigated areas to live in the south of Chile such as Pucon and Puerto Varas. They love their spacious, new home with amazing views of the lake and volcanoes.

An expat in Puerto Varas, Chile talks about moving to Chile with a few suitcases and a shipping container coming in six months. She and her husband lived in temporary housing and investigated areas t...

Chile 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 05-Jun-20 10:44 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.62.242
Host Name 172.69.62.242


Execution Time

Total Time Avg Time Count Template
355 ms 355 ms 1 /home/www/html/eetr/tip.cfm
296 ms 296 ms 1 /home/www/html/eetr/Application.cfm
122 ms 122 ms 1 /home/www/html/navtop_rdesign5.cfm
109 ms 109 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
46 ms 46 ms 1 /home/www/html/eetr/tipcoronavirus.cfm
28 ms 28 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/navcontentbox.cfm
27 ms 27 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
6 ms 6 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
1 ms 1 ms 1 /home/www/html/eetr/constants.cfm
1 ms 1 ms 1 /home/www/html/eetr/qry_GeneralSet.cfm
1 ms 1 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/rewritereport.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/eetr/datasources.cfm
0 ms 0 ms 3 /home/www/html/eetr/navconstants.cfm
0 ms 0 ms 2 /home/www/html/eetr/navinjection.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 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 1 /home/www/html/rewriteqoptionsctry.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
651 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 @ 22:44:03.003
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=293ms, Records=1) in /home/www/html/eetr/Application.cfm @ 22:44:03.003
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=4ms, Records=153) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:44:03.003
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:44:03.003
	Select *
	From citynetworks
	Where networkID = 30
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:44:03.003
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 30 
getpropertycountries (Datasource=tipripper, Time=46ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:44:03.003
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=35ms, Records=12) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:44:03.003
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 @ 22:44:03.003
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 = 80637 
and sitecategories.tipcategoryid = allreports.tipcategoryid
GetClassified (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:44:03.003
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 = 80637
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 @ 22:44:03.003
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 = 80637 
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:44:03.003
SELECT *
FROM topics

WHERE topicid = 17 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/navgettiplink.cfm @ 22:44:03.003
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '30'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/navgettiplink.cfm @ 22:44:03.003
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '30'
getlocationtag3 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/navgettiplink.cfm @ 22:44:03.003
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '1731'
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:44:03.003
	SELECT DISTINCT hpimg as photo, fbimg
	FROM answers
	WHERE answerid = 80637 
getsummary (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:44:03.003
	SELECT DISTINCT summaryprop as summary
	FROM answers
	WHERE answerid = 80637 
getbrief (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:44:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 80637 
	AND answerstext.qid = 392
	
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:44:03.003
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80637 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getsummary (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:44:03.003
	SELECT summary 
	FROM answers
	WHERE answerid = 80637 
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:44:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80637'
	and qid = 391
	
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:44:03.003
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.242'
and logtime > "2020-03-06"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 22:44:03.003
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.242'
and logtime > "2020-06-05 00:00:00.000"
and logtime < "2020-06-05 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 @ 22:44:03.003
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.242'
and logtime > "2020-05-29"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:44:03.003
	SELECT *
	From contentcountcountry
	Where networkid = 30 
gettopbanner (Datasource=expert, Time=2ms, Records=0) in /home/www/html/navleader_rdesign5.cfm @ 22:44:03.003
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-06-04"
    and fromDate < "2020-06-05"
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 22:44:03.003
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-06-04"
    and fromDate < "2020-06-05"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 22:44:03.003
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getpropertycountries (Datasource=tipripper, Time=27ms, Records=130) in /home/www/html/eetr/tip.cfm @ 22:44:03.003
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=5) in /home/www/html/eetr/tip.cfm @ 22:44:03.003
SELECT allreports.tipcategory, allreports.tipcategoryid, topicid
FROM allreports
WHERE rid = 100
AND allreports.networkid = 30
group by allreports.tipcategoryid 
CheckTrackings (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tip.cfm @ 22:44:03.003
  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 = 80637
  and t.tpcid = 80637
  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 @ 22:44:03.003
SELECT *
FROM topics
WHERE topicid = 17 
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tip.cfm @ 22:44:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 80637
	AND answerstext.qid = 391
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tip.cfm @ 22:44:03.003
SELECT userphoto, tipcount, username, aboutme 
FROM users
WHERE userid = 226071 
GetUserProfile (Datasource=forum, Time=111ms, Records=1) in /home/www/html/eetr/tip.cfm @ 22:44:03.003
  SELECT *
  FROM userprofiles
  WHERE userid = 226071 
getbrief (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/eetr/tip.cfm @ 22:44:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 80637
	AND answerstext.qid = 392
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tip.cfm @ 22:44:03.003
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80637 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getcategory (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tip.cfm @ 22:44:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 80637
	AND answerstext.qid = 390
getmostpostsreply (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tip.cfm @ 22:44:03.003
  SELECT msgtext, m.msgdate as commentdate, msgid, userid
  FROM comments m 
  WHERE m.tpcid = 80637
  and m.commenttype = 9
  and m.isapproved = 1
  ORDER BY m.msgid DESC
getanswerstext (Datasource=tipripper, Time=6ms, Records=12) in /home/www/html/eetr/tipcoronavirus.cfm @ 22:44:03.003
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 = 80637
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 80637 = answerstext.answerid 
ORDER BY topicquestions.order ASC
checkifexpert (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tipcoronavirus.cfm @ 22:44:03.003
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-04 22:44:03'}
and expertusers.enddate > {ts '2020-06-05 22:44:03'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 226071
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 @ 22:44:03.003
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-05 22:44:03'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 226071
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=1ms, Records=1) in /home/www/html/eetr/tipcoronavirus.cfm @ 22:44:03.003
SELECT username
FROM users
WHERE userid = 226071 
getauthorfirst (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tipcoronavirus.cfm @ 22:44:03.003
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 226071
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 @ 22:44:03.003
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 226071
and answerstext.qid = 96
and answers.reviewed = 'y'
and answerstext.answerid = answers.answerid
 
getmarker (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tipcoronavirus.cfm @ 22:44:03.003
	SELECT *
	FROM markers
	WHERE answerid = '80637'
	and lat <> ''
	and lng <> ''
getgender (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipcoronavirus.cfm @ 22:44:03.003
	SELECT DISTINCT qoid
	FROM answersmc
	WHERE answerid = 80637
	and qid = 302
	
gettour1 (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/eetr/tipcoronavirus.cfm @ 22:44:03.003
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80637'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
gettour2 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipcoronavirus.cfm @ 22:44:03.003
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80637'
	AND answersphoto.qid = '105'
	AND answersphoto.photo <> 'none'
gettour3 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipcoronavirus.cfm @ 22:44:03.003
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80637'
	AND answersphoto.qid = '106'
	AND answersphoto.photo <> 'none'
gettour4 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipcoronavirus.cfm @ 22:44:03.003
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80637'
 	AND answersphoto.qid = '107'
	AND answersphoto.photo <> 'none'
gettour5 (Datasource=tipripper, Time=2ms, Records=0) in /home/www/html/eetr/tipcoronavirus.cfm @ 22:44:03.003
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80637'
	AND answersphoto.qid = '108'
	AND answersphoto.photo <> 'none'
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:44:03.003
SELECT *
FROM natadoptions 
WHERE 'hiheader' = tag
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:44:03.003
	Select *
	From Networks
	Where networkid = 30 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:44:03.003
SELECT *
FROM natadoptions 
WHERE natadtypeid = 1 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:44:03.003
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 1
and natadPlacement.networkID = 30
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-06-04"
and headerparagraphstart < "2020-06-05"
and headerparagraphstatus = 'live'

and (headerparagraphweight = 'medium' or headerparagraphweight = 'high')
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:44:03.003
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-05"
     
         and rptarticlenetworks.networkid = 30 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 22:44:03.003
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 6
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 22:44:03.003
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 30 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:44:03.003
SELECT  hiimg
FROM rptarticles
where rptarticleID = 6
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=3) in /home/www/html/navcontentbox.cfm @ 22:44:03.003
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 30 
	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-05"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 22:44:03.003
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 30 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:44:03.003
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 30 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:44:03.003
		Select summary, hiimg 
		FROM answers
         where answerid = 74152
         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/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=80637&networkid=30&topicid=17
REMOTE_ADDR=172.69.62.242
REMOTE_HOST=172.69.62.242
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=29073410
cftoken=65447385
hitcount=1
lastvisit={ts '2020-06-05 22:44:03'}
timecreated={ts '2020-06-05 22:44:03'}
urltoken=CFID=29073410&CFTOKEN=65447385
Cookie Variables:
CFID=29073410
CFTOKEN=65447385
Session Variables:
cfid=29073410
cftoken=65447385
sessionid=IBEXPATEXCHANGE_29073410_65447385
urltoken=CFID=29073410&CFTOKEN=65447385
URL Parameters:
answerid=80637
networkid=30
topicid=17
Debug Rendering Time: 11 ms