Home Canada Forum Canada Guide Moving to Canada Real Estate Healthcare in Canada
Canada
Resources
City Guides
JoinSign In
Cigna International Health Insurance

Expat Guide to Living in Canada

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

Top 10 Tech Cities For Expats in North America and Europe

Expats looking for tech jobs often are willing to move any where in the world for the right position. Here are some of the hottest tech cities in Europe and North America for expats to consider.

5 Tips For Expat Tech Jobs in Canada

Canada's technology sector has expats all over the world looking there for career opportunities that are available to those who meet the proper criteria. The Canadian government has created a program to help expats make it happen, and thousands are every year.

The Ultimate Guide To Shipping A Car To Canada

Everything you need to know about shipping a vehicle to Canada - whether it's a car, jeep, motorcycle, truck, or SUV. Though the process isn't entirely different for other types of vehicles, there are some details that are particular to each.

10 Tips for Living in Canada

Expats from all over Canada have shared great tips about living in Canada - Montreal, Vancouver, Calgary and Beyond. Find out what makes it easy, what makes it hard, cost of living and more!

12 Tips for Living in Quebec City, Canada

12 Tips for Living in Quebec City, Canada

An overview of Quebec City - from English-speaking schools, meeting other expats, public healthcare, cost of living in Quebec City and much more.

Vieux-Port Steakhouse

Vieux-Port Steakhouse

High end steakhouse in Old Montreal. Great wine list, very dimly lit, nice ambience. Lunch, dinner and Sunday brunch. Live music, outdoor terrasse surrounded by ivy-covered walls make for a wonderful dining experience during warm-weather months. Good for business dinners.

Expat Health Insurance and Healthcare

Expat Health Insurance and Healthcare in Halifax

An expat in Halifax, Canada explains that expats must be permanent residence before they are eligible for health card. If you are paying out of pocket, the fees are extremely high. She also discusses prescriptions, health care for retired expats, the quality of local healthcare and more.

Culture Shock in Halifax, Nova Scotia, Canada

An expat in Halifax, Nova Scotia enjoys that locals plan small gatherings where you can really get to know people. She talks about the high tax rate, inability to save money while living in Halifax and more.

Culture Shock in Toronto, Canada

A Chinese woman offers her take on making the transition from living in China to settling in to life in Toronto, Canada. See what she has to say cultural differences, what it takes to succeed and more.

More Culture Shock Reports for Canada

Culture shock is part of the settling in process. Knowing the different phases of culture shock and how other expats in Canada handle it can be very comforting. Below are some of the responses from expats in Canada:
Submit a Culture Shock Report

More Living in Canada Reports

What are people's priorities in Canada - work? family? 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 Canada:
Submit a Living Overseas Report

More Moving to Canada Reports

What should you take with you when you move to Canada? What should you leave behind? What type of housing and neighborhoods are typical for expats in Canada? Below are some of the responses from expats in Canada:
Submit a Moving Overseas Report

Reviews of Schools in Canada

Reviews and school profiles from expat parents and even a few school administrators in Canada. Great place to find insight into school facilities, teachers and curriculum. Below are some of the reviews from expats in Canada:
Submit an International School Review

Dream vs. Reality Report

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Canada. If you are already living in Canada, 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 Canada by taking our Overseas Retirement report.

Submit a Retire Abroad Report

Having a Baby in Canada Reports

How did expats choose their doctors, midwives, hospitals? What is childbirth like in Canada? Below are some of the reports from expats in Canada:
Submit a Having a Baby Abroad Report

Working in Canada Reports

What's it like to find a job in Canada? How difficult was it to obtain a work permit? What types are jobs are typical for expats in Canada? Below are some of the reports from expats in Canada:
Submit a Working Abroad Report
Additional Articles
10 Best Places in the World to Get in the Christmas Spirit

Christmas is a wonderful time of year. Here are 10 of the best places in the world to get in the Christmas spirit.

Bienvenue au Canada - Settling in tips for this French speaking nation

It can be easy to feel lost in such as a colossal country, but sticking to a few top tips from David Hollins, Regional General Manager at Crown Relocations, can make settling in to the Canadian lifestyle much easier.

Canada's big fat Greek immigration

In light of the Greek financial crisis, many Greeks are considering moving to Canada.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Expat-Life10 Best Places in the World to Get in the Christmas Spirit

Christmas is a wonderful time of year. Here are 10 of the best places in the world to get in the Christmas spirit.

Christmas is a wonderful time of year. Here are 10 of the best places in the world to get in the Christmas spirit. ...

Expats-in-Canada10 Tips for Living in Canada

Expats from all over Canada have shared great tips about living in Canada - Montreal, Vancouver, Calgary and Beyond. Find out what makes it easy, what makes it hard, cost of living and more!

Expats from all over Canada have shared great tips about living in Canada - Montreal, Vancouver, Calgary and Beyond. Find out what makes it easy, what makes it hard, cost of living and more!...

Tech-Expats-in-Canada5 Tips For Expat Tech Jobs in Canada

Canada's technology sector has expats all over the world looking there for career opportunities that are available to those who meet the proper criteria. The Canadian government has created a program to help expats make it happen, and thousands are every year.

Canada's technology sector has expats all over the world looking there for career opportunities that are available to those who meet the proper criteria. The Canadian government has created a program...

Canada 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 29-May-20 07:52 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.194
Host Name 162.158.78.194


Execution Time

Total Time Avg Time Count Template
359 ms 359 ms 1 /home/www/html/expatguide.cfm
23 ms 23 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
22 ms 22 ms 1 /home/www/html/navcontentbox.cfm
22 ms 22 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
13 ms 13 ms 1 /home/www/html/navtop_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/navleader_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
4 ms 4 ms 1 /home/www/html/navmeta_rdesign4.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 0 ms 3 /home/www/html/eetr/rewritetipheading.cfm
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.cfm
1 ms 1 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/eetr/rewriterealtorlink.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 10 /home/www/html/rewritearticle.cfm
0 ms 0 ms 34 /home/www/html/rewritecityname.cfm
0 ms 0 ms 34 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 34 /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
364 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm @ 19:52:32.032
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 19:52:32.032
      	  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 @ 19:52:32.032
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 19:52:32.032
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 28 
getcities (Datasource=expert, Time=1ms, Records=8) in /home/www/html/navmeta_rdesign4.cfm @ 19:52:32.032
	Select *
	From citynetworks
	Where networkID = 28
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 19:52:32.032
  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 @ 19:52:32.032
	Select *
	From Networks
	Where networkID = 28 
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 19:52:32.032
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 28
	and guidephoto = 'yes'
	and twimg <> ''
getphoto (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 19:52:32.032
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 28 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 19:52:32.032
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-02-28"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 19:52:32.032
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-05-29 00:00:00.000"
and logtime < "2020-05-29 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 @ 19:52:32.032
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-05-22"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 19:52:32.032
	SELECT *
	From contentcountcountry
	Where networkid = 28 
gettopbanner (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navleader_rdesign5.cfm @ 19:52:32.032
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-05-28"
    and fromDate < "2020-05-29"
gettopbanner (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 19:52:32.032
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-05-28"
    and fromDate < "2020-05-29"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 19:52:32.032
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
gettaxgeneral (Datasource=expert, Time=6ms, Records=7) in /home/www/html/expatguide.cfm @ 19:52:32.032
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 28 
	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 publishdate < "2020-05-29"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:32.032
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Canada' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:52:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 28 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:52:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 28 
         and city <> ''
         
   	 order by city, date DESC
         
checkparenting (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 19:52:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 28 
         and city <> ''
         
   	 order by city, date DESC
         
checkdreamfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:52:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 28 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 19:52:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 28 
         and city <> ''
         
   	 order by city, date DESC
         
checkculturefeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 19:52:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 28 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=6) in /home/www/html/expatguide.cfm @ 19:52:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 28 
         and city <> ''
         
   	 order by city, date DESC
         
checkmovingfeaturereportarticle (Datasource=reports, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 19:52:32.032
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '1'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-29"
     
         and rptarticlenetworks.networkid = 28 
checkmovingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 19:52:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 28 
		order by date DESC
checkmoving (Datasource=expert, Time=7ms, Records=7) in /home/www/html/expatguide.cfm @ 19:52:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 28 
   	 order by city, date DESC
         
checklivingfeaturereportarticle (Datasource=reports, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 19:52:32.032
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '2'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-29"
      
         and rptarticlenetworks.networkid = 28 
checklivingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 19:52:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 28 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=11) in /home/www/html/expatguide.cfm @ 19:52:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 28 
   	 order by city, date DESC
         
checkbaby (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 28 
   	 order by city, date DESC
         
checkwork (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 19:52:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 28 
   	 order by city, date DESC
         
checkschool (Datasource=expert, Time=5ms, Records=5) in /home/www/html/expatguide.cfm @ 19:52:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 28 
   	 order by city, date DESC
         
getrealestateadvice (Datasource=tipripper, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 19:52:32.032
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 28
and allreports.networkid = 28
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 19:52:32.032
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 28
and allreports.networkid = 28
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:32.032
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 = 9 
getanswerstext (Datasource=tipripper, Time=5ms, Records=12) in /home/www/html/expatguide.cfm @ 19:52:32.032
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 = 79982
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 79982 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:32.032
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 79982
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 79982
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:32.032
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79982'
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:32.032
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79982'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:32.032
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:32.032
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:32.032
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:32.032
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:32.032
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:32.032
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 = 11 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:32.032
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 79982 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:32.032
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '28'
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 19:52:32.032
	SELECT *
	FROM markers
	WHERE answerid = '79982'
	and lat <> ''
	and lng <> ''
checkstatus (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 19:52:32.032
SELECT *
FROM expertusers
WHERE userid = 1
and startdate <{ts '2020-05-28 19:52:32'}
and enddate > {ts '2020-05-29 19:52:32'} 
getrestaurants (Datasource=tipripper, Time=10ms, Records=3) in /home/www/html/expatguide.cfm @ 19:52:33.033
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 28
and allreports.networkid = 28
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=11ms, Records=3) in /home/www/html/expatguide.cfm @ 19:52:33.033
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 28
and allreports.networkid = 28
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
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 = 15 
getanswerstext (Datasource=tipripper, Time=5ms, Records=5) in /home/www/html/expatguide.cfm @ 19:52:33.033
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 = 80293
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 80293 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 80293
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 80293
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
	SELECT summary
	FROM answers
	WHERE answers.answerid = '80293'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80293'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 80293 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '28'
getmarker (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
	SELECT *
	FROM markers
	WHERE answerid = '80293'
	and lat <> ''
	and lng <> ''
gethealthcare (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 28
and allreports.networkid = 28
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 @ 19:52:33.033
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 28
and allreports.networkid = 28
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
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=4) in /home/www/html/expatguide.cfm @ 19:52:33.033
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 = 65958
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 65958 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 65958
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 65958
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
	SELECT summary
	FROM answers
	WHERE answers.answerid = '65958'
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65958'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 19:52:33.033
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 67659
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 19:52:33.033
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 67659
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 19:52:33.033
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 67659
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 19:52:33.033
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 67659
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 19:52:33.033
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 67659
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 65958 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '28'
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 19:52:33.033
	SELECT *
	FROM markers
	WHERE answerid = '65958'
	and lat <> ''
	and lng <> ''
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 25914 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 25676 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 73841 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 70728 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 25915 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 25734 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 19:52:33.033
	Select *
	From Networks
	Where networkID = 28 
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 28546
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 3081
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 26564
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 3923
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 19:52:33.033
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 424
				AND answerstext.qid = 82
					
checkrptarticles (Datasource=reports, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 19:52:33.033
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-29"
     
         and rptarticlenetworks.networkid = 28 
    ORDER by rptarticles.rptarticleID asc   
    
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=3) in /home/www/html/navcontentbox.cfm @ 19:52:33.033
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 28 
	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-05-29"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 19:52:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 28 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 19:52:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 28 
          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=28
REMOTE_ADDR=162.158.78.194
REMOTE_HOST=162.158.78.194
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=28659219
cftoken=19643857
sessionid=IBEXPATEXCHANGE.COM_28659219_19643857
urltoken=CFID=28659219&CFTOKEN=19643857
URL Parameters:
networkID=28
Debug Rendering Time: 11 ms