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

Expat Guide to Living in Hamilton

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

Expat Health Insurance and Healthcare

Expat Health Insurance and Healthcare in Hamilton

An expat in Bermuda offers tremendous insight into healthcare and health insurance in Bermuda. With one general hospital, King Edward Memorial Hospital, many people are advised to go overseas for surgery and complex issues. Another hospital, Mid Atlantic Wellness Institute, handles mental health and learning disabilities. She discusses prescription mediciness and insurance coverage as well.

Living in Hamilton, Bermuda

An expat in Bermuda talks about the high cost of living in Bermuda, meeting other expats, racial tensions and much more.

Dream vs Reality of Living in Hamilton, Bermuda

An experienced teacher who had vacationed in Bermuda many times eventually decided to move there. She faced serious challenges living in Bermuda and working as a single, Caucasian expat in a public school. She was repeatedly asked by Bermudians "Have you had enough?" Eventually, she had -- and she returned home to Canada.

Culture Shock Report

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

Submit a Culture Shock Report

More Living in Hamilton Reports

What are people's priorities in Hamilton - work? family? socializing? What are the best ways to meet other expats? Are people accepting of racial, cultural and religious differences? Below are some of the responses from expats in Hamilton:
Submit a Living Overseas Report

Moving Overseas Report

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

Submit a Moving Overseas Report

International School Report

Parents are invited to answer questions about the schools that their kids attend (Pre-K through High School) in hopes of helping others moving to Hamilton with the school selection process. If you have expat children who attend school in Hamilton, take a few minutes to submit a School Review.

Submit an International School Review

Dream vs. Reality of Living in Hamilton Reports

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Hamilton. If you are already living in Hamilton, share how those "dreams" have been fulfilled, and how they have not. Below are some of the reports from expats in Hamilton:
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 Hamilton 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 Hamilton? Help other expats who are preparing to have a baby in Hamilton by filling out our Having a Baby Abroad Report.

Submit a Having a Baby Abroad Report

Working in Hamilton Reports

What's it like to find a job in Hamilton? How difficult was it to obtain a work permit? What types are jobs are typical for expats in Hamilton? Below are some of the reports from expats in Hamilton:
Submit a Working Abroad Report
Cigna Expat Health InsuranceExpatriate Health Insurance

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

8-Expats-Talk-About-What-Its-Like-Living-in-Bermuda8 Expats Talk About What It's Like Living in Bermuda

Expats talk about meeting people in Bermuda, how the high cost of living in Bermuda impacts the expat lifestyle, challenges for single expats and more.
Expats talk about meeting people in Bermuda, how the high cost of living in Bermuda impacts the expat lifestyle, challenges for single expats and more....

Moving-to-BermudaMoving to Bermuda

Expats in Bermuda offer some excellent advice - and words of caution - about what it means to move to Bermuda. Housing, health care, basic tips and more are covered.

Expats in Bermuda offer some excellent advice - and words of caution - about what it means to move to Bermuda. Housing, health care, basic tips and more are covered....

Expats-in-Bermuda10 Tips for Living in Bermuda

Expats in Bermuda have mixed feelings about living in Bermuda. Everyone loves the sunshine and beaches, but the high cost of living, one car per household law, limited job opportunities and gossipy expat social scene can make life challenging.

Expats in Bermuda have mixed feelings about living in Bermuda. Everyone loves the sunshine and beaches, but the high cost of living, one car per household law, limited job opportunities and gossipy e...

Bermuda 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 03:25 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.62.46
Host Name 172.69.62.46


Execution Time

Total Time Avg Time Count Template
217 ms 217 ms 1 top level /home/www/html/expatguide.cfm
24 ms 24 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
24 ms 24 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
23 ms 23 ms 1 /home/www/html/navcontentbox.cfm
11 ms 11 ms 1 /home/www/html/navtop_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/Application.cfm
5 ms 5 ms 1 /home/www/html/navmeta_rdesign4.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/rewritearticlefirsttitle.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/eetr/rewritetipheading.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/navjoin_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/rewritearticle.cfm
0 ms 0 ms 11 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 11 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 11 /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
0 ms 0 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
223 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 @ 15:25:57.057
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 15:25:57.057
      	  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 @ 15:25:57.057
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 15:25:57.057
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 21 
getcities (Datasource=expert, Time=0ms, Records=2) in /home/www/html/navmeta_rdesign4.cfm @ 15:25:57.057
	Select *
	From citynetworks
	Where networkID = 21
	and status <> 'hold'
	ORDER by city
getcity (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 15:25:57.057
	Select *
	From citynetworks
	Where citynetworkid = 4087 
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 15:25:57.057
  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=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 15:25:57.057
	Select *
	From Networks
	Where networkID = 21 
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 15:25:57.057
	Select *
	From countryphotos
	Where networkID = 21
	and citynetworkid = 4087 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 15:25:57.057
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
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 @ 15:25:57.057
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
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=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 15:25:57.057
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
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 @ 15:25:57.057
	SELECT *
	From contentcountcountry
	Where networkid = 21 
gettopbanner (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 15:25:57.057
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-11"
    and fromDate < "2020-07-12"
    and bannerPlacement.networkid = '21'
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 15:25:57.057
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:25:57.057
	Select *
	From citynetworks 
	Where citynetworkid = 4087 
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement, articlecityplace 
 	Where hitopic <> ''
 	and articlePlacement.networkID = 21 
 	and articlecityplace.citynetworkid = 4087
    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=4ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%Hamilton%') OR (author LIKE '%Hamilton%') OR (hitopic LIKE '%Hamilton%') OR (hidescript LIKE '%Hamilton%')))
	and articlePlacement.networkID = 21 
	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 @ 15:25:57.057
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Bermuda' 

and qid = 46
checkretirefeature (Datasource=expert, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 21 
         and citynetworkid = 4087 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 21 
         and citynetworkid = 4087 
         and city <> ''
         
   	 order by date DESC
   	
checkparenting (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 21 
         and citynetworkid = 4087 
         and city <> ''
         
   	 order by date DESC
   	
checkdreamfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 21 
         and citynetworkid = 4087 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 21 
         and citynetworkid = 4087 
         and city <> ''
         
   	 order by date DESC
   	
checkculturefeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 21 
         and citynetworkid = 4087 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 21 
         and citynetworkid = 4087 
         and city <> ''
         
   	 order by date DESC
   	
checkmovingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 21 
         and citynetworkid = 4087 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 21 
         and citynetworkid = 4087 
   	 order by date DESC
   	
checklivingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 21 
         and citynetworkid = 4087 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=5) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 21 
         and citynetworkid = 4087 
   	 order by date DESC
   	
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 21 
         and citynetworkid = 4087 
   	 order by date DESC
   	
checkwork (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 21 
         and citynetworkid = 4087 
   	 order by date DESC
   	
checkschool (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 21 
         and citynetworkid = 4087 
   	 order by date DESC
   	
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74105 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 11538 
getrealestateadvice (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 21
and allreports.networkid = 21
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 @ 15:25:57.057
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 21
and allreports.networkid = 21
 and allreports.citynetworkid2 =  4087
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 21
and allreports.networkid = 21
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 @ 15:25:57.057
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 21
and allreports.networkid = 21
 and allreports.citynetworkid2 =  4087
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/expatguide.cfm @ 15:25:57.057
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 21
and allreports.networkid = 21
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/expatguide.cfm @ 15:25:57.057
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 21
and allreports.networkid = 21
 and allreports.citynetworkid2 =  4087
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:25:57.057
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 7 
getanswerstext (Datasource=tipripper, Time=4ms, Records=3) in /home/www/html/expatguide.cfm @ 15:25:57.057
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 76848
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 76848 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 15:25:57.057
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 76848
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 76848
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:25:57.057
	SELECT summary
	FROM answers
	WHERE answers.answerid = '76848'
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 15:25:57.057
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '76848'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 89386
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 89386
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 89386
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 89386
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 89386
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:25:57.057
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 76848 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:25:57.057
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '21'
getmarker (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 15:25:57.057
	SELECT *
	FROM markers
	WHERE answerid = '76848'
	and lat <> ''
	and lng <> ''
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 74105 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 11538 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 15:25:57.057
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 69753 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 15:25:57.057
	Select *
	From Networks
	Where networkID = 21 
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 15:25:57.057
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-12"
     
         and rptarticlenetworks.networkid = 21 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 15:25:57.057
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 17
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 15:25:57.057
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 21 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 15:25:57.057
SELECT  hiimg
FROM rptarticles
where rptarticleID = 17
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=4ms, Records=2) in /home/www/html/navcontentbox.cfm @ 15:25:57.057
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 21 
	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 desc
    
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 15:25:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 21 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 15:25:57.057
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 21 
          and date > '2013-04-01'
		order by date 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/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=21&citynetworkid=4087
REMOTE_ADDR=172.69.62.46
REMOTE_HOST=172.69.62.46
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=31770194
cftoken=53395678
sessionid=IBEXPATEXCHANGE.COM_31770194_53395678
urltoken=CFID=31770194&CFTOKEN=53395678
URL Parameters:
citynetworkid=4087
networkid=21
Debug Rendering Time: 9 ms