Home Thailand Forum Thailand Guide Moving to Thailand Real Estate Healthcare in Thailand
Thailand
Resources
City Guides
JoinSign In
Cigna International Health Insurance

Healthcare in Thailand > 7 Healthcare & Health Insurance Tips for Expats in Thailand

7 Healthcare & Health Insurance Tips for Expats in Thailand

By Betsy Burlingame

Last updated on: Jul 29, 2017

Summary: Expats in Thailand share tips and advice about healthcare and health insurance in Thailand. Advice about hospitals in Thailand, the availability of prescription medicines, using Tricare in Thailand and more.

Expats in Thailand - 7 Healthcare & Health Insurance Tips for Expats in Thailand

Expats living in Thailand offer insight into the quality of healthcare in Thailand, health insurance, emergency medical insurance and the cost and availability of prescription medicines. Since many expats in Thailand are retirees, the quality and cost of healthcare in Thailand is a popular topic on our Thailand Expat Forum. Below are 7 healthcare tips from expats in Thailand to help those preparing to move and newcomers in Thailand.

Hospitals in Thailand

"Go to either St. Louis Hospital or Bumrungrad. The latter is a bit more expensive, but far, far cheaper than the USA and the care is just as good if not better," said one expat in a report about healthcare and health insurance in Bangkok.

"Many excellent hospitals in Chiang Mai ranging from cheap to moderately expensive. Many inexpensive street clinics everywhere you can just walk into for less complicated problems," explained one expat who retired in Chiang Mai.

An expat in Pattaya shared his private hospital experiences with a broken hand that required multiple surgeries. He said, "I live near Pattaya and have visited the Bangkok Pattaya Hospital many times. All of the doctors I have seen speak English. I broke my hand in two places. I had to wait 3 days for the hand surgeon to come from Bangkok. The emergency rooms are huge. There are no curtains that I saw. Any necessary medical tests required were administered and the results were known within minutes. Because I am older they were reticent to give me a general anesthesia. They wanted to give me a spinal block. I informed them that I had more than 6 surgeries and tolerated the drugs well. Of course, the costs are a lot less. All of the hospital rooms are private. There is an extra bed for a guest. The food was Western and prepared well. Wound care, after release, was daily. They set up appointments to come in daily for bandage changes. The bills had to be paid upon release. If you use American Express, they give a 10% discount on the drugs."

Health Insurance in Thailand

"We purchased medical insurance, called Thai Life, we have hospital stays only, as we are both healthy and don't take any kind of meds. And we feel that it is very cheap for doctor visit, teeth cleaning, etc. We can pay out of pocket," said one expat in Nonthaburi.

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

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

Finding a Good Doctor in Thailand

An expat in Bangkok offered the following advice for choosing a hospital or doctor, "1. compare hospital costs for same procedure 2. use hospital web sites to review medical bios of their doctors 3. consultations are inexpensive and a good way to evaluate doctors 4. use private hospitals for faster service and less waiting times 5. check availability of 3rd party billing for in-patient procedures. I have not needed to travel outside of Bangkok to see specialists or for serious health issues."

Emergency Medical Care in Thailand

"There are many private hospitals close in Bangkok; I use four ranging in distances of about 1 to 10 kilometers - Bangkok Medical Center; Bumrungrad; Mayo; and Vibhavadi. ER services so far have been very good and inexpensve. Traffic is a problem, so I have taken a taxi when possible to save time. Hospital care has been professional and more user friendly than US. I always use private, if available, for faster service," advised another expat.

Cost and Availability of Prescription Medicines in Thailand

"So far all the meds I have needed are available locally; if not in drug stores then at the hospitals. Some are available without prescritpion while others are not; not sure why? Non generics are just as expensive as in the US," commented one expat living in Bangkok.

When a newcomer asked for advice about his move to Thailand asked, "I take meds for high blood pressure, high cholesterol, thyroid and my heart. I read that you are only allowed to bring in a 30-day supply of medications. It mentions narcotics and/or psychotropic substances and has a list of forms and letters you need to provide for them. Does this mean that my daily medications don't require these strict guidelines since they aren't what they called Class 2, 3 and 4. Would I consider mine Class 1? Can someone tell me how to find out what medications fall into what class number?"

One expat responded, "[I am] not familiar with the classes, but I am permanently on medicine for high blood pressure, high cholesterol and heart. What are the names of the medicines you use and I can find out if they are available. You should be able to take your prescription to a hospital here, get a checkup and necessary tests and get a prescription that you can use over and over again here, and no need to order from abroad. I just get a checkup every three months or so and the doctor adjusts the medicine if necessary. Don't buy the medicine in the hospital unless you are too far from well stocked pharmacies."

Bringing Prescription Medicines into Thailand

In a topic entitled, taking prescription meds, another person asked, "I read online that only a month's worth of prescription meds can be brought into Thailand. However, I am of course going to be there for a year. Is there any way to get around this rule? Any other options worth considering?"

An expat replied, "Both gout and diabetes medications are plentiful, cheap and don't require a doctor's prescription. Pharmacists not carrying certain meds can order almost any medication from the major pharmaceutical companies. No sleeping meds."

"Buying the medication in Thailand may be legal, but bringing in a years supply of a drug without full documentation I would suspect would be illegal in any country. If they were to check and find a years supply, which must be a lot of pills, they might accuse you of smuggling in prescription drugs to sell on the black market, not a good idea at all. I did bring in an aweful lot of pills for diabetes and gout. I also was not questioned, but it's a risk," added another.

"Most pharmacists know enough English and can read the names of the medicines in English, and almost all medicine is packaged in Thai and English. You can also look up the medicine on the Internet and take screen captures to show to a pharmacist. The availability of medicine may, however depend on where you are located, so if you provide the city where you will be and the list of medicines, I may be able to locate pharmacies that carry a lot of prescription drugs," said another expat in Thailand.

Tricare for Retired US Military

Many retirees in Thailand are retired military. In a discussion about Tricare use in Thailand, one expat advised, "If you are referring to JUSMAGTHAI, it stands for the Joint United States Military Advisory Group, Thailand. It is a part of the U.S. mission to Thailand under the Embassy and is staffed with military personnel from Army, Navy and Air Force. There is a Retired Affairs Office (RAO) at the compound, which is located at 7 South Sathorn Road, Bangkok. There is also a Thai nurse at JUSMAG who should be able to answer questions about Tricare for Life (TFL), which is what Retirees overseas are on. The RAO Office is staffed by retiree volunteers and is only open limited hours. Be nice to them. They are under no contracts or obligations - strictly guys who want to help. The nurse or the RAO should be able to give you information about which hospitals accept Medicare (actually Tricare for Life), and how to transition from Medicare to TFL. I am pretty sure (but not positive) that Bangkok General Hospital and BNH (formerly known as Bangkok Nursing Home) accept TFL, but get that verified by Khun Pranee, the nurse at JUSMAG or someone at the RAO. You may also be eligible for a retiree mail box where you can get prescription drugs at JUSMAG, but I do not know the rules on that."

Another expat commented, "If you are eligible for Tricare for Life you can get coverage, but you have to pay up front and then file forms to get reimbursed amounts in excess of the deductible and co-pays. Tricare used to be accepted here at some hospitals, but because the U.S. Government was so slow paying, the local hospitals stopped accepting it. There are health insurance policies available in Thailand from a number of local sources, and if you live overseas you are not required to get Obamacare."

For more information about Healthcare in Thailand, read healthcare reports submitted by expats in our Expat Health Insurance & Healthcare Guide to Thailand.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Hospitals in Chiang MaiHospitals in Chiang Mai

Knowing which hospital you would go to should a medical emergency arise while living in Thailand is important. This information is provided (but not endorsed) by expats and the US Embassy in Thailand.

expat healthcare surveyAnswer Questions about Healthcare in Thailand

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

Having a Baby AbroadHaving a Baby Abroad Report

Being pregnant and giving birth abroad can be a bit unnerving. If you've had a baby abroad, please take a few minutes to answer a few questions about your experiences. Your insight will help to prepare other expat parents-to-be -- and hopefully calm their nerves.

Read Reports from Other Parents about their Childbirth experiences abroad.

About the Author

Betsy Burlingame Betsy Burlingame is the Founder of Expat Exchange. She launched Expat Exchange in 1997 as her Master's thesis project at NYU. Some of Betsy's more popular articles include 6 Best Places to Live in Costa Rica, 12 Things to Know Before Moving to The Dominican Republic and 7 Tips for Obtaining Residence in Italy. Betsy loves to travel and spend time with her family. Connect with Betsy on LinkedIn.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Join our Thailand Expat Forum

Visit our Thailand Forum and talk with other expats who can offer you insight and tips about living in , Thailand.

More about Thailand

Digital-Nomads-in-Bangkok,-Thailand

Living Abroad: Digital Nomads in Bangkok, Thailand

Digital nomads flock to Thailand for a variety of reasons, and Bangkok is one of the most popular options. Plentiful co-working spaces, good wifi, and amazing food are at the top of the list.

Digital nomads flock to Thailand for a variety of reasons, and Bangkok is one of the most popular options. Plentiful co-working spaces, good wifi, and amazing food are at the top of the list....

Digital-Nomads-in-Chiang-Mai,-Thailand

Living Abroad: Digital Nomads in Chiang Mai, Thailand

The number of people interested in becoming a digital nomad continues to grow, and Chiang Mai is considered by many to be one of the top destinations in the World. Find out why this city in Northern Thailand is so alluring to digital nomads throughout the world.

The number of people interested in becoming a digital nomad continues to grow, and Chiang Mai is considered by many to be one of the top destinations in the World. Find out why this city in Northern ...

6-Things-to-Know-Before-Moving-to-Thailand

Moving to Thailand: 6 Things to Know Before Moving to Thailand

Moving to Thailand requires a lot of research. There are many important considerations, and expats already living in Thailand are the best source of information. Here are some tips to help you explore whether or not moving to Thailand is right for you.

Moving to Thailand requires a lot of research. There are many important considerations, and expats already living in Thailand are the best source of information. Here are some tips to help you explo...

10-Best-Places-to-Teach-Abroad

10 Best Places to Teach Abroad

Anne Keeling highlights the 10 most popular cities for teaching overseas. From Dubai to Bangkok, Doha to Shanghai.

Anne Keeling highlights the 10 most popular cities for teaching overseas. From Dubai to Bangkok, Doha to Shanghai. ...

5-Reasons-to-Move-to-Thailand

Expat Thailand: 5 Reasons to Move to Thailand

Expats in Bankok, Thailand enjoy a wonderful lifestyle for a variety of reasons. Emily McClaren explores why it is a popular destination for expats from all over the world.

Expats in Bankok, Thailand enjoy a wonderful lifestyle for a variety of reasons. Emily McClaren explores why it is a popular destination for expats from all over the world....

Chiang-Mai,-Thailand

Chiang Mai, Thailand

Expats share what it's like living in Chiang Mai and why they move there. With its large expat community of missionaries, retirees, expat families and teachers, Chiang Mai is attractive for many reasons: its size, friendly people, low cost of living and good healthcare.

Expats share what it's like living in Chiang Mai and why they move there. With its large expat community of missionaries, retirees, expat families and teachers, Chiang Mai is attractive for many rea...

International-Schools-in-Chiang-Mai

International Schools in Chiang Mai

If you're moving to Chiang Mai with kids, here's are some of the best international schools according to expats.

If you're moving to Chiang Mai with kids, here's are some of the best international schools according to expats....

Digital-Nomads-in-Bangkok,-Thailand

Living Abroad: Digital Nomads in Bangkok, Thailand

Digital nomads flock to Thailand for a variety of reasons, and Bangkok is one of the most popular options. Plentiful co-working spaces, good wifi, and amazing food are at the top of the list.

Digital nomads flock to Thailand for a variety of reasons, and Bangkok is one of the most popular options. Plentiful co-working spaces, good wifi, and amazing food are at the top of the list....

Digital-Nomads-in-Chiang-Mai,-Thailand

Living Abroad: Digital Nomads in Chiang Mai, Thailand

The number of people interested in becoming a digital nomad continues to grow, and Chiang Mai is considered by many to be one of the top destinations in the World. Find out why this city in Northern Thailand is so alluring to digital nomads throughout the world.

The number of people interested in becoming a digital nomad continues to grow, and Chiang Mai is considered by many to be one of the top destinations in the World. Find out why this city in Northern ...

5-Tips-for-Living-in-Bangkok

5 Tips for Living in Bangkok

Expats living in Bangkok enjoy a bustling city that is the most populous city in Thailand. Over the last several decades Bangkok has become an important regional business hub for Southeast Asia.

Expats living in Bangkok enjoy a bustling city that is the most populous city in Thailand. Over the last several decades Bangkok has become an important regional business hub for Southeast Asia....

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Comments about this Article

ITSMYTIME
Jul 29, 2017 19:34

Greetings Betsey! Just a note to say thank you for this article very helpful. My husband and I are thinking about a 6 month stay to see if we like it and if so will consider selling our farm and moving permanently if possible. He had a heart transplant last year and is doing very well. Having said that, of course we are interested greatly in the medical system and the insurance. We're both in mid 60's and on Medicare with a BCBS supplement so here in Florida we don't have to pay for anything. Just need to look into a comparable insurance.. Again, thank you so much! Florence

First Published: Jun 07, 2017

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Hospitals in Chiang MaiHospitals in Chiang Mai

Knowing which hospital you would go to should a medical emergency arise while living in Thailand is important. This information is provided (but not endorsed) by expats and the US Embassy in Thailand.

healthcare surveyAnswer Questions about Healthcare in Thailand

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

Having a Baby AbroadHaving a Baby Abroad Report

Being pregnant and giving birth abroad can be a bit unnerving. If you've had a baby abroad, please take a few minutes to answer a few questions about your experiences. Your insight will help to prepare other expat parents-to-be -- and hopefully calm their nerves.

Read Reports from Other Parents about their Childbirth experiences abroad.

Thailand 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 /lib_rd.cfm
Time Stamp 03-Jul-20 09:19 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.195
Host Name 172.69.63.195


Execution Time

Total Time Avg Time Count Template
117 ms 117 ms 1 top level /home/www/html/lib_rd.cfm
49 ms 49 ms 1 /home/www/html/navcontentboxhealthcaremobile.cfm
17 ms 17 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
16 ms 16 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
15 ms 15 ms 1 /home/www/html/lib_rd_ctrygd_readnext.cfm
15 ms 15 ms 1 /home/www/html/navcontentboxhealthcarepc.cfm
8 ms 8 ms 1 /home/www/html/commentsnew_rdesign4.cfm
8 ms 8 ms 1 /home/www/html/navtop_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
4 ms 4 ms 1 /home/www/html/navbottomad_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 1 ms 2 /home/www/html/nativerotationtop_tester13.cfm
1 ms 1 ms 1 /home/www/html/breadcrumb.cfm
1 ms 1 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/navmpu_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/boolsearch.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/constants.cfm
0 ms 0 ms 6 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/natad/native_4957_62921.txt
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 14 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/datasources.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
122 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm @ 09:19:36.036
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 09:19:36.036
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 09:19:36.036
	Select *
	From articles
	Where articleID = 4957
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 09:19:36.036
	Select *
	From sponcers
	Where sponcerID = 287 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 09:19:36.036
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 4957 
	and articles.articleID = 4957 
	and articlePlacement.networkID = Networks.networkID
	and articles.hinet = 'y'
  and (articles.general = 'no' or articles.general = 'city')
    and articles.hitopic <> ''
    and articles.hidescript <> ''
	and isCity <> "hold"
	AND networktype <> 2
	AND networktype <> 3
	AND networktype <> 4
	AND networktype <> 5
	AND networkname <> 'national'
	AND networkname <> 'Global Listing'
	AND (isCity = 'Country') 
citystatus (Datasource=expert, Time=0ms, Records=0) in /home/www/html/lib_rd.cfm @ 09:19:36.036
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 4957
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 4957
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 09:19:36.036
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 09:19:36.036
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 108 
getcities (Datasource=expert, Time=1ms, Records=6) in /home/www/html/navmeta_rdesign4.cfm @ 09:19:36.036
	Select *
	From citynetworks
	Where networkID = 108
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 09:19:36.036
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
commentcount (Datasource=forum, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 09:19:36.036
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 4957 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid DESC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 09:19:36.036
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.195'
and logtime > "2020-04-03"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 09:19:36.036
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.195'
and logtime > "2020-07-03 00:00:00.000"
and logtime < "2020-07-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 @ 09:19:36.036
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.195'
and logtime > "2020-06-26"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 09:19:36.036
	SELECT *
	From contentcountcountry
	Where networkid = 108 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 09:19:36.036
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-02"
    and fromDate < "2020-07-03"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 09:19:36.036
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb.cfm @ 09:19:36.036
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4957 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 09:19:36.036
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 4957 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 09:19:36.036
SELECT tag
FROM natadoptions 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 09:19:36.036
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 09:19:36.036
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 09:19:36.036
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 108
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-02"
and natsentencestart < "2020-07-03"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 09:19:36.036
SELECT *
FROM natadoptions 
WHERE 'medsentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 09:19:36.036
SELECT *
FROM natadoptions 
WHERE natadtypeid = 32 
getnatadbottom (Datasource=expert, Time=0ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 09:19:36.036
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 32
and natadPlacement.networkID = 108
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-02"
and natsentencestart < "2020-07-03"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 09:19:36.036
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 32
and natadPlacement.networkID = 108
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-02"
and natsentencestart < "2020-07-03"
and natsentencestatus = 'live'
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 108 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
   and articleCategories.section = '9'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    
    and articles.articleID <> '4957'
	
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-03"
     ORDER by articles.sectionintro DESC, articles.articleID desc 
 
gethospitals (Datasource=expert, Time=8ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 108 
		and (((title LIKE '%hospital%') OR (hitopic LIKE '%hospital%') OR (hidescript LIKE '%hospital%')))
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '22'
   and articleCategories.section = '9'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    
    and articles.articleID <> '4957'
	
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-03"
     ORDER by articles.title
 
GetClassifieds (Datasource=tipripper, Time=12ms, Records=3) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
SELECT *
FROM allreports, Networks, answers
WHERE allreports.rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 7
and hide <> 'y'
and allreports.networkid = 108 
and answers.answerid = allreports.answerid
and answers.reviewed = 'y'

    ORDER by allreports.answerid desc
    
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
SELECT *
FROM topics
WHERE topicid = 7 
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
	SELECT summary as answer
	FROM answers
	WHERE answerid = 80519 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 80519 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 80519 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '108'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
	SELECT summary as answer
	FROM answers
	WHERE answerid = 76833 
getbrief (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 76833 
	AND answerstext.qid = 409
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 76833 
getphoto (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 108
	and fbimg <> ''
	
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 76833 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '108'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65981 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65981 
getphotos (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65981 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '108'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
	SELECT summary as answer
	FROM answers
	WHERE answerid = 80519 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 80519 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 80519 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '108'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
	SELECT summary as answer
	FROM answers
	WHERE answerid = 76833 
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 76833 
	AND answerstext.qid = 409
	
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 76833 
getphoto (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 108
	and fbimg <> ''
	
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 76833 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '108'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:36.036
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65981 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:37.037
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65981 
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:37.037
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65981 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 09:19:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '108'
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 09:19:37.037
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4957 
gettaxgeneral3 (Datasource=expert, Time=8ms, Records=5) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 09:19:37.037
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 108 
	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 keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and articles.articleID <> 4957
    and publishdate < "2020-07-03"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID desc
    
gettaxgeneral4 (Datasource=expert, Time=5ms, Records=5) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 09:19:37.037
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articlecityplace
	Where hitopic <> ''
	and articlePlacement.networkID = 108 
	AND articlePlacement.articleID = articles.articleID
		and articlecityplace.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.articleID <> 4957
    and publishdate < "2020-07-03"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID desc
    
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 09:19:37.037
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-02"
    and fromDate < "2020-07-03"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 09:19:37.037
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
gethpbox (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 09:19:37.037
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-07-02 09:19:37'}
    and fromDate <{ts '2020-07-03 09:19:37'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 09:19:37.037
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 09:19:37.037
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 4957 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 09:19:37.037
  SELECT *
  FROM users
  WHERE userid = 193100 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 09:19:37.037
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4957 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
	SELECT summary as answer
	FROM answers
	WHERE answerid = 80519 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 80519 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
	SELECT summary as answer
	FROM answers
	WHERE answerid = 76833 
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 76833 
	AND answerstext.qid = 409
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 76833 
getphoto (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 108
	and fbimg <> ''
	
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 7 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 76833 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '108'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65981 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65981 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
	SELECT summary as answer
	FROM answers
	WHERE answerid = 80519 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 80519 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
	SELECT summary as answer
	FROM answers
	WHERE answerid = 76833 
getbrief (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 76833 
	AND answerstext.qid = 409
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 76833 
getphoto (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 108
	and fbimg <> ''
	
getphotos (Datasource=reports, Time=1ms, Records=0) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 76833 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '108'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65981 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 09:19:37.037
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65981 


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/lib_rd.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/lib_rd.cfm
QUERY_STRING=articleID=4957&networkid=108
REMOTE_ADDR=172.69.63.195
REMOTE_HOST=172.69.63.195
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/lib_rd.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Session Variables:
cfid=30925739
cftoken=59367720
sessionid=IBEXPATEXCHANGE.COM_30925739_59367720
urltoken=CFID=30925739&CFTOKEN=59367720
URL Parameters:
articleID=4957
networkid=108
Debug Rendering Time: 14 ms