China
Resources
City Guides
JoinSign In

10 Tips for Moving to China

By Navjot Singh

Last updated on: Oct 31, 2017

Summary: With its booming economy and increasingly better standards of living, China is a major destination point for expats from all over the world. Author Navjot Singh offers great tips for newcomers to China.

Expat China - 10 Tips for Moving to China

Many corporates are asking their middle and senior management to relocate to China so that they can go and manage their business activities there (it’s always beneficial to have someone trustworthy on location rather than managing with time and communication differences!).

Tax free salaries, excellent expat amenities (housing allowances, maids, and the less expensive goods) are all making China a major destination for foreigners. Reuters reported that during the second quarter of 2007, China's GDP growth increased to 11.9%, which is the best ever growth pace seen since 2005. While the rest of the world may be suffering from the credit crunch, China has not been affected that severely, and it is one reason why many expats are going there. The country’s growth is set to accelerate dramatically in the next two years. By the end of 2007, it was reported that nearly 250 thousand registered foreign workers were operating in China.

Learn the language

Yes, the Chinese language (known as Mandarin or Putonghua) is one of the most complex languages in the world. But, if 1.3 billion people can master it, why not you? The difficulty that most foreigners find is in the pronunciation of the various words, because it’s a tonal language -- every word has at least 4 meanings (8 in Shanghainese!). So, if you can master the basics of the tones, then you can master the rest of the language. The speaking and listening should not be as challenging as the reading and writing. In Hong Kong, Macau (and the rest of Guangdong Province, Cantonese (known as Guangdonghua) is the accompanying language to the widely recognized Mandarin. However, normally everyone can understand either English or Mandarin. To get a job in most corporations in China you need some language skills -- otherwise, especially for expats, language classes are provided by their companies.

Take part in local festivals

Christmas and Easter will not be the same in China as they are not celebrated -- in actual fact it won't feel like Christmas or Easter at all. There are expat parties in expat areas that host the celebrating of such events, however they are fairly low key. Instead, it's best that you immerse yourself into local Chinese culture. Most expats tend to take the opportunity to return back to their homelands during the Chinese holidays. The highlights of the year are the Chinese New Year at the end of January (it's China’s equivalent to Christmas) and the Mid Autumn Festival in the first week of October. There is also the May Day holiday in the first week of May. Most companies have a normal working day on the 31st December and 1st January because its not a national holiday in China -- although as expats you may be given the day off from your employer.

Make friends with the locals

For newcomers to China, the first few weeks or months you will be like a kid in a candy shop busy with your tourist activities (combined with work!). For the minor but important things like asking your neighbors to keep the noise down or to get assistance for your home (landlord problems etc.), it is usually nice to have a friend who you can trust and talk to in case you may require urgent translation. Making friends with the locals will also assist you to overcome culture shock and home sickness -- it will enable you to fully immerse yourself into your new life.

Travel around!

Treat everyday as a working vacation. You may never get this chance again to live and work in a foreign country, and where better than China?! Most domestic destinations are within a maximum of 3 hours flying time, and flights are not as expensive as in the west -- so you can easily go on a weekend break. China has so many places to visit. If you are based in a big city such as Shanghai or Beijing, you can easily go every weekend to a different location within a few hours drive away. In the winter there are so many nice ski reports in the north (Dalian, Harbin etc.) you can go to, while there are lots of hot springs scattered all over the country in areas of natural beauty. China’s equivalent of Hawaii is the Island of Hainan (about an hours flight from Hong Kong), and has nice clean white sandy beaches (Sanya), which for the past number of years has also been the host city to the annual Miss World Competition.

Eat local Chinese food

There is nothing worse than being in China and jumping at the first opportunity to go to your local McDonald’s, Pizza Hut or KFC (all are available in abundance in China). This is perfectly acceptable for those times when you are feeling homesick, however you will be missing a lot of fun if you fail to try your local eatery. A tasty local dish can be bought for around 8RMB ($US 1), unless you want to try an up market restaurant (for which the prices should not be more than around 50RMB ($US 6) on average per person. Every province in China has its own cuisine and taste. For example, Sichuan is hot and spicy (especially the sizzling hot pot which is not only hot in temperature but contains red hot chilies mixed with boiled water…ouch!), Shanghainese cuisine is sweet and sour, while Southern China (Guangdong Province) is known as the home of Chinese cookery because in cities like Guangzhou and Shenzhen, you are bound to find a restaurant that caters for every kind of taste! Chinese food mainly consists of various flavored dumpling, fresh fish (or other seafood), fresh vegetables, and rice or noodles typically accompany every meal. Plus, Chinese food in Europe and USA or other western countries just does not taste the same -- it tastes better and much more authentic in China!

Avoid abusing the culture

The vast majority of expats who go to China tend to get used to being treated like a VIP by the locals just because they are foreigners, or "have a white skin" -- this is everywhere ranging from restaurants (people will watch how you eat and want to give you full hospitable attention) to your work place (expats will get treated better at work than most local staff members); and in the process some expats tend to abuse this because they expect to get treated like a VIP everywhere they go. The general thought comes across "I am an Expat, I should be given priority over the locals" -- this is wrong. In recent years, Chinese people in the big cities (like Shanghai and Beijing) are beginning to realize that it’s not OK for a foreigner to jump in the queue at the bank/post office etc. just because they are foreigners. The reality is that this can have adverse effects on you if you come across a situation where you may end up arguing with someone as to why you are not getting first priority (I have seen this happen quite a number of times in China), and it is not good for the image that foreigners want to portray. So please expect to be treated just as you would back in your own country. Yes, you are an expat but, no, you are not a member of any colonial clan anymore.

Engage yourself in local entertainment

Offer your friend/work colleague/neighbor a game of Badminton, Pool or Table Tennis and you bet your bottom dollar you will put a smile on their face. Even taking part in local activities such as kung fu classes, Ball room dancing and Salsa (which are all popular) will sure make you a popular foreigner and get you to find out more about the culture. It will take your mind off of being homesick and get you to interact and make new friends as well. The Chinese love gambling (although it's not encouraged to do so), so if you want to try your luck at Mahjong, then go for it…it’s actually meant to be good for the brain and people (usually Old Aged Pensioners) spend the whole day playing this rather addictive game! If your colleagues invite you to go to the local KTV after work, then its best to join just for the fun even if you cannot sing (in Chinese or English).

Watch Chinese TV (not just CCTV9!)

It's all well that if you are stuck at home and have not much to do you will switch on your cable TV and probably end up watching CNN, BBC World or CCTV9 (China’s only English TV Channel). But to learn Chinese culture and to maybe even brush up on your Chinese skills, it is beneficial to watch Chinese TV. Channels such as CCTV1, CCTV5 (Sports) and especially CCTV4 usually have foreign films or programs dubbed into Chinese. There are also a variety of local channels- every province has its own channels -- and so taking into context that there are over 400 TV channels in China -- you’ll never run out of choices!

Understand the social and business etiquettes

If a Chinese family or friend invites you to their home then accept it. You are a guest in their country and home, and the Chinese are very welcome and hospitable people. To reject an invitation is considered rude and will make your host lose face if you refuse to attend (except of course if you have other urgent matters to attend to -- which is understandable). Similarly, in the business world, if your manager invites you to join him/her (usually him) for dinner, then it's best to accept as it is their honor to invite you. This is how business deals are made and negotiated in China -- over a networking dinner. Remember that in China seniority counts, so don’t go around the restaurant tables toasting with your colleagues, as only the senior managers do this! (Of course you can toast with your friends on your table, but not everyone).

Avoid Driving if you can

It goes without saying that driving in China is not easy for local people, let alone foreigners. People generally just tend to go with the flow and drive without looking into the mirror, which is one major reason why China has the second highest accident rate after India. A driver's license is not difficult to obtain for foreigners in China, however with an abundance of cheap taxies and the highly efficient public transport system, it would be highly recommended that you don’t drive in China. Most expats will be provided with a driver and car.

About the Author

Navjot is the author of the recently published “Newcomer’s Handbook Country Guide: China: Including Beijing, Guangzhou, Shanghai, and Shenzhen”, (www.firstbooks.com) aimed at providing detailed advice to expatriates who are relocating to the region on a long term basis and has also written “China: Business Travelers Handbook” (www.stacey-international.co.uk) which is out for an early 2009 release. He is also a freelance travel journalist contributing on a ad-hoc basis to various travel applications.

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

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

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

6 Important Tips about Healthcare for Expats in China

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!

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

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

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

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

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

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Comments about this Article

lonehope
Jan 22, 2011 22:52

You have mentioned "Tax Free Salaries" for Expat, How does it work? I have heard that China has high taxes. Can you please explain to me? Thank you.

lonehope
Jan 22, 2011 22:56

I am an expat who will be working for Chinese Company who never had expat previously, How can I get compreshensive health insurance? Thank you very much in advance.

guest
Mar 1, 2012 07:20

Hey Corey! Thanks for sitnpopg by. Keep checking back over the next few months I'll be talking logistics before departure.This trip happened because I took a three-month trip a couple of summers ago and was hooked. My recommendation is not to wait until you feel comfortable the only way to get that is to just go for it. You could start smaller, though, a lot of people hit a month or two and start getting homesick. I'd go for just a month or three if you can swing it, and then plan from there.

wwyw225
Jun 14, 2013 13:12

Moving to China is an excitement but not an easy thing to arrange when you have decided it,and that is why the article like above could be very useful! I work for the property and relocation company, on our website we also give some idea by experiense talk. you can find them at:http://www.citywiseproperty.com/our-services/orientation-services/ Apart from giving you advise we also provide very good consulting and service to make you enjoy a new country since the beginning.Let us to make your moving effetion and smooth, and welcom to China, to Beijing

guest
Jul 1, 2013 03:51

Hi Navjot, you have some really great tips in here! I also think it's important to have an open attitude towards the new culture and people you are going to meet. In this process it helps to know the language, as you have a way of communicating with the locals. A problem I've noticed is that in the stages of culture shock one ofthen starts complaining about China, and I mean having bad China day's in a row for a week or more. What would be your tips for bad China days? Sara http://www.sarajaaksola.com

arvindparab
Dec 27, 2013 06:13

Hi Navjot, I like your article. As per your post in Expat Exchange, I have my own business in India. I am looking for local partner to start new Pizza Outlet in China. I have well trained & Experience from USA in PIZZA franchise management. Kindly reply. Thanks & Regards Arvind Parab

guest
Oct 31, 2017 18:08

With his list of so-called 'suggestions' he should have added, "Become a communist" to finally fit into his Chinese holiday mantra.

First Published: Nov 20, 2013

Cigna Expat Health InsuranceExpatriate Health Insurance

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

15-Expats-Talk-about-Moving-to-China15 Expats Talk about Moving to China

Expats talks about the adjusting to China's squatty toilets, spittoons and small shoe sizes. But, these challenges are outweighed by the friendly Chinese people, affordable tailors on every corner and a surprising number of bakeries.
Expats talks about the adjusting to China's squatty toilets, spittoons and small shoe sizes. But, these challenges are outweighed by the friendly Chinese people, affordable tailors on every corner an...

Moving-to-China9 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...

Expat-China6 Important Tips about Healthcare for Expats in China

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!

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

Retirement-In-Nanning,-Guangxi-ProvenceAn Expat Shares What it's Like Retiring in Nanning, Guangxi Provence, China

An American retiree in Nanning, China appreciates the low cost of living and friendly locals. Unfortunately, the traffic is horrendous -- motor bikes are the fastest way to get around.

An American retiree in Nanning, China appreciates the low cost of living and friendly locals. Unfortunately, the traffic is horrendous -- motor bikes are the fastest way to get around. ...

Moving-To-ShanghaiAn Expat Talks about Moving to Shanghai, China

An expat in Shanghai wishes she had brought more walking shoes, winter socks and OTC medications. She advises apartment hunters to make sure everything in the apartment works before you sign the least.

An expat in Shanghai wishes she had brought more walking shoes, winter socks and OTC medications. She advises apartment hunters to make sure everything in the apartment works before you sign the leas...

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


Execution Time

Total Time Avg Time Count Template
65 ms 65 ms 1 top level /home/www/html/lib_rd.cfm
28 ms 28 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/navcontentbox.cfm
27 ms 27 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
14 ms 14 ms 1 /home/www/html/lib_rd_ctrygd_readnext.cfm
9 ms 9 ms 1 /home/www/html/commentsnew_rdesign4.cfm
9 ms 9 ms 1 /home/www/html/navtop_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/Application.cfm
4 ms 4 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/navmpu_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.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/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 9 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereport.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/datasources.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
72 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 @ 13:03:58.058
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 13:03:58.058
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 13:03:58.058
	Select *
	From articles
	Where articleID = 3222
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 13:03:58.058
	Select *
	From sponcers
	Where sponcerID = 305 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 13:03:58.058
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 3222 
	and articles.articleID = 3222 
	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 @ 13:03:58.058
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 3222
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 3222
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 13:03:58.058
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 13:03:58.058
	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 @ 13:03:58.058
	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 @ 13:03:58.058
  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
getarticlesection (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 13:03:58.058
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 3222 
commentcount (Datasource=forum, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 13:03:58.058
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 3222 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid DESC
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 13:03:58.058
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-04-16"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 13:03:58.058
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-07-16 00:00:00.000"
and logtime < "2020-07-16 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 13:03:58.058
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-07-09"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 13:03:58.058
	SELECT *
	From contentcountcountry
	Where networkid = 31 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 13:03:58.058
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 3222 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 13:03:58.058
SELECT tag
FROM natadoptions 
getarticlesection (Datasource=expert, Time=0ms, Records=0) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 13:03:58.058
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 3222 
gettaxgeneral3 (Datasource=expert, Time=6ms, Records=5) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 13:03:58.058
	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 <> 3222
    and publishdate < "2020-07-16"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID desc
    
gettaxgeneral4 (Datasource=expert, Time=6ms, Records=2) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 13:03:58.058
	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 <> 3222
    and publishdate < "2020-07-16"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID desc
    
gettopbanner (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 13:03:58.058
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-15"
    and fromDate < "2020-07-16"
    and bannerPlacement.networkid = 31
    and bannerPlacement.bannerid = banners.bannerid
    and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 13:03:58.058
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
gethpbox (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 13:03:58.058
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-07-15 13:03:58'}
    and fromDate <{ts '2020-07-16 13:03:58'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 13:03:58.058
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=7) in /home/www/html/commentsnew_rdesign4.cfm @ 13:03:58.058
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 3222 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 13:03:58.058
  SELECT *
  FROM users
  WHERE userid = 49293 
GetUser (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 13:03:58.058
  SELECT *
  FROM users
  WHERE userid = 49293 
GetUser (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 13:03:58.058
  SELECT *
  FROM users
  WHERE userid = 2 
GetUser (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 13:03:58.058
  SELECT *
  FROM users
  WHERE userid = 73871 
GetUser (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 13:03:58.058
  SELECT *
  FROM users
  WHERE userid = 2 
GetUser (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 13:03:58.058
  SELECT *
  FROM users
  WHERE userid = 78242 
GetUser (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 13:03:58.058
  SELECT *
  FROM users
  WHERE userid = 2 
getarticlesection (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 13:03:58.058
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 3222 
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:03:58.058
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-16"
     
         and rptarticlenetworks.networkid = 31 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 13:03:58.058
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 8
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 13:03:58.058
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 31 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:03:58.058
SELECT  hiimg
FROM rptarticles
where rptarticleID = 8
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentbox.cfm @ 13:03:58.058
	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.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-16"

    ORDER by articles.articleID desc
    
checkretirefeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:03:58.058
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 31 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:03:58.058
		Select summary, hiimg 
		FROM answers
         where answerid = 71003
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=5ms, Records=3) in /home/www/html/navcontentbox.cfm @ 13:03:58.058
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 31 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:03:58.058
		Select summary, hiimg 
		FROM answers
         where answerid = 75070
         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=3222&networkid=31
REMOTE_ADDR=172.69.63.37
REMOTE_HOST=172.69.63.37
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=32011607
cftoken=53358129
sessionid=IBEXPATEXCHANGE.COM_32011607_53358129
urltoken=CFID=32011607&CFTOKEN=53358129
URL Parameters:
articleID=3222
networkid=31
Debug Rendering Time: 11 ms