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

Moving to China > 9 Things to Know Before Moving to China

9 Things to Know Before Moving to China

By Betsy Burlingame

Last updated on: Jun 17, 2019

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

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

What to Pack If You're Moving to China

We asked expats living in China what they wish they had brought when they moved to China and what they wish they had left behind.

"Three things I wish I had brought when moving to Beijing: My favorite hair products - American products are really expensive and sometimes impossible to find. Cocktail bitters - I come from a place where craft cocktails are all the rage. Finding anything but agnosta bitters is unheard of. My favorite chair - most everyone buys their furniture at IKEA, which is fine. But, if you want something different there aren't many places where you can walk in, try something and then go home with it any earlier than 6 weeks. Three things I didn't need to bring. Any of my kitchen appliances - I knew my hairdryer didn't work but didn't think about anything else. You will have to have a converter to use with anything. Way easier to just buy a new appliance. High heel shoes - I sprained my ankle within 2 weeks of arriving. The sidewalks are uneven and horrible to walk on. I won't wear high heels ever in Beijing. Hard luggage - I've converted everything to soft so I can pack it away. It's hard to move at the airport true, but better than it taking up your living space," commented one expat who made the move to China.

"Men's Shoes in China: If you are a size 11 or larger you'll find it difficult to find quality men's shoes here. Over the counter medications in China: It's difficult to find simple brands that you know in Chinese shops like Pepto-Bismol, Nyquil, etc. If you have some brands that you rely on, bring those. I also recommend bringing a First Aid Kit as it is just a good idea to have on hand! VPN: Most Western Internet sites are blocked here. You want to pre-install a VPN on your computer and phone before you arrive in China. If you don't, the initial days here will be confusing," remarked another expat in Beijing , China.

"I would have brought more walking shoes, more over the counter medicines and more winter socks," said another expat in China.

Moving to China

Moving to China soon? AGS Worldwide Movers is a leader in the international moving industry. Their experience and expertise allows them to guarantee their clients the best quality moving services. Get a moving quote today.

Healthcare and Health Insurance for Expats in China

The US Embassy in Beijing wrote, "All Americans traveling to China are encouraged to buy foreign medical care and medical evacuation insurance prior to arrival. Western style medical facilities with international staff are available in Beijing, Shanghai, Guangzhou and a few other large cities. Many other hospitals in major Chinese cities have so-called VIP wards / Special Needs (te xu) wards with reasonably up-to-date medical technology and skilled physicians who typically speak English. Ambulances do not carry sophisticated medical equipment, and ambulance personnel generally have little or no medical training. Therefore, injured or seriously ill Americans may be required to take taxis or other immediately available vehicles to the nearest major hospital rather than waiting for ambulances to arrive. In rural areas, only rudimentary medical facilities are generally available. Medical personnel in rural areas are often poorly trained, have little medical equipment or availability to medications. Rural clinics are often reluctant to accept responsibility for treating foreigners, even in emergency situations."

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.

When we asked expats in China if they have access to quality medical care. They replied: "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," said one expat who moved to Xi'an, China. "It is difficult unless you have someone who speaks English go with you to explain the problem. After that it is easy. I have been three time to the hospital. The hospitals go out of their way to set me up with doctors that have some English ability and 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. Prescription medication is very expensive," mentioned another expat when asked about moving to China.

For more information about healthcare in China, read our article, 6 Important Tips about Healthcare for Expats in China.

beijing china restaurant

Take a Look-See Trip Before You Commit

"Come for what I call a looky-see trip first before committing to come live in this area to make sure you can find a decent home for you and your family. Get a good relocation company to help you look and negotiate for you. Everything in China is up for negotiation! Make sure your company is allowing you enough housing money per month to get you a good place to live and make sure you detail and negotiate EVERYTHING you want the place to have BEFORE you seal the deal and move into the place. When your contract for the house is up for renewal that is the time the owner will make other changes you need or forgot to ask for intitally to keep you in the place for another go round," said one expat who moved to Tianjin, China.

Finding an Apartment in China

"Find a local from Beijing to help with location. Pay attention to what comes with the property, 24 hour hot water, elevator, heat, satellite tv, internet, and the maintenance. The sizes are in square meters which isn't always accurate because they describe construction size and not the living space," mentioned another expat when asked about moving to China.

"Be patient and have a lot of cash on hand! Apartments in north China require an initial payment of 3 months and 1-month deposit. That is a lot of money to spend at the beginning. Everyone should arrive in Beijing with at least a minimum of $5,000 USD for start-up costs. The best way to find an apartment is to ask a colleague which realtors they used," advised another expat.

"Look at many places and use a checklist to make sure that everything works BEFORE signing any lease. Landlords move slowly after they have your deposit," remarked another expat in Shanghai, China.

real estate china

Think About Your Commute When Choosing Where to Live

This advice from an expat in Beijing applies to any city in China, "Beijing is a HUGE city and you want to live near where you work. You'll hate life if you have to commute a long time on the subways - which is insanely crowded during rush hours. I work in the CBD so I got an apartment that is about a 30-minute walk from home or a 5-minute ride on the bus."

Typical Housing for Expats

When we asked expats in China about the type of home or apartment they life in and whether that is typical for expats, they replied:

"I live on the 23rd floor of what is known as a fully-serviced apt building. Fully serviced means that they provide housekeeping six days a week. My apt is a modest sized three bedroom/2 bath place.No dishwasher or garbage disposal but does have access to western TV programming which is banned to the Chinese locals. It is centrally located so I can walk to many places I want to go to or easily flag down one of the little red suicide taxis that play road chicken games all over town. Like most Chinese made buildings, this place while only five years old is already showing signs of falling apart," said one expat who moved to Tianjin, China.

"Pretty much everyone here lives in apartments in big buildings. Some families may choose to live in villas in the Shunyi area, but everyone else is in apartments. Apartments in Beijing tend to be older but they are all furnished and safe. Decorations can be a bit underwhelming so you'll want to invest in some plants, paintings and other things to make your home warm," commented one expat in Beijing.

"[I live in an] Apartment in a Chinese apartment building that is 6 floors tall. Yes, there are many embassies in this neighborhood so there are many expats and geopats here," remarked another expat in Shanghai, China.

Rent a Serviced Apartment When You First Arrive

One expat offered a very good suggestion, "I live in a high rise apartment / hotel. Yes, to begin with most live in some sort of service apartment or they share a big apartment with several rooms. I prefer to live alone. My apartment is serviced which is nice because they help me care for my cat when I'm away. I've heard you can hire an aiyi and they can teach you to cook."

Learning to Speak Chinese Will Make Life Easier in China

"Take some Chinese classes. It is so frustrating to live here without speaking basic Chinese. And learning to speak is actually quite easy. It's the writing and reading that makes everyone thing Chinese is impossible -- so learn some verbal chinese," said one expat who moved to Guangzhou, China.

Banking in China

"Try to get everything organized before you leave the USA. The banks and financial institution in the USA still are in the pony express and telegraph era. Most things require phone calls and they ALWAYS say they are experiencing an 'unusual high volume of calls' (this unusual high volume is 24/7 month after month after month so what they are really saying is they don't give a damn about you the customer, they just want to save money and not hire enough people. I lost my ATM card and it took me 3 months to get a new one," suggested one expat who retired in Nanning.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

International-Schools-in-ShanghaiInternational 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...

Moving-To-ChinaExpats Talk about What it's Like Moving to China

Already living abroad? Write a report about moving overseas to help people preparing to move abroad.

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.

Read Next

10-Tips-for-Living-in-ChinaExpat 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.

International-Schools-in-ShanghaiInternational 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.

Thanksgiving-in-BeijingThanksgiving in Beijing

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

5-Tips-for-Living-in-Qingdao,-China5 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.

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 International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Comments about this Article

guest
Jun 17, 2019 18:21

The 10th Thing You Need to Know Before Moving to China (if you are not already aware) In the spirit of disclosure--If you are moving to China for work you likely have little to no say in the move. However, if you are moving to China and have a choice to do otherwise be aware that China is a surveillance police State. They are serious about it. They use facial recognition as well as your geographic movements to follow you. That means--where you go, who you talk to, what you see, what you buy--everything. There is no privacy in China. In several recent articles have been posted on the current Chinese situation. You can research this by simply typing in 'jaywalking in China'. One such article noted an American male living in China who jaywalked. Within 20 seconds a fine appeared on his phone. The State identified him, before he reached the opposite curb. Never be afraid but always be informed, aware and prepared. You are an American and therefore a foreigner. Be safe.

Updated On: Apr 08, 2019

First Published: Apr 08, 2019

Cigna Expat Health InsuranceExpatriate Health Insurance

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

International-Schools-in-ShanghaiInternational 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...

Moving-To-ChinaExpats Talk about What it's Like Moving to China

Already living abroad? Write a report about moving overseas to help people preparing to move abroad.

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 03-Jun-20 11:36 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.141
Host Name 173.245.54.141


Execution Time

Total Time Avg Time Count Template
93 ms 93 ms 1 top level /home/www/html/lib_rd.cfm
27 ms 5 ms 5 /home/www/html/nativerotationtop_tester13.cfm
24 ms 24 ms 1 /home/www/html/navcontentboxmovingmobile.cfm
9 ms 9 ms 1 /home/www/html/navtop_rdesign5.cfm
8 ms 8 ms 1 /home/www/html/lib_rd_readnext.cfm
6 ms 6 ms 1 /home/www/html/Application.cfm
6 ms 6 ms 1 /home/www/html/commentsnew_rdesign4.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navbottomad_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navmpu_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/breadcrumb.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
1 ms 1 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.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/natad/native_5278_73117.txt
0 ms 0 ms 1 /home/www/html/navcontentboxmovingpc.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 11 /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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
100 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=1ms, Records=1, Cached Query) in /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm @ 11:36:19.019
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=4ms, Records=1) in /home/www/html/Application.cfm @ 11:36:19.019
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 11:36:19.019
	Select *
	From articles
	Where articleID = 5278
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 11:36:19.019
	Select *
	From sponcers
	Where sponcerID = 287 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 11:36:19.019
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 5278 
	and articles.articleID = 5278 
	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=1ms, Records=0) in /home/www/html/lib_rd.cfm @ 11:36:19.019
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 5278
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 5278
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 11:36:19.019
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 11:36:19.019
	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 @ 11:36:19.019
	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 @ 11:36:19.019
  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 @ 11:36:19.019
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 5278 
  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 @ 11:36:19.019
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.141'
and logtime > "2020-03-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 11:36:19.019
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.141'
and logtime > "2020-06-03 00:00:00.000"
and logtime < "2020-06-03 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 11:36:19.019
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.141'
and logtime > "2020-05-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 11:36:19.019
	SELECT *
	From contentcountcountry
	Where networkid = 31 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 11:36:19.019
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 11:36:19.019
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb.cfm @ 11:36:19.019
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5278 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 11:36:19.019
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 5278 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getnatadcount (Datasource=expert, Time=1ms, Records=48) in /home/www/html/lib_rd.cfm @ 11:36:19.019
SELECT tag
FROM natadoptions 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
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-06-02"
and natsentencestart < "2020-06-03"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
SELECT *
FROM natadoptions 
WHERE 'hianchor' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
SELECT *
FROM natadoptions 
WHERE natadtypeid = 5 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
SELECT resourceid,  natanchorlink as adcode,natanchorlinkweight, natads.natadid
FROM natads, natadPlacement
WHERE natanchorlinktype = 5
and natadPlacement.networkID = 31
and natadPlacement.natadid = natads.natadid
and natanchorlinkend > "2020-06-02"
and natanchorlinkstart < "2020-06-03"
and natanchorstatus = 'live'

and natanchorlinkweight = 'high'
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
SELECT resourceid, natanchorlink as adcode, natanchorlinkweight, natadid
FROM natads 
WHERE natadid = 1
and natanchorlinktype = 5 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
SELECT *
FROM natadoptions 
WHERE 'moveheader' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
SELECT *
FROM natadoptions 
WHERE natadtypeid = 6 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 6
and natadPlacement.networkID = 31
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-06-02"
and headerparagraphstart < "2020-06-03"
and headerparagraphstatus = 'live'

and (headerparagraphweight = 'medium' or headerparagraphweight = 'high' or headerparagraphweight = 'low')
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
SELECT *
FROM natadoptions 
WHERE 'moveanchor' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
SELECT *
FROM natadoptions 
WHERE natadtypeid = 10 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
SELECT resourceid,  natanchorlink as adcode,natanchorlinkweight, natads.natadid
FROM natads, natadPlacement
WHERE natanchorlinktype = 10
and natadPlacement.networkID = 31
and natadPlacement.natadid = natads.natadid
and natanchorlinkend > "2020-06-02"
and natanchorlinkstart < "2020-06-03"
and natanchorstatus = 'live'

and natanchorlinkweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
SELECT resourceid, natanchorlink as adcode, natanchorlinkweight, natadid
FROM natads 
WHERE natadid = 32
and natanchorlinktype = 10 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
SELECT *
FROM natadoptions 
WHERE 'banksentence' = tag
getnatadtype (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
SELECT *
FROM natadoptions 
WHERE natadtypeid = 38 
getnatadbottom (Datasource=expert, Time=9ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 38
and natadPlacement.networkID = 31
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-06-02"
and natsentencestart < "2020-06-03"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getnatadbottom (Datasource=expert, Time=8ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 11:36:19.019
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 38
and natadPlacement.networkID = 31
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-06-02"
and natsentencestart < "2020-06-03"
and natsentencestatus = 'live'
gettaxgeneral2 (Datasource=expert, Time=7ms, Records=1) in /home/www/html/navcontentboxmovingmobile.cfm @ 11:36:19.019
	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 = '1' or articleCategories.section = '2' or articleCategories.section = '4' or articleCategories.section = '5')   
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    
    and articles.articleID <> '5278'
	
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-03"
     ORDER by articles.sectionintro DESC, articles.articleID desc 
 
checkmovingfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentboxmovingmobile.cfm @ 11:36:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
      
         and networkid = 31 
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxmovingmobile.cfm @ 11:36:19.019
		Select summary, hiimg 
		FROM answers
         where answerid = 75070
         and summary <> ''
getbestplaces (Datasource=expert, Time=9ms, Records=0) in /home/www/html/navcontentboxmovingmobile.cfm @ 11:36:19.019
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl, publishdate
	FROM articles, articlePlacement, articleCategories 
 	Where hitopic <> ''
	and (((title LIKE '%Best%') OR (author LIKE '%Best%') OR (hitopic LIKE '%Best%') OR (hidescript LIKE '%Best%')) AND ((title LIKE '%Places%') OR (author LIKE '%Places%') OR (hitopic LIKE '%Places%') OR (hidescript LIKE '%Places%')))
	and articlePlacement.networkID = 31
	AND articlePlacement.articleID = articles.articleID
	  and articleCategories.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and (articleCategories.section <> '1' and articleCategories.section <> '2' and articleCategories.section <> '4' and articleCategories.section <> '5')   
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and summary <> ''
    and publishdate < "2020-06-03"
    ORDER by articles.articleID desc
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd_readnext.cfm @ 11:36:19.019
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5278 
gettaxgeneral (Datasource=expert, Time=7ms, Records=4) in /home/www/html/lib_rd_readnext.cfm @ 11:36:19.019
	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 summary <> ''
    and articles.articleID <> 5278
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-03"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navbottomad_rdesign5.cfm @ 11:36:19.019
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 11:36:19.019
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 11:36:19.019
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-06-02 11:36:19'}
    and fromDate <{ts '2020-06-03 11:36:19'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 11:36:19.019
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 11:36:19.019
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 5278 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 11:36:19.019
  SELECT *
  FROM users
  WHERE userid = 2 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 11:36:19.019
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5278 


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=5278&networkid=31
REMOTE_ADDR=173.245.54.141
REMOTE_HOST=173.245.54.141
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=28935727
cftoken=98497340
sessionid=IBEXPATEXCHANGE.COM_28935727_98497340
urltoken=CFID=28935727&CFTOKEN=98497340
URL Parameters:
articleID=5278
networkid=31
Debug Rendering Time: 10 ms