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

Healthcare in China > 6 Important Tips about Healthcare for Expats in China

6 Important Tips about Healthcare for Expats in China

By Betsy Burlingame

May 03, 2018

Summary: Expats living in China discuss health insurance and quality of medical care in China. Tip 1: if you're going to the hospital in China (or to a doctor), bring a translator!

Expat China - 6 Important Tips about Healthcare for Expats in China

When we asked expats living in China about their experiences with healthcare, many talked about the cleanliness of hospitals, caring doctors and the high cost of prescription medicines in China. Here are 6 healthcare tips for expats in China:

Bring a Translator or Find a Doctor Who Speaks English

"It is IMPERATIVE that you speak Chinese or else you need to take someone who is FLUENT in Chinese as an interpreter. Some doctors speak English (or rather Chinglish) and communication is critical in receiving appropriate medical care. Also, be aware that the average Chinese person most likely will not have the medical vocabulary, so unless you have a medical interpreter, communication will still be challenging, but it will be better than nothing," commented one expat living in Shenzhen, China.

"It is difficult unless you have someone who speaks English go with you to explain the problem. After that it is easy. The hospitals went out of their way to set me up with doctors that have some English ability. In one case, they called in someone like an orderly who had been to America for college and was very good at English and he was a big help," advised one expat.

Hospitals in China

"I went to Guangzhou Modern Hospital in Guangzhou because they specialize in treatments for cancer and other serious diseases. The population of Shenzhen is still very young overall, so I was advised by a specialist doctor at Peking University Hospital to go to Guangzhou for follow-up to my cancer surgery. Although the doctors and many of the staff spoke decent English, I was provided with a medical translator. The doctors were very caring, professional and extremely knowledgeable with outstanding qualifications. However, the facility was old, and, by Western standards, not very clean. I think having good doctors is more important that a fancy medical facility," commented one expat living in Shenzhen, China.

"In addition to a number of smaller local clinics, there are 2 BIG hospitals in Shenzhen. The main hospital is Peking University Hospital (Shenzhen), sometimes referred to as Beijing University Hospital by locals. The other is Hong Kong University Hospital (Shenzhen). Both are readily accessible by either bus or metro. Both are public. I have had extensive experience in both hospitals, so the following information is based on my personal experience. Peking University Hospital is older and services the masses. However, they have a VIP service area (6th floor) and will provide a medical interpreter. Although you will not find very many foreigners at this hospital, the staff overall is very helpful and professional. In fact, I felt extremely well-cared for and was treated with respect, but privacy and cleanliness can be an issue. For the most part, the Chinese have no concept of personal space or privacy, so if you don't have anyone with you to guard the door, people will literally barge into exam rooms as they are anxiously waiting their turn. However, knowing this in advance, you can establish boundaries and maintain a respectable degree of privacy. The medical staff and even patients will do their best to try and help you. In terms of hygiene standards, please bear in mind that this is China. As I stated, this hospital serves the masses, but they do their best to keep it clean, which still pales in comparison to any hospital or clinic you would find in USA. Again, the staff is extremely helpful and the quality of care was outstanding. Hong Kong University Hospital (Shenzhen), is very new, but still public. It is not as centrally located as the other hospital and therefore, is not as busy. Also, as it is new, it is much cleaner. HOWEVER, regardless of what you are told by local Chinese, VERY FEW GENERAL STAFF SPEAK ENGLISH. But they do have some English speaking doctors," said one expat.

"Yes and not as expensive as US. Must go to major hospital for clean facilities and care. One hospital we visited an old family friend in was comparable to what I would expect to find in a poor part of Tijuana, Mexico. I had 3 crowns and a root canal done on my teeth for $1,200 total and that was a month ago and everything is fine," said one expat living in Xi'An, China.

Cost of Medical Care in China

"I have been three times to the hospital. Once to have a mole removed and have it biopsied about 1,200 yuan including anti-biotics or about $200. Another time was for an eye infection about 200-300 yuan for medicine (office visits are almost free) and to have a new prescription for my eyeglasses which had to be done at the hospital. I paid $0.50 for the exam (not to sure if they meant to charge more, they wanted me to buy the glasses there but they wanted 3,500 yuan about $581 USD (I do need progressive lenses and am very far sighted (+7 to +9 diopter correction I can barely make out the letters at the top of the eyechart!) I said 'No way' and left. I later bought them for 1,028 yuan ($170USD)," said one expat.

Cost & Availability of Prescription Medicine in China

When you ask expats about the cost of prescription medicines, you get differing experiences. If you are considering a move and take prescription medicines for chronic conditions, do you research before you move to avoid sticker shock.

"Prescription medication in China is very expensive. I have diabetes, high blood pressure and cholesterol. For $30 USD, I got my medicine in the USA for 90 days. Here it runs about 400 yuan for 30 days or about $66 USD," explained another expat in China.

"There are pharmacies located throughout the city and within both major hospitals. I was prescribed a variety of medications, but only took a few. Compared to medications in the USA they are NOT expensive," commented one expat living in Shenzhen, China.

Expats living in China 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 China interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA.

Having a Baby in China

"I went to a foreign hospital. The care was the same and even better than what I would have had in Europe. The Chinese people are really attentive with pregnant women," said one expat living in Shanghai, China.

"I gave birth via c-section at VIP Birthing Center in Guangzhou. I stayed in hospital for 5 days and was given IV pain relief. It was a wonderful experience, the staff spoke some English and my husband was able to stay the entire week in our private room," mentioned another expat in China.

"I went to Shanghai East International in Pudong. I had a wonderful experience! I choose a British doctor and all my wishes and requests were fulfilled. I had a natural birth with an epidural. 10 hours labor. The staff was great! They spoke English very well. I was treated like I was in 5 star hotel. Get in touch with other expats that have similar requirements as you of comfort, language and expectation of service. Interview different doctors and trust your heart. Ask as many questions that comes to mind before making a decision of the hospital," commented one expat who made the move to China.

"Be open to a c-section delivery as almost everyone I know that delivered here were convinced to have one (6 out of 7 women)," mentioned another expat in China.

"Get in touch with other expats that have similar requirements as you of comfort, language and expectation of service. Interview different doctors and trust your heart. Ask as many questions that comes to mind before making a decision of the hospital," commented one expat who made the move to China.

Expat Health Insurance in China

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

Share Your Experiences with Healthcare in China

In our China Healthcare Guide, expats can help other expats by filling out a Healthcare Report.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Healthcare in ShenzhenHealthcare in Shenzhen, China

An expat in Shenzhen, China discusses health care and health insurance in Shenzhen. She advises expats who don't speak Chinese fluently to bring a someone who is fluent with them to doctor's appointm

expat healthcare surveyAnswer Questions about Healthcare in China

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

Having-a-Baby-In-ChinaExpats Talk about What it's Like Having a Baby in China

Read recent baby reports submitted for Shanghai and Guangzhou.

If you're an expat parent who had a baby abroad, write a report about your childbirth experiences to help other expecting expat parents.

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 China from our partner, Cigna Global Health.
Get a Quote

Join our China Expat Forum

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

More about China

10-Tips-for-Living-in-China

Expat China: 10 Tips for Living in China

Expats living in China find learning Mandarin a big challenge, but most say that learning even a little is very worthwhile. They also agree that the spitting, squat toilets and Chinese culture take some getting used to. Expats share their tips and experiences living in China.

Expats living in China find learning Mandarin a big challenge, but most say that learning even a little is very worthwhile. They also agree that the spitting, squat toilets and Chinese culture take s...

Thanksgiving-in-Beijing

Thanksgiving in Beijing

For American expats looking to dine out on Thanksgiving, here's a list of several restaurants offering Thanksgiving dinners in Beijing.

For American expats looking to dine out on Thanksgiving, here's a list of several restaurants offering Thanksgiving dinners in Beijing....

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

9-Things-to-Know-Before-Moving-to-China

9 Things to Know Before Moving to China

Expats in China offer tips for newcomers and others considering a move to China. Advice what to bring when you move to China, health insurance and healthcare, finding an apartment, expat banking and more.

Expats in China offer tips for newcomers and others considering a move to China. Advice what to bring when you move to China, health insurance and healthcare, finding an apartment, expat banking and m...

International-Schools-in-Shanghai

International Schools in Shanghai, China

Shanghai has a number of great international and bi-lingual schools. Some of these schools cater primarily to expats while others have mostly local students. We cover several popular schools in Shanghai and include feedback from parents.

Shanghai has a number of great international and bi-lingual schools. Some of these schools cater primarily to expats while others have mostly local students. We cover several popular schools in Shan...

5-Tips-for-Living-in-Qingdao,-China

5 Tips for Living in Qingdao, China

With its huge expat population, expats in Qingdao enjoy numerous expat-oriented social events and local resources. Expats also appreciate the friendly and welcoming to locals, sea view homes in the Laoshan district and Qingdao's international schools.

With its huge expat population, expats in Qingdao enjoy numerous expat-oriented social events and local resources. Expats also appreciate the friendly and welcoming to locals, sea view homes in the L...

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

First Published: May 03, 2018

Cigna Expat Health InsuranceExpatriate Health Insurance

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

healthcare in ShenzhenHealthcare in Shenzhen, China

An expat in Shenzhen, China discusses health care and health insurance in Shenzhen. She advises expats who don't speak Chinese fluently to bring a someone who is fluent with them to doctor's appointm -

healthcare surveyAnswer Questions about Healthcare in China

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

Having-a-Baby-In-ChinaExpats Talk about What it's Like Having a Baby in China

Read recent baby reports submitted for Shanghai and Guangzhou.

If you're an expat parent who had a baby abroad, write a report about your childbirth experiences to help other expecting expat parents.

China 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 02-Jul-20 03:18 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.62.46
Host Name 172.69.62.46


Execution Time

Total Time Avg Time Count Template
98 ms 98 ms 1 top level /home/www/html/lib_rd.cfm
31 ms 31 ms 1 /home/www/html/navcontentboxhealthcaremobile.cfm
16 ms 16 ms 1 /home/www/html/navtop_rdesign5.cfm
14 ms 14 ms 1 /home/www/html/lib_rd_ctrygd_readnext.cfm
10 ms 10 ms 1 /home/www/html/commentsnew_rdesign4.cfm
9 ms 9 ms 1 /home/www/html/navleader_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/navbottomad_rdesign5.cfm
6 ms 6 ms 1 /home/www/html/Application.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
4 ms 4 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
3 ms 3 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navcontentboxhealthcarepc.cfm
2 ms 2 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/breadcrumb.cfm
0 ms 0 ms 1 /home/www/html/constants.cfm
0 ms 0 ms 1 /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_5051_76306.txt
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 8 /home/www/html/rewritearticle.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/rewritereportscountry.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
105 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 @ 15:18:36.036
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=4ms, Records=1) in /home/www/html/Application.cfm @ 15:18:36.036
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 15:18:36.036
	Select *
	From articles
	Where articleID = 5051
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 15:18:36.036
	Select *
	From sponcers
	Where sponcerID = 287 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 15:18:36.036
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 5051 
	and articles.articleID = 5051 
	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 @ 15:18: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 = 5051
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 5051
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 15:18: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 @ 15:18:36.036
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 31 
getcities (Datasource=expert, Time=1ms, Records=13) in /home/www/html/navmeta_rdesign4.cfm @ 15:18:36.036
	Select *
	From citynetworks
	Where networkID = 31
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 15:18: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=0) in /home/www/html/navmeta_rdesign4.cfm @ 15:18:36.036
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 5051 
  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 @ 15:18:36.036
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
and logtime > "2020-04-02"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 15:18:36.036
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
and logtime > "2020-07-02 00:00:00.000"
and logtime < "2020-07-02 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 @ 15:18:36.036
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
and logtime > "2020-06-25"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 15:18:36.036
	SELECT *
	From contentcountcountry
	Where networkid = 31 
gettopbanner (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 15:18:36.036
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-07-01"
    and fromDate < "2020-07-02"
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 15:18:36.036
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-07-01"
    and fromDate < "2020-07-02"
UpdatePageViews (Datasource=expert, Time=9ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 15:18:36.036
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb.cfm @ 15:18:36.036
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5051 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 15:18:36.036
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 5051 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 15:18:36.036
SELECT tag
FROM natadoptions 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 15:18:36.036
SELECT *
FROM natadoptions 
WHERE 'hiheader' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 15:18:36.036
SELECT *
FROM natadoptions 
WHERE natadtypeid = 1 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 15:18:36.036
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 1
and natadPlacement.networkID = 31
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-07-01"
and headerparagraphstart < "2020-07-02"
and headerparagraphstatus = 'live'

and (headerparagraphweight = 'medium' or headerparagraphweight = 'high')
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 15:18:36.036
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getnatadtype (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 15:18:36.036
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 15:18:36.036
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 31
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-01"
and natsentencestart < "2020-07-02"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 15:18:36.036
SELECT resourceid, natsentence as adcode, natsentenceweight, natadid
FROM natads 
WHERE natadid = 46
and natsentencetype = 2 
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:18:36.036
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 31 
	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 <> '5051'
	
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-02"
     ORDER by articles.sectionintro DESC, articles.articleID desc 
 
gethospitals (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:18:36.036
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 31 
		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 <> '5051'
	
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-02"
     ORDER by articles.title
 
GetClassifieds (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:18: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 = 31 
and answers.answerid = allreports.answerid
and answers.reviewed = 'y'

    ORDER by allreports.answerid asc   
    
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:18:36.036
SELECT *
FROM topics
WHERE topicid = 7 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:18:36.036
	SELECT summary as answer
	FROM answers
	WHERE answerid = 77322 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:18:36.036
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 77322 
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:18:36.036
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 77322 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:18:36.036
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '31'
checkbabyfeature (Datasource=expert, Time=5ms, Records=3) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:18:36.036
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
      
         and networkid = 31 
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 15:18:36.036
		Select summary, hiimg 
		FROM answers
         where answerid = 27846
         and summary <> ''
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 15:18:36.036
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5051 
gettaxgeneral3 (Datasource=expert, Time=7ms, Records=4) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 15:18:36.036
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 31 
	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 <> 5051
    and publishdate < "2020-07-02"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettaxgeneral4 (Datasource=expert, Time=6ms, Records=2) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 15:18:36.036
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articlecityplace
	Where hitopic <> ''
	and articlePlacement.networkID = 31 
	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 <> 5051
    and publishdate < "2020-07-02"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 15:18:36.036
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-01"
    and fromDate < "2020-07-02"
    and bannerPlacement.networkid = 31
    and bannerPlacement.bannerid = banners.bannerid
    and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 15:18:36.036
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
gethpbox (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 15:18:36.036
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-07-01 15:18:36'}
    and fromDate <{ts '2020-07-02 15:18:36'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 15:18:36.036
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 15:18:36.036
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 5051 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 15:18:36.036
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5051 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 15:18:36.036
	SELECT summary as answer
	FROM answers
	WHERE answerid = 77322 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 15:18:36.036
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 77322 
getsummary (Datasource=reports, Time=1ms, Records=0) in /home/www/html/navcontentboxhealthcarepc.cfm @ 15:18:36.036
		Select summary, hiimg 
		FROM answers
         where answerid = 27846
         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/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=5051&networkid=31
REMOTE_ADDR=172.69.62.46
REMOTE_HOST=172.69.62.46
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=30740794
cftoken=40132883
sessionid=IBEXPATEXCHANGE.COM_30740794_40132883
urltoken=CFID=30740794&CFTOKEN=40132883
URL Parameters:
articleID=5051
networkid=31
Debug Rendering Time: 11 ms