Home UK Forum UK Guide Moving to UK Real Estate Healthcare in UK
UK
Resources
City Guides
JoinSign In
AGS Worldwide Movers

Expat Guide to Living in Penzance

Whether you're already living in Penzance or preparing to move to Penzance, our Expat Guide to Living in UK offers articles and reports submitted by expats about expat life in Penzance. For answers to specific questions, visit our UK Forum to talk with expats in Penzance.

Culture Shock Report

Culture shock is part of the settling in process. Knowing the different phases of culture shock and how other expats in Penzance handle it can be very comforting. Help others preparing to move to Penzance by filling out our Culture Shock Report.

Submit a Culture Shock Report

Living Overseas Report

What are people's priorities in Penzance - 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 Penzance by filling out our Living Overseas Report.

Submit a Living Overseas Report

Moving Overseas Report

What should you take with you when you move to Penzance? What should you leave behind? What type of housing and neighborhoods are typical for expats in Penzance? Help others moving to Penzance by filling out our Moving Overseas Report.

Submit a Moving Overseas Report

Dream vs. Reality Report

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Penzance. If you are already living in Penzance, 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 Penzance 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 Penzance? Help other expats who are preparing to have a baby in Penzance by filling out our Having a Baby Abroad Report.

Submit a Having a Baby Abroad Report

Working Abroad Report

What's it like to find a job in Penzance? How difficult was it to obtain a work permit? What types are jobs are typical for expats in Penzance? Help others following in your footsteps by filling out our Working Abroad Report.

Submit a Working Abroad Report
Cigna Expat Health InsuranceExpatriate Health Insurance

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

10-Expats-Talk-about-What-Its-Like-Moving-to-the-UK10 Expats Talk about What It's Like Moving to the UK

Expats talk about what it was like moving to the UK. Topics covered include meeting people, NHS, culture shock and more.
Expats talk about what it was like moving to the UK. Topics covered include meeting people, NHS, culture shock and more....

Living-in-LondonLondon Information for Expats: Introduction

If you are now, or will be, an expat living in London, you have come to the right place. We have pulled together enough information so that, at the very least, you won't feel like you are flying blind after moving overseas.

If you are now, or will be, an expat living in London, you have come to the right place. We have pulled together enough information so that, at the very least, you won't feel like you are flying blin...

Moving-To-LondonMoving to London: Expat Package Negotiation

Advice for expats in London about expat package negotiation and cost of living in London.

Advice for expats in London about expat package negotiation and cost of living in London....

Living-in-LondonLondon: Key Topics

An overview of key topics for expats in London. Covers visas, schools, housing, cost of living in London and more.

An overview of key topics for expats in London. Covers visas, schools, housing, cost of living in London and more....

Moving-To-SheffieldAn Expat Talks about Moving to Sheffield, UK

An expat in discusses renting a home in Sheffield, England. The red tape involved in finding a rental can be challenging (i.e. a 3 year history of utility bills) coupled with the high cost of housing.

An expat in discusses renting a home in Sheffield, England. The red tape involved in finding a rental can be challenging (i.e. a 3 year history of utility bills) coupled with the high cost of housing...

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


Execution Time

Total Time Avg Time Count Template
229 ms 229 ms 1 top level /home/www/html/expatguide.cfm
27 ms 27 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
26 ms 26 ms 1 /home/www/html/navcontentbox.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
4 ms 4 ms 1 /home/www/html/navmeta_rdesign4.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
3 ms 0 ms 12 /home/www/html/rewriteqoptionsctry.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 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/boolsearch.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 12 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 12 /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
234 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:08:13.013
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 13:08:13.013
      	  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 @ 13:08:13.013
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 13:08:13.013
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 1 
getcities (Datasource=expert, Time=1ms, Records=9) in /home/www/html/navmeta_rdesign4.cfm @ 13:08:13.013
	Select *
	From citynetworks
	Where networkID = 1
	and status <> 'hold'
	ORDER by city
getcity (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 13:08:13.013
	Select *
	From citynetworks
	Where citynetworkid = 5057 
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 13:08:13.013
  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 @ 13:08:13.013
	Select *
	From Networks
	Where networkID = 1 
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 13:08:13.013
	Select *
	From countryphotos
	Where networkID = 1
	and citynetworkid = 5057 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 13:08:13.013
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
and logtime > "2020-04-12"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 13:08:13.013
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
and logtime > "2020-07-12 00:00:00.000"
and logtime < "2020-07-12 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 @ 13:08:13.013
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
and logtime > "2020-07-05"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 13:08:13.013
	SELECT *
	From contentcountcountry
	Where networkid = 1 
gettopbanner (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 13:08:13.013
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-11"
    and fromDate < "2020-07-12"
    and bannerPlacement.networkid = '1'
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 13:08:13.013
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 13:08:13.013
	Select *
	From citynetworks 
	Where citynetworkid = 5057 
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement, articlecityplace 
 	Where hitopic <> ''
 	and articlePlacement.networkID = 1 
 	and articlecityplace.citynetworkid = 5057
    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-12"
    ORDER by articles.articleID desc
gettaxgeneral (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%Penzance%') OR (author LIKE '%Penzance%') OR (hitopic LIKE '%Penzance%') OR (hidescript LIKE '%Penzance%')))
	and articlePlacement.networkID = 1 
	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-12"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 13:08:13.013
SELECT qoid, value 
FROM qoptions 

WHERE value = 'UK' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 1 
         and citynetworkid = 5057 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 1 
         and citynetworkid = 5057 
         and city <> ''
         
   	 order by date DESC
   	
checkparenting (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 1 
         and citynetworkid = 5057 
         and city <> ''
         
   	 order by date DESC
   	
checkdreamfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 1 
         and citynetworkid = 5057 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 1 
         and citynetworkid = 5057 
         and city <> ''
         
   	 order by date DESC
   	
checkculturefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 1 
         and citynetworkid = 5057 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 1 
         and citynetworkid = 5057 
         and city <> ''
         
   	 order by date DESC
   	
checkmovingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 1 
         and citynetworkid = 5057 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 1 
         and citynetworkid = 5057 
   	 order by date DESC
   	
checklivingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 1 
         and citynetworkid = 5057 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 1 
         and citynetworkid = 5057 
   	 order by date DESC
   	
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 1 
         and citynetworkid = 5057 
   	 order by date DESC
   	
checkwork (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 1 
         and citynetworkid = 5057 
   	 order by date DESC
   	
checkschool (Datasource=expert, Time=5ms, Records=11) in /home/www/html/expatguide.cfm @ 13:08:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 1 
         and citynetworkid = 5057 
   	 order by date DESC
   	
getrealestateadvice (Datasource=tipripper, Time=4ms, Records=2) in /home/www/html/expatguide.cfm @ 13:08:13.013
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 1
and allreports.networkid = 1
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 1
and allreports.networkid = 1
 and allreports.citynetworkid2 =  5057
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 1
and allreports.networkid = 1
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 1
and allreports.networkid = 1
 and allreports.citynetworkid2 =  5057
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 1
and allreports.networkid = 1
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 13:08:13.013
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 1
and allreports.networkid = 1
 and allreports.citynetworkid2 =  5057
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 13:08:13.013
	Select *
	From Networks
	Where networkID = 1 
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 13:08:13.013
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25751
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 13:08:13.013
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25215
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 13:08:13.013
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25130
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 13:08:13.013
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25048
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 13:08:13.013
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24992
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 13:08:13.013
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24546
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 13:08:13.013
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24398
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 13:08:13.013
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24370
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 13:08:13.013
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24270
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 13:08:13.013
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 23966
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 13:08:13.013
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 23890
				AND answerstext.qid = 82
					
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:08:13.013
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-12"
     
         and rptarticlenetworks.networkid = 1 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 13:08:13.013
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 35
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 13:08:13.013
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 1 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:08:13.013
SELECT  hiimg
FROM rptarticles
where rptarticleID = 35
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 13:08:13.013
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 1 
	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-12"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 13:08:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 1 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:08:13.013
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 1 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:08:13.013
		Select summary, hiimg 
		FROM answers
         where answerid = 75199
         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=1&citynetworkid=5057
REMOTE_ADDR=172.68.65.192
REMOTE_HOST=172.68.65.192
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=31763722
cftoken=75366267
sessionid=IBEXPATEXCHANGE.COM_31763722_75366267
urltoken=CFID=31763722&CFTOKEN=75366267
URL Parameters:
citynetworkid=5057
networkid=1
Debug Rendering Time: 9 ms