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

Expat Guide to Living in Beijing

Whether you're already living in Beijing or preparing to move to Beijing, our Expat Guide to Living in China offers articles and reports submitted by expats about expat life in Beijing. For answers to specific questions, visit our China Forum to talk with expats 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.

Moving to Beijing, China

An expat in Beijing talks about moving to Beijing. She advised others to leave your high heels at home to avoid sprained ankles, consider living in a serviced apartment the first few months and get help from a local when choosing your location in Beijing.

Moving to Beijing , China

An expat in Beijing advises newcomers to bring shoes (especially if they were larger sizes), a first aid kit and to install a VPN on your computer and phone before you move to China. He explains that you'll need a lot of cash on hand initially since most apartments require 3-month initial payment plus a 1-month deposit. When deciding where to live in Beijing, make sure you live close to work to avoid spending your life in traffic.

More Culture Shock Reports for Beijing

Culture shock is part of the settling in process. Knowing the different phases of culture shock and how other expats in Beijing handle it can be very comforting. Below are some of the responses from expats in Beijing:
Submit a Culture Shock Report

Living Overseas Report

What are people's priorities in Beijing - work? family? socializing? What are the best ways to meet other expats? Are people accepting of racial, cultural and religious differences? Help other expats and people moving to Beijing by filling out our Living Overseas Report.

Submit a Living Overseas Report

More Moving to Beijing Reports

What should you take with you when you move to Beijing? What should you leave behind? What type of housing and neighborhoods are typical for expats in Beijing? Below are some of the responses from expats in Beijing:
Submit a Moving Overseas Report

Reviews of Schools in Beijing

Reviews and school profiles from expat parents and even a few school administrators in Beijing. Great place to find insight into school facilities, teachers and curriculum. Below are some of the reviews from expats in Beijing:
Submit an International School Review

Dream vs. Reality Report

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Beijing. If you are already living in Beijing, share how those "dreams" have been fulfilled, and how they have not by filling out our Dream vs. Reality Report.

Submit a Dream vs. Reality Report

Overseas Retirement Report

Retiring abroad can be a great option for retirees seeking their dream lifestyle at an affordable price. Help other retirees, who are thinking about retiring in Beijing by filling out our Overseas Retirement report.

Submit a Retire Abroad Report

Having a Baby Abroad Report

How did expats choose their doctors, midwives, hospitals? What is childbirth like in Beijing? Help other expats who are preparing to have a baby in Beijing by filling out our Having a Baby Abroad Report.

Submit a Having a Baby Abroad Report

Working in Beijing Reports

What's it like to find a job in Beijing? How difficult was it to obtain a work permit? What types are jobs are typical for expats in Beijing? Below are some of the reports from expats in Beijing:
Submit a Working Abroad 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

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-Beijing-An Expat Talks about Moving to Beijing , China

An expat in Beijing advises newcomers to bring shoes (especially if they were larger sizes), a first aid kit and to install a VPN on your computer and phone before you move to China. He explains that you'll need a lot of cash on hand initially since most apartments require 3-month initial payment plus a 1-month deposit. When deciding where to live in Beijing, make sure you live close to work to avoid spending your life in traffic.

An expat in Beijing advises newcomers to bring shoes (especially if they were larger sizes), a first aid kit and to install a VPN on your computer and phone before you move to China. He explains that...

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 /expatguide.cfm
Time Stamp 05-Jul-20 02:09 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.179
Host Name 173.245.54.179


Execution Time

Total Time Avg Time Count Template
194 ms 194 ms 1 top level /home/www/html/expatguide.cfm
29 ms 29 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
29 ms 29 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/navcontentbox.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
9 ms 9 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/rewritearticlefirsttitle.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/navleader_rdesign5.cfm
1 ms 0 ms 14 /home/www/html/rewriteqoptionsctry.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 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 14 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 14 /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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
204 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 @ 02:09:58.058
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=5ms, Records=1) in /home/www/html/Application.cfm @ 02:09:58.058
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 02:09: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 @ 02:09: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 @ 02:09:58.058
	Select *
	From citynetworks
	Where networkID = 31
	and status <> 'hold'
	ORDER by city
getcity (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 02:09:58.058
	Select *
	From citynetworks
	Where citynetworkid = 4100 
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 02:09: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
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 02:09:58.058
	Select *
	From Networks
	Where networkID = 31 
getphoto (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 02:09:58.058
	Select *
	From countryphotos
	Where networkID = 31
	and citynetworkid = 4100 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 02:09:58.058
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.179'
and logtime > "2020-04-05"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 02:09:58.058
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.179'
and logtime > "2020-07-05 00:00:00.000"
and logtime < "2020-07-05 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 02:09:58.058
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.179'
and logtime > "2020-06-28"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 02:09:58.058
	SELECT *
	From contentcountcountry
	Where networkid = 31 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 02:09:58.058
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-04"
    and fromDate < "2020-07-05"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 02:09:58.058
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 02:09:58.058
	Select *
	From citynetworks 
	Where citynetworkid = 4100 
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 02:09:58.058
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement, articlecityplace 
 	Where hitopic <> ''
 	and articlePlacement.networkID = 31 
 	and articlecityplace.citynetworkid = 4100
    AND articlecityplace.articleID = articles.articleID
	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 summary <> ''
    and publishdate < "2020-07-05"
    ORDER by articles.articleID desc
gettaxgeneral (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 02:09:58.058
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%Beijing%') OR (author LIKE '%Beijing%') OR (hitopic LIKE '%Beijing%') OR (hidescript LIKE '%Beijing%')))
	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 summary <> ''
    and author <> 'Expat Exchange Member'
   and author <> 'ExpatExchange Member'
      and author <> 'ExpatExchange.com Member'
    and publishdate < "2020-07-05"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 02:09:58.058
SELECT qoid, value 
FROM qoptions 

WHERE value = 'China' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 31 
         and citynetworkid = 4100 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 31 
         and citynetworkid = 4100 
         and city <> ''
         
   	 order by date DESC
   	
checkparenting (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 31 
         and citynetworkid = 4100 
         and city <> ''
         
   	 order by date DESC
   	
checkdreamfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 31 
         and citynetworkid = 4100 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 31 
         and citynetworkid = 4100 
         and city <> ''
         
   	 order by date DESC
   	
checkculturefeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 31 
         and citynetworkid = 4100 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=3) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 31 
         and citynetworkid = 4100 
         and city <> ''
         
   	 order by date DESC
   	
checkmovingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 31 
         and citynetworkid = 4100 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=3) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 31 
         and citynetworkid = 4100 
   	 order by date DESC
   	
checklivingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 31 
         and citynetworkid = 4100 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 31 
         and citynetworkid = 4100 
   	 order by date DESC
   	
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 31 
         and citynetworkid = 4100 
   	 order by date DESC
   	
checkwork (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 31 
         and citynetworkid = 4100 
   	 order by date DESC
   	
checkschool (Datasource=expert, Time=5ms, Records=3) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 31 
         and citynetworkid = 4100 
   	 order by date DESC
   	
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 26270 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 25283 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74514 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74516 
getrealestateadvice (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 02:09:58.058
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 31
and allreports.networkid = 31
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 02:09:58.058
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 31
and allreports.networkid = 31
 and allreports.citynetworkid2 =  4100
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=10ms, Records=0) in /home/www/html/expatguide.cfm @ 02:09:58.058
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 31
and allreports.networkid = 31
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 02:09:58.058
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 31
and allreports.networkid = 31
 and allreports.citynetworkid2 =  4100
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/expatguide.cfm @ 02:09:58.058
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 31
and allreports.networkid = 31
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 02:09:58.058
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 31
and allreports.networkid = 31
 and allreports.citynetworkid2 =  4100
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74514 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74516 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 26270 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 02:09:58.058
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 25283 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 02:09:58.058
	Select *
	From Networks
	Where networkID = 31 
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 02:09:58.058
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 26212
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 02:09:58.058
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25760
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 02:09:58.058
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 16123
				AND answerstext.qid = 82
					
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 02:09:58.058
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-05"
     
         and rptarticlenetworks.networkid = 31 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 02:09: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 @ 02:09: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 @ 02:09:58.058
SELECT  hiimg
FROM rptarticles
where rptarticleID = 8
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentbox.cfm @ 02:09: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-05"

    ORDER by articles.articleID desc
    
checkretirefeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 02:09: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 @ 02:09: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 @ 02:09: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=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 02:09:58.058
		Select summary, hiimg 
		FROM answers
         where answerid = 74516
         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/expatguide.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/expatguide.cfm
QUERY_STRING=networkid=31&citynetworkid=4100
REMOTE_ADDR=173.245.54.179
REMOTE_HOST=173.245.54.179
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expatguide.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=31056800
cftoken=59961397
sessionid=IBEXPATEXCHANGE.COM_31056800_59961397
urltoken=CFID=31056800&CFTOKEN=59961397
URL Parameters:
citynetworkid=4100
networkid=31
Debug Rendering Time: 11 ms