Home China Forum China Guide Moving to China Real Estate Healthcare in China

China

Resources

City Guides

AGS Worldwide Movers
Join Sign In
Cigna International Health Insurance

China Travel Alert

Issued by US Department of State

Jul 09, 2009

The State Department alerts U.S. citizens to safety and security concerns in the city of Urumqi in China's Xinjiang Uyghur Autonomous Region. This Travel Alert expires on August 10, 2009.

On July 5, 2009, ethnic violence erupted in Urumqi. The unrest continued in the following days, with Chinese state media reporting over one hundred and fifty deaths and more than one thousand injured. There is a significant increased security presence in Urumqi and its environs; sporadic outbreaks of violence may still occur.

There are no indications that this violence is directed at U.S. citizens; however, Americans in Urumqi and throughout Xinjiang are advised to avoid areas where demonstrations and large gatherings are taking place. U.S. citizens in Urumqi should remain indoors and avoid unnecessary movement within the city. Americans planning a trip to Xinjiang are advised to defer travel to the region at this time.

U.S. citizens are strongly encouraged to register with the nearest U.S. Embassy or Consulate through the Department of State’s travel registration website. By registering, American citizens can receive the Embassy’s most recent security and safety updates during their trip. Registration also ensures that U.S. citizens can be reached should an emergency arise either abroad or at home. While consular officers will do their utmost to assist Americans in a crisis, travelers always should be aware that local authorities bear primary responsibility for the welfare of people living or traveling in their jurisdictions.

Beijing: The U.S. Embassy is located at No. 55 An Jia Lou Road, Chaoyang District, Beijing. The American Citizen Services section can be contacted during regular business hours and for after-hours emergencies at (86) (10) 8531-4000. For detailed information please visit the U.S. Embassy web site. The Embassy consular district includes the following provinces/regions of China: Beijing, Tianjin, Shandong, Shanxi, Inner Mongolia, Ningxia, Shaanxi, Qinghai, Xinjiang, Hebei, Henan, Hubei, Hunan, and Jiangxi.

Chengdu: The U.S. Consulate General in Chengdu is located at Number 4, Lingshiguan Road, Section 4, Renmin Nanlu, Chengdu 610041; tel. (86)(28) 8558-3992, 8555-3119; after-hours emergencies (86)(28) 1370 8001 422. This consular district includes the following provinces/regions of China: Guizhou, Sichuan Xizang (Tibet), and Yunnan, as well as the municipality of Chongqing.

Guangzhou: The main office of the U.S. Consulate General in Guangzhou is located at Number 1 South Shamian Street, Shamian Island 200S1, Guangzhou 510133. The Consular Section, including the American Citizens Services Unit, is now located at 5th Floor, Tianyu Garden (II phase), 136-146 Lin He Zhong Lu, Tianhe District; tel. (86)(20) 8518-7605; after-hours emergencies (86)(20) 8121-8000. This consular district includes the following provinces/regions of China: Guangdong, Guangxi, Hainan, and Fujian.

Shanghai: The Consular Section of the U.S. Consulate General in Shanghai is located in the Westgate Mall, 8th Floor, 1038 Nanjing Xi Lu, Shanghai 200031; tel. (86)(21) 3217-4650, ext. 2102, 2013, or 2134; after-hours emergencies (86)(21) 6433-3936. This consular district includes the following provinces/regions of China: Shanghai, Anhui, Jiangsu and Zhejiang.

Shenyang: The U.S. Consulate General in Shenyang is located at No. 52, 14th Wei Road, Heping District, Shenyang 110003; tel. (86)(24) 2322-2374; after-hours emergencies (86)(24) 137-0988-9307. This consular district includes the following provinces/regions of China: Liaoning, Heilongjiang, and Jilin.

13. Travelers may obtain up-to-date information on security conditions by calling 1-888-407-4747 toll-free in the U.S. or outside the U.S. and Canada on a regular toll line at 1-202-501-4444.

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 /trv_rd.cfm
Time Stamp 05-Jun-20 07:15 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.75
Host Name 173.245.54.75


Execution Time

Total Time Avg Time Count Template
101 ms 101 ms 1 top level /home/www/html/trv_rd.cfm
65 ms 65 ms 1 /home/www/html/navsidesbottom_rdesign4.cfm
62 ms 62 ms 1 /home/www/html/navpropertybox_interim_main_new.cfm
62 ms 62 ms 1 /home/www/html/navrightmidcolumn_rdesign4.cfm
34 ms 34 ms 1 /home/www/html/navtop_rdesign4.cfm
10 ms 10 ms 1 /home/www/html/leftnav_rdesign4.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
2 ms 1 ms 3 /home/www/html/boolsearch.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navtower_rdesign4.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign4.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign4.cfm
0 ms 0 ms 1 /home/www/html/constants.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 6 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/datasources.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
106 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 @ 19:15:37.037
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 19:15:37.037
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/trv_rd.cfm @ 19:15:37.037
	Select *
	From articles
	Where articleID = 3392 
UpdateImpressions (Datasource=expert, Time=2ms, Records=1) in /home/www/html/trv_rd.cfm @ 19:15:37.037
  UPDATE articles
  SET impressions = impressions + 1
	Where articleID = 3392 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 19:15:37.037
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 19:15:37.037
	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 @ 19:15:37.037
	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 @ 19:15:37.037
  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
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign4.cfm @ 19:15:37.037
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.75'
and logtime > "2020-06-05 00:00:00.000"
and logtime < "2020-06-05 23:59:59.999"
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign4.cfm @ 19:15:37.037
	SELECT *
	From contentcountcountry
	Where networkid = 31 
getmovingintro (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navtop_rdesign4.cfm @ 19:15:37.037
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	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 sectionintro = 'y'
   and articleCategories.section = '1'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
     and hpimg <> 'none'
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-05"

    ORDER by articles.articleID desc
    
gettentips (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navtop_rdesign4.cfm @ 19:15:37.037
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%10%') OR (author LIKE '%10%') OR (hitopic LIKE '%10%') OR (hidescript LIKE '%10%')) AND ((title LIKE '%Tips%') OR (author LIKE '%Tips%') OR (hitopic LIKE '%Tips%') OR (hidescript LIKE '%Tips%')) AND ((title LIKE '%for%') OR (author LIKE '%for%') OR (hitopic LIKE '%for%') OR (hidescript LIKE '%for%')) AND ((title LIKE '%Living%') OR (author LIKE '%Living%') OR (hitopic LIKE '%Living%') OR (hidescript LIKE '%Living%')) AND ((title LIKE '%in%') OR (author LIKE '%in%') OR (hitopic LIKE '%in%') OR (hidescript LIKE '%in%')) AND ((title LIKE '%China%') OR (author LIKE '%China%') OR (hitopic LIKE '%China%') OR (hidescript LIKE '%China%')))
	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 publishdate < "2020-06-05"
    ORDER by articles.articleID asc
gethealthintro (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navtop_rdesign4.cfm @ 19:15:37.037
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	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 sectionintro = 'y'
   and articleCategories.section = '9'
    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-06-05"

    ORDER by articles.articleID desc
    
getmovingintro (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navtop_rdesign4.cfm @ 19:15:37.037
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	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 sectionintro = 'y'
   and articleCategories.section = '1'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
     and hpimg <> 'none'
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-05"

    ORDER by articles.articleID desc
    
gettentips (Datasource=expert, Time=5ms, Records=1) in /home/www/html/leftnav_rdesign4.cfm @ 19:15:37.037
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%10%') OR (author LIKE '%10%') OR (hitopic LIKE '%10%') OR (hidescript LIKE '%10%')) AND ((title LIKE '%Tips%') OR (author LIKE '%Tips%') OR (hitopic LIKE '%Tips%') OR (hidescript LIKE '%Tips%')) AND ((title LIKE '%for%') OR (author LIKE '%for%') OR (hitopic LIKE '%for%') OR (hidescript LIKE '%for%')) AND ((title LIKE '%Living%') OR (author LIKE '%Living%') OR (hitopic LIKE '%Living%') OR (hidescript LIKE '%Living%')) AND ((title LIKE '%in%') OR (author LIKE '%in%') OR (hitopic LIKE '%in%') OR (hidescript LIKE '%in%')) AND ((title LIKE '%China%') OR (author LIKE '%China%') OR (hitopic LIKE '%China%') OR (hidescript LIKE '%China%')))
	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 publishdate < "2020-06-05"
    ORDER by articles.articleID desc
checkhealthintro (Datasource=expert, Time=0ms, Records=1) in /home/www/html/leftnav_rdesign4.cfm @ 19:15:37.037
	Select hcsectionintro
	From contentcountcountry
	where networkid = 31 
	and hcsectionintro <> 0
contentcount (Datasource=expert, Time=0ms, Records=1) in /home/www/html/leftnav_rdesign4.cfm @ 19:15:37.037
	Select *
	From contentcountcountry
	where networkid = 31 
gethealthintro (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/leftnav_rdesign4.cfm @ 19:15:37.037
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	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 sectionintro = 'y'
   and articleCategories.section = '9'
    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-06-05"

    ORDER by articles.articleID desc
    
gettower (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtower_rdesign4.cfm @ 19:15:37.037
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eesubtowercountry"
    and toDate > "2020-06-04"
    and fromDate < "2020-06-05"
    and weight > 7
    and bannerPlacement.networkid = 31
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navtower_rdesign4.cfm @ 19:15:37.037
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 870 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign4.cfm @ 19:15:37.037
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-06-04"
    and fromDate < "2020-06-05"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign4.cfm @ 19:15:37.037
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getpropertyslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
SELECT *
FROM topics
WHERE topicid = 6
getclass (Datasource=tipripper, Time=24ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid, answers.rid, allreports.networkname, allreports.networkid, allreports.city, allreports.state
	FROM answersphoto, answers, allreports 
	WHERE answersphoto.answerid = answers.answerid
	and allreports.answerid = answers.answerid
	and allreports.topicid = 6
	and allreports.hide <> 'y'
	and (answers.paid = 'yes' or answers.paid = 'free')
	AND answersphoto.qid = '104'
	AND allreports.networkid = 31
	AND "2020-06-05" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
getclass (Datasource=tipripper, Time=0ms, Records=71, Cached Query) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid, answers.rid, allreports.networkname, allreports.networkid, allreports.city, allreports.state
	FROM answersphoto, answers, allreports 
	WHERE answersphoto.answerid = answers.answerid
	and allreports.answerid = answers.answerid
	and allreports.topicid = 6
	and allreports.hide <> 'y'
	and (answers.paid = 'yes' or answers.paid = 'free')
	AND answersphoto.qid = '104'
	AND "2020-06-05" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
getprice (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80565'
	AND answerstext.qid = 109
getbed (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80565'
	AND answerstext.qid = 113
getbath (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80565'
	AND answerstext.qid = 114
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '33'
getrentorsale (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80565'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80565'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80565'
AND answersmc.qoid = qoptions.qoid
getprice (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80561'
	AND answerstext.qid = 109
getbed (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80561'
	AND answerstext.qid = 113
getbath (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80561'
	AND answerstext.qid = 114
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '43'
getrentorsale (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80561'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80561'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80561'
AND answersmc.qoid = qoptions.qoid
getprice (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	AND answerstext.qid = 109
getbed (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	AND answerstext.qid = 113
getbath (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	AND answerstext.qid = 114
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getrentorsale (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80557'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80557'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 19:15:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80557'
AND answersmc.qoid = qoptions.qoid
gettentips (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/bottommobilenav_rdesign4.cfm @ 19:15:37.037
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%10%') OR (author LIKE '%10%') OR (hitopic LIKE '%10%') OR (hidescript LIKE '%10%')) AND ((title LIKE '%Tips%') OR (author LIKE '%Tips%') OR (hitopic LIKE '%Tips%') OR (hidescript LIKE '%Tips%')) AND ((title LIKE '%for%') OR (author LIKE '%for%') OR (hitopic LIKE '%for%') OR (hidescript LIKE '%for%')) AND ((title LIKE '%Living%') OR (author LIKE '%Living%') OR (hitopic LIKE '%Living%') OR (hidescript LIKE '%Living%')) AND ((title LIKE '%in%') OR (author LIKE '%in%') OR (hitopic LIKE '%in%') OR (hidescript LIKE '%in%')) AND ((title LIKE '%China%') OR (author LIKE '%China%') OR (hitopic LIKE '%China%') OR (hidescript LIKE '%China%')))
	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 publishdate < "2020-06-05"
    ORDER by articles.articleID asc
checkhealthintro (Datasource=expert, Time=0ms, Records=1) in /home/www/html/bottommobilenav_rdesign4.cfm @ 19:15:37.037
	Select hcsectionintro
	From contentcountcountry
	where networkid = 31 
	and hcsectionintro <> 0
gethealthintro (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/bottommobilenav_rdesign4.cfm @ 19:15:37.037
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	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 sectionintro = 'y'
   and articleCategories.section = '9'
    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-06-05"

    ORDER by articles.articleID desc
    


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/trv_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/trv_rd.cfm
QUERY_STRING=articleid=3392&networkid=31
REMOTE_ADDR=173.245.54.75
REMOTE_HOST=173.245.54.75
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/trv_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=29065732
cftoken=86994352
sessionid=IBEXPATEXCHANGE.COM_29065732_86994352
urltoken=CFID=29065732&CFTOKEN=86994352
URL Parameters:
articleid=3392
networkid=31
Debug Rendering Time: 10 ms