UK
Resources
City Guides
JoinSign In
Cigna International Health Insurance

Living in UK > London >

An Expat Talks about Living in London, UK


Kingly Street in London

An American expat in London offers some advice on what it takes to get settled in the UK's capital city.

What is the name of the city or town that you are reporting on?

London

How long have you lived there?

3 Years

What activities, clubs and organizations would you recommend to newcomers to help them meet others?

Become a member of something that interests you, whether a service organization, sport, art, or hobby. For instance, I joined the Royal Horticultural Society, which oversees several gardens in the UK, as well as organizing internationally regarded garden shows, as well as a community ceramics studio.

Expats living in UK interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA. Get a Quote

Expats living in UK interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA.

In terms of religious, racial, economic and cultural diversity, are the people of this city or town diverse? Are they accepting of differences? Describe.

London is a very integrated and accepting city. People who come here should expect a level playing field as far as race is concerned.

What are the main industries in this city? What types of career opportunities commonly exist? How do most people find new jobs?

All major industries are represented. London is a major financial center and other industries, as well.

In general, what are peoples' priorities in this city? For example, do lives revolve around work, family, socializing, sports, etc.?

All of the above, with work and family being top priorities.

Moving to UK

Moving to UK soon? AGS Worldwide Movers is a leader in the international moving industry. Their experience and expertise allows them to guarantee their clients the best quality moving services. Get a moving quote today.

If a friend of yours was thinking of moving to this city or town from far away, what other advice would you give them.

London takes time to know and understand, as do Londoners. Do not take our common language for granted - it takes effort to make friends and to settle in, learning English rythms, ways of seeing the world. Do not mistake friendly responses for friendship; in most cases, it's simply their being polite. Be patient and you will eventually feel as though you're accepted.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

More about London

Guide to Living in London

Guide to Living in London

If you're a global nomad in London or living in London, expats there have a lot to share to newcomers. Here are 11 things to know about living in London.

Best Places to Live in London

Best Places to Live in London

Here's a guide to the best neighborhoods in London. There are a lot of options for a lot of different situations. We'll be adding new neighborhoods and updating it regularly.

Cost of Living in London

Cost of Living in London

The cost of living in London routinely ranks among the highest in the world. Here is some basic information about the realities of living in London and what you'll need to consider when deciding whether or not to move there.

Healthcare in UK

Healthcare in UK

Expats in the U.K. are able to utilize the public health care system, which is managed by the NHS. Many expats want to have private health insurance to help reduce wait times and several other reasons. Read for more details on how to navigate the system. Plus, a list of the best hospital in London.

Schools in London

International Schools in London

Families moving to London who are interested in an American curriculum, IB program or bi-lingual education for their children, may be interested in these popular expat schools.

Moving-to-London

Moving to London

Expats describe London as a love it or hate it city. With it's high cost of living and rainy weather, it's not for everyone. But, those who move to London and love it will tell you that the city's tremendous diversity, vibrant nightlife, incredible restaurants and varied neighborhoods.

Expats describe London as a love it or hate it city. With it's high cost of living and rainy weather, it's not for everyone. But, those who move to London and love it will tell you that the city's t...

5-Best-Suburbs-for-Expats-Living-in-London

5 Best Suburbs for Expats Living in London

Expats moving to the UK who plan to work in London often want to live in a village or smaller city and commute to the city. Here are a few options to consider.

Expats moving to the UK who plan to work in London often want to live in a village or smaller city and commute to the city. Here are a few options to consider....

London-Cost-of-Living

London Cost of Living

It's no secret that the cost of living in London is extremely high, but how high? For a newcomer or someone preparing to move to London, this cost of living comparison offers some insight.

It's no secret that the cost of living in London is extremely high, but how high? For a newcomer or someone preparing to move to London, this cost of living comparison offers some insight....

Join our UK Expat Forum

Visit our UK Forum and talk with other expats who can offer you insight and tips about living in London, UK.

More about UK

An-Interview-with-A-Lady-in-Londons-Julie-FalconerExpat UK: An Interview with A Lady in London

An expat interview with Julie Falconer, a travel writer and author of the blog - A Lady in London.

How-Expats-Can-Maximise-Living-SpaceLiving in London: How To Maximise Your Living Space

Expats living in London sometimes struggle to find room for their belongings. Matt Cook offers advice on how to make the most of your space and love your life in London.

Jobs-in-the-British-National-Health-ServiceOverseas Nurses and Jobs in the British National Health Service

With scores of NHS-funded hospitals recruiting overseas nurses, Brit Peacock offers advice for nurses interested in moving to the UK.

Thanksgiving-in-LondonThanksgiving in London

There are numerous restaurants in London that offer wonderful Thanksgiving menus for expats and locals! Here are few of our favorites.

Cigna International Health Insurance

Write a Comment about this Expat Report

Sign In to post a comment.
addacomment
Cigna Expat Health InsuranceExpatriate Health Insurance

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

Guide to Living in LondonGuide to Living in London

If you're a global nomad in London or living in London, expats there have a lot to share to newcomers. Here are 11 things to know about living in London.

Healthcare in UKHealthcare in UK

Expats in the U.K. are able to utilize the public health care system, which is managed by the NHS. Many expats want to have private health insurance to help reduce wait times and several other reasons. Read for more details on how to navigate the system. Plus, a list of the best hospital in London.

Best Places to Live in LondonBest Places to Live in London

Here's a guide to the best neighborhoods in London. There are a lot of options for a lot of different situations. We'll be adding new neighborhoods and updating it regularly.

Cost of Living in LondonCost of Living in London

The cost of living in London routinely ranks among the highest in the world. Here is some basic information about the realities of living in London and what you'll need to consider when deciding whether or not to move there.

Schools in LondonInternational Schools in London

Families moving to London who are interested in an American curriculum, IB program or bi-lingual education for their children, may be interested in these popular expat schools.

Restaurants in LondonRestaurants in London

Support your favorite restaurants in London as they recover from the pandemic. Submit a free listing for them on Expat Exchange to help spread the word about them to the expat community.

Moving-to-LondonMoving to London

Expats describe London as a love it or hate it city. With it's high cost of living and rainy weather, it's not for everyone. But, those who move to London and love it will tell you that the city's tremendous diversity, vibrant nightlife, incredible restaurants and varied neighborhoods.

Expats describe London as a love it or hate it city. With it's high cost of living and rainy weather, it's not for everyone. But, those who move to London and love it will tell you that the city's t...

5-Best-Suburbs-for-Expats-Living-in-London5 Best Suburbs for Expats Living in London

Expats moving to the UK who plan to work in London often want to live in a village or smaller city and commute to the city. Here are a few options to consider.

Expats moving to the UK who plan to work in London often want to live in a village or smaller city and commute to the city. Here are a few options to consider....

London-Cost-of-LivingLondon Cost of Living

It's no secret that the cost of living in London is extremely high, but how high? For a newcomer or someone preparing to move to London, this cost of living comparison offers some insight.

It's no secret that the cost of living in London is extremely high, but how high? For a newcomer or someone preparing to move to London, this cost of living comparison offers some insight....

An-Interview-with-A-Lady-in-Londons-Julie-FalconerExpat UK: An Interview with A Lady in London

An expat interview with Julie Falconer, a travel writer and author of the blog - A Lady in London.

How-Expats-Can-Maximise-Living-SpaceLiving in London: How To Maximise Your Living Space

Expats living in London sometimes struggle to find room for their belongings. Matt Cook offers advice on how to make the most of your space and love your life in London.

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 /rspnet.cfm
Time Stamp 13-Aug-20 10:22 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.62.244
Host Name 172.69.62.244


Execution Time

Total Time Avg Time Count Template
86 ms 86 ms 1 top level /home/www/html/rspnet.cfm
28 ms 28 ms 1 /home/www/html/navcontentboxcityrptsmobile.cfm
14 ms 14 ms 1 /home/www/html/navtop_rdesign5.cfm
13 ms 13 ms 1 /home/www/html/Application.cfm
11 ms 11 ms 1 /home/www/html/breadcrumb_ctygd.cfm
9 ms 9 ms 1 /home/www/html/rspnet_ctygd_readnext.cfm
8 ms 8 ms 1 /home/www/html/commentsnew_rdesign4.cfm
7 ms 7 ms 1 /home/www/html/navleader_rdesign5.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
4 ms 4 ms 1 /home/www/html/navbottomad_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navcontentboxcitypc.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
3 ms 3 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navmpu_rdesign5.cfm
1 ms 0 ms 13 /home/www/html/rewritearticle.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/constants.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navlikeandmore_rdesign5.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
100 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 @ 22:22:34.034
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=11ms, Records=1) in /home/www/html/Application.cfm @ 22:22:34.034
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getreportresponses (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rspnet.cfm @ 22:22:34.034
SELECT  networkname as ctry, city, networkid, rid, networkname, answerid, citynetworkid
FROM allreports
WHERE rid = 58
AND networkid = 1 
AND 69457 = answerid

GROUP BY answerid
ORDER by city
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 22:22:34.034
	Select *
	From allreports, citynetworks 
	Where allreports.answerid = 69457
	and allreports.citynetworkid = citynetworks.citynetworkid
getquestions (Datasource=reports, Time=6ms, Records=7) in /home/www/html/rspnet.cfm @ 22:22:34.034
SELECT DISTINCT questions.qid, answers.answerid, questions.question, responsequestions.qid, answerstext.qid, answerstext.answer as answer, answerstext.reviewed, answerstext.score, answers.rid, answers.reviewed, responses.intro, responses.responsename, responsequestions.listorder, answers.userid, answers.date
FROM responsequestions, questions, answers, responses, answerstext
WHERE answerstext.qid = questions.qid

AND 69457 = answerstext.answerid
 
AND answerstext.score > 1
AND answerstext.answer <> ''

AND answers.answerid = 69457 
AND answers.reviewed = 'y'
AND questions.qid = responsequestions.qid
AND responses.responseid = responsequestions.responseid
AND answers.rid = responses.rid
ORDER BY responsequestions.listorder ASC
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 22:22:34.034
SELECT DISTINCT img, photocaption, summary, hpimg, fbimg, twimg
FROM answers 
WHERE answers.answerid = 69457 
GetNetworks (Datasource=expert, Time=1ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:22:34.034
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 22:22:34.034
	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 @ 22:22:34.034
	Select *
	From citynetworks
	Where networkID = 1
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:22:34.034
  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
GetMessages (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 22:22:34.034
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 69457 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:22:34.034
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.244'
and logtime > "2020-05-14"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 22:22:34.034
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.244'
and logtime > "2020-08-13 00:00:00.000"
and logtime < "2020-08-13 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 @ 22:22:34.034
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.244'
and logtime > "2020-08-06"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:22:34.034
	SELECT *
	From contentcountcountry
	Where networkid = 1 
citycontentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:22:34.034
	SELECT *
	From contentcountcity
	Where citynetworkid = 4249 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 22:22:34.034
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-08-12"
    and fromDate < "2020-08-13"
UpdatePageViews (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 22:22:34.034
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getarticlesection (Datasource=expert, Time=1ms, Records=345) in /home/www/html/breadcrumb_ctygd.cfm @ 22:22:34.034
SELECT *
FROM articleCategories
 
WHERE section = 6
checkcitynetwork (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 22:22:34.034
		Select *
		FROM allreports, citynetworks
         where answerid = 69457
         and citynetworks.citynetworkid = allreports.citynetworkid
         and citynetworks.status = 'live'
getlivingintro (Datasource=expert, Time=9ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 22:22:34.034
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 1 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
      and keycity = 0
    and cityintro = 'n'
    and sectionintro = 'y'
   and articleCategories.section = '6'
    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-08-13"

    ORDER by articles.articleID asc   
    
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 22:22:34.034
SELECT DISTINCT img, photocaption, summary, hpimg, twimg
FROM answers 
WHERE answers.answerid = 69457 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:22:34.034
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:22:34.034
	Select *
	From Networks
	Where networkid = 1 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:22:34.034
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:22:34.034
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 1
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-08-12"
and natsentencestart < "2020-08-13"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:22:34.034
SELECT *
FROM natadoptions 
WHERE 'moveheader' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:22:34.034
	Select *
	From Networks
	Where networkid = 1 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:22:34.034
SELECT *
FROM natadoptions 
WHERE natadtypeid = 6 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:22:34.034
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 6
and natadPlacement.networkID = 1
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-08-12"
and headerparagraphstart < "2020-08-13"
and headerparagraphstatus = 'live'

and (headerparagraphweight = 'medium' or headerparagraphweight = 'high')
gettaxgeneral2 (Datasource=expert, Time=10ms, Records=3) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:34.034
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articleCategories, articlecityplace
	Where hitopic <> ''
	and hidescript <> ''
    and type = '3'
   and articlecityplace.citynetworkid = 4249
	and articlecityplace.articleid = articles.articleID
     and articleCategories.articleID = articles.articleID
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = 0
    and cityintro = 'n'
    and summary <> ''
    
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-08-13" 
    ORDER by articles.articleID desc  
getguidesummary (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:34.034
	Select summary, hpimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4249
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
getbestsummary (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:34.034
	Select summary, hpimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4249
	and articlecityplace.articleid = articles.articleID
    and articles.keycity = 4
 
getcolsummary (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:34.034
	Select summary, hpimg
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4249
	and articlecityplace.articleid = articles.articleID
    and articles.keycity = 2
 
gethealthsummary (Datasource=expert, Time=7ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:34.034
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 1 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
getschoolsummary (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:34.034
	Select summary, hpimg
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4249
	and articlecityplace.articleid = articles.articleID
    and articles.keycity = 1
 
checklivingfeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:34.034
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
            
         and allreports.answerid <> 69457         
         and networkid = 1
          and citynetworkid = 4249
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:34.034
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 10124 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:34.034
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 5317 
gettaxgeneral (Datasource=expert, Time=7ms, Records=4) in /home/www/html/rspnet_ctygd_readnext.cfm @ 22:22:34.034
	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 keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and publishdate < "2020-08-13"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 22:22:34.034
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-08-12"
    and fromDate < "2020-08-13"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 22:22:34.034
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
gethpbox (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 22:22:34.034
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-08-12 22:22:34'}
    and fromDate <{ts '2020-08-13 22:22:34'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 22:22:34.034
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 22:22:34.034
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 69457 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
getguidesummary (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:34.034
	Select summary, hiimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4249
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
gethealthsummary (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:34.034
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 1 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    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/rspnet.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/rspnet.cfm
QUERY_STRING=rid=58&answerid=69457&networkid=1&start=69457
REMOTE_ADDR=172.69.62.244
REMOTE_HOST=172.69.62.244
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rspnet.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=33694909
cftoken=90035733
sessionid=IBEXPATEXCHANGE.COM_33694909_90035733
urltoken=CFID=33694909&CFTOKEN=90035733
URL Parameters:
answerid=69457
networkid=1
rid=58
start=69457
Debug Rendering Time: 12 ms