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

Coronavirus in Memphis, Tennessee, US

By cmgmemphis

Read & Post Comments

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

TN has declared a state of emergency and has asked residents to work from home if possible, stay home, and has restricted gatherings of more than 50 people. Schools in the greater Memphis area are all closed for two weeks starting today and most other areas of the state are closing schools. Last week was crazy in the grocery stores with people thinking they would be quarantined so hoarding began. I went to grocery this morning and got what I need for a week or so with no issues.

The biggest issue that government is trying to resolve is the slow ability to test people who have been exposed to COVD-19 or is showing any symptoms of COVID-19. The mid-day news just indicated that 2 millions test kits will be distributed today or tomorrow to the states will more being produced. We are all hoping that with people cooperating in not gathering in large groups, staying away from family and friends who are over 60 years old or anyone with immune system issues. Unfortunately there is a large part of the citizens who still think this is fake and not something they should be concerned about.

On a national level US citizens or green card holders can continue entering the US but may be required to enter a 14 day quarantine. The biggest issue for those wanting to return to the US will probably be the lack of flights coming to the US from abroad.

We had a trip to Las Vegas planned before this occurred but as of tomorrow casinos and their hotels, restaurants in those properties, etc will all be closing for at least 2 weeks with some casinos saying they hope to reopen in April sometime. Airlines for the most part have been great in issuing vouchers for cancellation of flights and no cancellation fees. I personally know that MGM Resorts is automatically canceling all reservations through March 31 & issuing refunds.

How People are Coping

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

The majority are following suggestions to stay at home, work at home, etc. However, there is a large group of Americans that still thinks it's fake news and they shouldn't be worried about it.

Changing Conditions as coronavirus Spreads

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

People are finally listening to the specialists who have finally gotten to discuss this openly with the press and on tv, Initially the President said the virus was nothing to be concerned about and that it would be gone in less than a week. He also would not allow the CDC or the specialists to make any announcements without it being reviewed by the White House. As soon as more people got sick and people starting dying, the specialists starting speaking out and taking more control.

Government Response

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

City, county and state governments have led in discouraging group activities and declaring states of emergency to both get people's attention and to access funds available for such issues. There was no preparation by the US government due to the existing President closing down a huge portion of the CDC two years ago because he thought research wasn't needed. The state of TN was only given 100 tests initially, and that has continued to slowly increase. More places are being certified to both test and process tests with the newest ones coming out this week provide test results in just a few hours compared to two days up to now.

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

The US announcements were not done properly and many people overseas panicked thinking they had to return to the US from Europe by a certain date. The major airports in the US weren't prepared at all to get people through immigration and do any significant testing and it was taking as much as 5 hours to get through.

Supplies and Shortages

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

There is still a shortage of testing kits and labs certified to do the tests. This is slowly improving but even if you believe you've been exposed or have symptoms it's not easy to get tested.

In Memphis, there was a run on the grocery stores which wiped out all supplies and food. Today I was at grocery store and lots of stockers were putting out as much as possible.

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 seniors and are staying at home as much as possible. We have food for at least two weeks, medicine for 90 days and have canceled any trips we had planned.

Lockdown & Passing the Time

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

Yes. TV, online movies, reading, Facebook, websites that provide info on what's going on outside of the US. Weather is warming up so will be nice to sit out on our deck and watch the birds.

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

We are seniors and have a Medicare Advantage insurance (public/private) plan that is managed by Blue Cross/Blue Shield TN and have been assured that we are covered should be contract Covid-19. Our concern is not right now as it will be as Covid-19 patients overrun the hospitals and people with other emergencies have no place to go. Hopefully, the military will be activated to begin setting up temporary hospitals where Covid-19 patients can be initially handled to keep them separated from other patients. There will be a dire shortage of ventilation machines also.

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 will have the same issues with lack of emergency room space, lack of beds, lack of ventilation equipment and staff shortages as the virus spreads.

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

We have several hospitals in Memphis any of which would be a good choice. We are covered to go to any hospital available for the problem we may need hospitalization for. There will need to be temporary hospital facilities created along with places where people can be quarantined if diagnosed with Covid-19. Discussions are now beginning about finding hotels that could be converted to quarantine facilities. It will be critical to separate the ill from the well to slow down the spread of the virus. Currently people are being quarantined at home but this won't work as more of the population gets the virus.

Expat Health Insurance in United States

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

Submitted By

cmgmemphis

cmgmemphis

View cmgmemphis'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 United States from our partner, Cigna Global Health.
Get a Quote

Expat-New-YorkExpat New York: 10 Tips for Living in New York City

Expats in New York City will quickly find that New Yorkers defy their stereotypes. New York is a melting pot of people from every corner of the globe and every income level -- all brought together by the city's subway system. Some expats enjoy living right in the hustle and bustle of the city. Others choose to enjoy a bit more greenery and space in a suburb on New York.

Expats in New York City will quickly find that New Yorkers defy their stereotypes. New York is a melting pot of people from every corner of the globe and every income level -- all brought together by...

Expats-New-YorkExpat New York: Public Transportation Options

Expats living in the New York Metropolitan area have a variety of public transportation options. Learn about the rail and bus systems near your home - or where you will live.

Expats living in the New York Metropolitan area have a variety of public transportation options. Learn about the rail and bus systems near your home - or where you will live....

Expat-New-YorkExpat New York: Top 10 Things To Do For Expats Living in New York City

Expats in New York City will learn a lot about the culture and people of New York if they get out and do some exploring. Here are 10 things to do that will help get you quickly settled.

Expats in New York City will learn a lot about the culture and people of New York if they get out and do some exploring. Here are 10 things to do that will help get you quickly settled....

Moving-To-Saipan-(not-really-Guam,-but-not-listed-anywhere)An Expat Talks about Moving to Saipan (not really Guam, but not listed anywhere), United States

An expat in Saipan describes Saipan as a beautiful, broken paradise. She urges people to visit before moving to Saipan. When you move, find a full concrete home with storm shutters and a backup generator to weather cyclones. She talks about the cost of living, what to bring and leave at home and water shortages.

An expat in Saipan describes Saipan as a beautiful, broken paradise. She urges people to visit before moving to Saipan. When you move, find a full concrete home with storm shutters and a backup gener...

United States 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:40 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.60
Host Name 162.158.78.60


Execution Time

Total Time Avg Time Count Template
332 ms 332 ms 1 /home/www/html/eetr/tip.cfm
297 ms 297 ms 1 /home/www/html/eetr/Application.cfm
107 ms 107 ms 1 /home/www/html/navtop_rdesign5.cfm
101 ms 101 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
45 ms 45 ms 1 /home/www/html/eetr/tipcoronavirus.cfm
25 ms 25 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
24 ms 24 ms 1 /home/www/html/navcontentbox.cfm
24 ms 24 ms 1 /home/www/html/navrightmidcolumn_rdesign5.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/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/eetr/constants.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 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 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 1 /home/www/html/rewritereport.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
629 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:40:31.031
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=294ms, Records=1) in /home/www/html/eetr/Application.cfm @ 22:40:31.031
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=2ms, Records=153) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:40:31.031
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=2ms, Records=19) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:40:31.031
	Select *
	From citynetworks
	Where networkID = 129
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:40:31.031
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 129 
getpropertycountries (Datasource=tipripper, Time=44ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:40:31.031
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 @ 22:40:31.031
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:40:31.031
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 = 80625 
and sitecategories.tipcategoryid = allreports.tipcategoryid
GetClassified (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:40:31.031
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 = 80625
and allreports.statenetworkid = Networks.networkid
and allreports.citynetworkid = citynetworks.citynetworkid
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:40:31.031
SELECT *
FROM topics

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

and headerparagraphweight = 'high'
checkrptarticles (Datasource=reports, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 22:40:31.031
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-05"
     
         and rptarticlenetworks.networkid = 129 
    ORDER by rptarticles.rptarticleID asc   
    
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 22:40:31.031
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 129 
	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:40:31.031
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 129 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentbox.cfm @ 22:40:31.031
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 129 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:40:31.031
		Select summary, hiimg 
		FROM answers
         where answerid = 74109
         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=80625&networkid=129&topicid=17
REMOTE_ADDR=162.158.78.60
REMOTE_HOST=162.158.78.60
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=29073151
cftoken=78424121
hitcount=1
lastvisit={ts '2020-06-05 22:40:31'}
timecreated={ts '2020-06-05 22:40:31'}
urltoken=CFID=29073151&CFTOKEN=78424121
Cookie Variables:
CFID=29073151
CFTOKEN=78424121
Session Variables:
cfid=29073151
cftoken=78424121
sessionid=IBEXPATEXCHANGE_29073151_78424121
urltoken=CFID=29073151&CFTOKEN=78424121
URL Parameters:
answerid=80625
networkid=129
topicid=17
Debug Rendering Time: 14 ms