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 Public Announcement

Issued by US Department of State

Apr 02, 2003

This Public Announcement is being issued to alert U.S. citizens that the Department of State has authorized the departure, on a voluntary basis, of non-emergency employees and all family members at the U.S. Consulate General in Guangzhou, China, as a precautionary measure due to the Severe Acute Respiratory Syndrome (SARS) situation. The Consulate General remains open to provide the full range of services to American citizens and the general public. This Public Announcement expires on June 26, 2003.

The Centers for Disease Control and Prevention (CDC) recommends U.S. Citizens defer elective or non-essential travel to areas with a large number of SARS cases, including Mainland China and Hong Kong. U.S. citizens resident or traveling in these areas should closely monitor the website of the Center for Disease Control and Prevention at http://www.cdc.gov and the website of the World Health Organization at http://www.who.int. for the latest information on SARS.

For further information on travel to China, U.S. citizens should also consult the Department of States Consular Information Sheets for China, the Fact Sheet on SARS and the SARS in Asia Public Announcement, all of which are located at http://www.travel.state.gov.

Beijing: The U.S. Embassy in China is located at 2 Xiu Shui Dong Jie, Beijing 100600, telephone: (86-10) 6532-3431, 6532-3831, and after-hours: (86-10) 6532-1910; fax (86-10) 6532-4153. The U.S. Embassy web site address is http://www.usembassy-china.org.cn and the e-mail address is 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, telephone: (86-28) 558-3992, 555-3119; fax (86-28) 558-3520; after-hours (86-0) 13708001422. 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 U.S. Consulate General in Guangzhou is located at Number 1 South Shamian Street, Shamian Island 200S1, Guangzhou 510133; telephone: (86-20) 8121-8418; after-hours: (86-)139-0229-3169; fax: (86-20) 8121-8428. This consular district includes the following provinces/regions of China: Guangdong, Guangxi, Hainan, and Fujian.

Shanghai: The U.S. Consulate General in Shanghai is located at 1469 Huaihai Zhonglu, Shanghai 200031 telephone: (86-21) 6433-6880, after-hours: (86-21) 6433-3936; fax: (86-21) 6471-1493, 6433-4122, 6471-1148. 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, telephone: (86-24) 2322-1198, 2322-0368; after-hours: (86-0) 13704019790; fax (86-24) 2322-2374. This consular district includes the following provinces/regions of China: Liaoning, Heilongjiang, and Jilin.

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 01-Jun-20 04:13 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.127
Host Name 172.69.63.127


Execution Time

Total Time Avg Time Count Template
129 ms 129 ms 1 top level /home/www/html/trv_rd.cfm
90 ms 90 ms 1 /home/www/html/navsidesbottom_rdesign4.cfm
88 ms 88 ms 1 /home/www/html/navpropertybox_interim_main_new.cfm
88 ms 88 ms 1 /home/www/html/navrightmidcolumn_rdesign4.cfm
36 ms 36 ms 1 /home/www/html/navtop_rdesign4.cfm
11 ms 11 ms 1 /home/www/html/leftnav_rdesign4.cfm
6 ms 6 ms 1 /home/www/html/Application.cfm
3 ms 3 ms 1 /home/www/html/navtower_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/bottommobilenav_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.cfm
0 ms 0 ms 3 /home/www/html/boolsearch.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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
137 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 @ 16:13:31.031
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=4ms, Records=1) in /home/www/html/Application.cfm @ 16:13:31.031
      	  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 @ 16:13:31.031
	Select *
	From articles
	Where articleID = 1092 
UpdateImpressions (Datasource=expert, Time=2ms, Records=1) in /home/www/html/trv_rd.cfm @ 16:13:31.031
  UPDATE articles
  SET impressions = impressions + 1
	Where articleID = 1092 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 16:13:31.031
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 16:13:31.031
	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 @ 16:13:31.031
	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 @ 16:13:31.031
  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=0) in /home/www/html/navtop_rdesign4.cfm @ 16:13:31.031
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-06-01 00:00:00.000"
and logtime < "2020-06-01 23:59:59.999"
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign4.cfm @ 16:13:31.031
	SELECT *
	From contentcountcountry
	Where networkid = 31 
getmovingintro (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navtop_rdesign4.cfm @ 16:13:31.031
	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-01"

    ORDER by articles.articleID desc
    
gettentips (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navtop_rdesign4.cfm @ 16:13:31.031
	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-01"
    ORDER by articles.articleID asc
gethealthintro (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navtop_rdesign4.cfm @ 16:13:31.031
	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-01"

    ORDER by articles.articleID desc
    
getmovingintro (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navtop_rdesign4.cfm @ 16:13:31.031
	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-01"

    ORDER by articles.articleID desc
    
gettentips (Datasource=expert, Time=6ms, Records=1) in /home/www/html/leftnav_rdesign4.cfm @ 16:13:31.031
	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-01"
    ORDER by articles.articleID desc
checkhealthintro (Datasource=expert, Time=0ms, Records=1) in /home/www/html/leftnav_rdesign4.cfm @ 16:13:31.031
	Select hcsectionintro
	From contentcountcountry
	where networkid = 31 
	and hcsectionintro <> 0
contentcount (Datasource=expert, Time=1ms, Records=1) in /home/www/html/leftnav_rdesign4.cfm @ 16:13:31.031
	Select *
	From contentcountcountry
	where networkid = 31 
gethealthintro (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/leftnav_rdesign4.cfm @ 16:13:31.031
	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-01"

    ORDER by articles.articleID desc
    
gettower (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtower_rdesign4.cfm @ 16:13:31.031
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eesubtowercountry"
    and toDate > "2020-05-31"
    and fromDate < "2020-06-01"
    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 @ 16:13:31.031
  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 @ 16:13:31.031
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-05-31"
    and fromDate < "2020-06-01"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign4.cfm @ 16:13:31.031
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getpropertyslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
SELECT *
FROM topics
WHERE topicid = 6
getclass (Datasource=tipripper, Time=24ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
	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-01" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
getclass (Datasource=tipripper, Time=24ms, Records=71) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
	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-01" < 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 @ 16:13:31.031
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80477'
	AND answerstext.qid = 109
getbed (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80477'
	AND answerstext.qid = 113
getbath (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80477'
	AND answerstext.qid = 114
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
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 @ 16:13:31.031
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80477'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80477'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80477'
AND answersmc.qoid = qoptions.qoid
getprice (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80470'
	AND answerstext.qid = 109
getbed (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80470'
	AND answerstext.qid = 113
getbath (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80470'
	AND answerstext.qid = 114
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '90'
getrentorsale (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80470'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80470'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80470'
AND answersmc.qoid = qoptions.qoid
getprice (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80464'
	AND answerstext.qid = 109
getbed (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80464'
	AND answerstext.qid = 113
getbath (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80464'
	AND answerstext.qid = 114
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '33'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80464'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80464'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 16:13:31.031
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80464'
AND answersmc.qoid = qoptions.qoid
gettentips (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/bottommobilenav_rdesign4.cfm @ 16:13:31.031
	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-01"
    ORDER by articles.articleID asc
checkhealthintro (Datasource=expert, Time=0ms, Records=1) in /home/www/html/bottommobilenav_rdesign4.cfm @ 16:13:31.031
	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 @ 16:13:31.031
	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-01"

    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=1092&networkid=31
REMOTE_ADDR=172.69.63.127
REMOTE_HOST=172.69.63.127
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=28830970
cftoken=23123225
sessionid=IBEXPATEXCHANGE.COM_28830970_23123225
urltoken=CFID=28830970&CFTOKEN=23123225
URL Parameters:
articleid=1092
networkid=31
Debug Rendering Time: 10 ms