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

Coronavirus in Pasay, Vilamor, Philippines

Guest Submission

Read & Post Comments

Coronavirus-in-Passay,-Vilamor,-Philippines

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

Sheltering in place, no transportation is allowed. Last international flights leave today.

I decided to shelter in place.

The supermarket remains open earlier than we wake up until 8pm. Lines are long, but this place is so inefficient normally that this is not a huge change.

All the necessaries are still available, minus face masks and limited hand sanitizer.

How People are Coping

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

Filipinos? They are singing karaoke, making make shift swimming pools and setting up low stakes card games on their porches.

I chose to live in a poor area, in a nice apartment. There are tiny markets all over the place, and are my preference instead of the large crowded market.

Changing Conditions as coronavirus Spreads

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

Nothing really changed until the lockdown. Lockdown means people are basically where they are now and that will not change.

Government Response

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

Lockdown seems to be enforced efficiently, if a little haphazard at the beginning. The necessities and niceties: Water, Power, Markets and high speed internet still function well. I think this is a prudent step and is going as well as can be expected.

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

Nothing as far as a I know. I think expats are always welcome back with a possible self-quarantine. But the last international flight leaves today (without me) so it does not matter much.

Supplies and Shortages

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

Just masks and hand sanitizer. These masks: https://www.bkreader.com/2020/03/07/heres-a-diy-way-to-make-your-own-protective-face-mask/ can be readily made from available supplies. There is a link to making hand sanitize also. Remember soap works also.

Preparing for the Future

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

Bought 20 water cooler sized purified water containers. Three medium trash cans and 4 five gallon buckets to store non-potable water. Two 15kg packs of rice. Long term food, about $250 worth which is a huge amount in Philippines. Went to ATM for $2000 USD in cash. Downloaded entertainment in case internet goes down. Helped a few Filipinos with cash so they can prepare a bit without work. Plenty of butane for off-grid cooking Updated family abroad.

Lockdown & Passing the Time

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

Internet games, and have two Filipina staying with me.

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? He replied...

N/A

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

yes. Don't know

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? He replied...

No idea.

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

Considered it. Not convinced America will handle this better. The flight is likely more dangerous than staying in place.

Advice for People Outside of Pasay, Vilamor, Philippines

We Asked: If you live in an area already heavily affected by coronavirus, what advice would you share with others elswhere in the world who may be facing the same challenges in the future. He replied...

Stay Home

Expat Health Insurance in Philippines

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

Submitted By

Guest User

Sign In or Sign Up to reply

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Culture-Shock-in-Santa-Rosa-City,--LagunaAn Expat Talks about Culture Shock & Living in Santa Rosa City, Laguna, Philippines

An expat in Santa Rosa City, Philippines appreciates the friendliness of the people, close knit families, low crime and conservative morality of the locals. He finds that merchandise is mostly from China and of the poorest quality (the better products end up in the US!).

An expat in Santa Rosa City, Philippines appreciates the friendliness of the people, close knit families, low crime and conservative morality of the locals. He finds that merchandise is mostly from C...

Living-in-Surigao-CityAn Expat Discusses Living in Surigao City, Philippines

An expat living in Surigao City in the Philippines offers advice on the costs of living there, what the people are like and more.

An expat living in Surigao City in the Philippines offers advice on the costs of living there, what the people are like and more....

10-Tips-for-Living-in-The-Philippines10 Tips for Living in The Philippines

Expats seem to unanimously agree that the best thing about living in the Philippines is the Filipino people. The cost of living is another thing to love. Expats share their tips and experiences living in The Philippines.

Expats seem to unanimously agree that the best thing about living in the Philippines is the Filipino people. The cost of living is another thing to love. Expats share their tips and experiences livi...

5-Great-Places-to-Retire-in-Asia5 Great Places to Retire in Asia

We asked expats and searched our forums for recommendations about where to retire in Asia. We pinpointed countries with affordable costs of living and have five great retirement locations. Please add your recommendations in the comments section!

We asked expats and searched our forums for recommendations about where to retire in Asia. We pinpointed countries with affordable costs of living and have five great retirement locations. Please ad...

6-Best-Places-to-Live-in-The-PhilippinesExpat Philippines: 6 Best Places to Live in The Philippines

With its low cost of living, beautiful beaches, bustling cities and hot climate, expats have been flocking to the Philippines for years. Here are six of the best places for expats to live in the Philippines.

With its low cost of living, beautiful beaches, bustling cities and hot climate, expats have been flocking to the Philippines for years. Here are six of the best places for expats to live in the Phil...

5-Tips-for-Expats-Living-in-the-Philippines5 Tips for Expats Living in the Philippines

Expats may share some gripes about living in the Philippines, but most agree that one thing makes up for all of the challenges. Can you guess what it is?
Expats may share some gripes about living in the Philippines, but most agree that one thing makes up for all of the challenges. Can you guess what it is?...

Philippines 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 03-Jun-20 12:08 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
331 ms 331 ms 1 /home/www/html/eetr/tip.cfm
290 ms 290 ms 1 /home/www/html/eetr/Application.cfm
102 ms 102 ms 1 /home/www/html/navtop_rdesign5.cfm
95 ms 95 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
44 ms 44 ms 1 /home/www/html/eetr/tipcoronavirus.cfm
29 ms 29 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
28 ms 28 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/navcontentbox.cfm
2 ms 2 ms 1 /home/www/html/eetr/navgettiplink.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/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
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 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereport.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
622 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:08:14.014
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=288ms, Records=1) in /home/www/html/eetr/Application.cfm @ 12:08:14.014
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=2ms, Records=153) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:08:14.014
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=2ms, Records=6) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:08:14.014
	Select *
	From citynetworks
	Where networkID = 90
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:08:14.014
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 90 
getpropertycountries (Datasource=tipripper, Time=44ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:08:14.014
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:08:14.014
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 @ 12:08:14.014
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 = 80639 
and sitecategories.tipcategoryid = allreports.tipcategoryid
GetClassified (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:08:14.014
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 = 80639
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 @ 12:08:14.014
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 = 80639 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:08:14.014
SELECT *
FROM topics

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

and headerparagraphweight = 'high'
checkculturefeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 12:08:15.015
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 90 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 12:08:15.015
		Select summary, hiimg 
		FROM answers
         where answerid = 70614
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=3) in /home/www/html/navcontentbox.cfm @ 12:08:15.015
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 90 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 12:08:15.015
		Select summary, hiimg 
		FROM answers
         where answerid = 69448
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 12:08:15.015
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 90 
	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-03"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 12:08:15.015
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-03"
     
         and rptarticlenetworks.networkid = 90 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 12:08:15.015
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 21
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 12:08:15.015
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 90 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 12:08:15.015
SELECT  hiimg
FROM rptarticles
where rptarticleID = 21
and hiimg <> ''


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=80639&networkid=90&topicid=17
REMOTE_ADDR=162.158.78.194
REMOTE_HOST=162.158.78.194
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=28936947
cftoken=10750215
hitcount=1
lastvisit={ts '2020-06-03 12:08:14'}
timecreated={ts '2020-06-03 12:08:14'}
urltoken=CFID=28936947&CFTOKEN=10750215
Cookie Variables:
CFID=28936947
CFTOKEN=10750215
Session Variables:
cfid=28936947
cftoken=10750215
sessionid=IBEXPATEXCHANGE_28936947_10750215
urltoken=CFID=28936947&CFTOKEN=10750215
URL Parameters:
answerid=80639
networkid=90
topicid=17
Debug Rendering Time: 10 ms