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

Expat Guide to Living in Epinal

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

12 Tips for Living in Epinal, France, France

12 Tips for Living in Epinal, France, France

An expat talks about life in Epinal, France, a historic city in northeastern France on the Moselle River. Epinal isn't an expat enclave, but has a lot to offer - low cost of living and lots of clubs and cultural activities. Have a pint at Epinal's Irish Pub and you'll get a feel for the local scene.

Culture Shock in Epinal, France

An expat in Epinal, France gets candid about the culture shock she experience when moving to France. She advises newcomers to get out and meet people. She started an English-speaking group in her small town and met lots of locals that way.

Living in Epinal, France

An expat shares what it's like to live in the small town of Epinal, France.

More Culture Shock Reports for Epinal

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

More Living in Epinal Reports

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

Moving Overseas Report

What should you take with you when you move to Epinal? What should you leave behind? What type of housing and neighborhoods are typical for expats in Epinal? Help others moving to Epinal 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 Epinal with the school selection process. If you have expat children who attend school in Epinal, take a few minutes to submit a School Review.

Submit an International School Review

Dream vs. Reality Report

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

Submit a Having a Baby Abroad Report

Working Abroad Report

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

Submit a Working Abroad Report
Cigna Expat Health InsuranceExpatriate Health Insurance

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

12-Expats-Talks-About-What-Its-Like-Moving-to-France12 Expats Talks About What It's Like Moving to France

Expats in France discuss the challenges and adventures of moving to France. From the high cost of living in France to what to bring when you move (and what to leave behind).
Expats in France discuss the challenges and adventures of moving to France. From the high cost of living in France to what to bring when you move (and what to leave behind). ...

EducationFinding the Right International School in France

Choosing an international school in France can be a difficult decision. This article provides an overview of some popular international schools in Paris and other areas of France.

Choosing an international school in France can be a difficult decision. This article provides an overview of some popular international schools in Paris and other areas of France....

Expat-France10 Tips for Living in France

Expats offer tips on health insurance, renting in Paris, culture shock, meeting people and more.

Expats offer tips on health insurance, renting in Paris, culture shock, meeting people and more....

Retiring-Abroad5 Great Places to Retire in Western Europe

We asked expats about great places to retire in Western Europe. While many Western European countries have prohibitively high living costs, there are a few areas that fit the retirement bill. These are some of the recommendations!

We asked expats about great places to retire in Western Europe. While many Western European countries have prohibitively high living costs, there are a few areas that fit the retirement bill. These ...

Retirement-In-Aude-and-Herault-DepartmentsAn Expat Shares What it's Like Retiring in Aude and Herault Departments, France

A couple from the UK who retired in France enjoy the cultural activities of nearby Carcassonne and Narbonne, being close to the coast and the beautiful vineyards that surround them. They confess to be having a tougher learning French than if they were younger, but know they will persevere.

A couple from the UK who retired in France enjoy the cultural activities of nearby Carcassonne and Narbonne, being close to the coast and the beautiful vineyards that surround them. They confess to...

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


Execution Time

Total Time Avg Time Count Template
276 ms 276 ms 1 /home/www/html/expatguide.cfm
13 ms 13 ms 1 /home/www/html/navtop_rdesign5.cfm
8 ms 8 ms 1 /home/www/html/Application.cfm
5 ms 5 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/navcontentbox.cfm
4 ms 4 ms 1 /home/www/html/navleader_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/navmeta_rdesign4.cfm
4 ms 4 ms 1 /home/www/html/navrightmidcolumn_rdesign5.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/constants.cfm
0 ms 0 ms 1 /home/www/html/eetr/rewriterealtorlink.cfm
0 ms 0 ms 2 /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 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 5 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 5 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 5 /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
285 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 @ 20:02:47.047
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=6ms, Records=1) in /home/www/html/Application.cfm @ 20:02:47.047
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=expert, Time=1ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 20:02:47.047
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 20:02:47.047
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 45 
getcities (Datasource=expert, Time=0ms, Records=13, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 20:02:47.047
	Select *
	From citynetworks
	Where networkID = 45
	and status <> 'hold'
	ORDER by city
getcity (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 20:02:47.047
	Select *
	From citynetworks
	Where citynetworkid = 7245 
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 20:02:47.047
  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 @ 20:02:47.047
	Select *
	From Networks
	Where networkID = 45 
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 20:02:47.047
	Select *
	From countryphotos
	Where networkID = 45
	and citynetworkid = 7245 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 20:02:47.047
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.179'
and logtime > "2020-04-05"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 20:02:47.047
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.179'
and logtime > "2020-07-05 00:00:00.000"
and logtime < "2020-07-05 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 @ 20:02:47.047
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.179'
and logtime > "2020-06-28"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 20:02:47.047
	SELECT *
	From contentcountcountry
	Where networkid = 45 
gettopbanner (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 20:02:47.047
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-04"
    and fromDate < "2020-07-05"
    and bannerPlacement.networkid = 45
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=3ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 20:02:47.047
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:47.047
	Select *
	From citynetworks 
	Where citynetworkid = 7245 
gettaxgeneral (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement, articlecityplace 
 	Where hitopic <> ''
 	and articlePlacement.networkID = 45 
 	and articlecityplace.citynetworkid = 7245
    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-05"
    ORDER by articles.articleID desc
gettaxgeneral (Datasource=expert, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%Epinal%') OR (author LIKE '%Epinal%') OR (hitopic LIKE '%Epinal%') OR (hidescript LIKE '%Epinal%')))
	and articlePlacement.networkID = 45 
	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-05"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:47.047
SELECT qoid, value 
FROM qoptions 

WHERE value = 'France' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 45 
         and citynetworkid = 7245 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 45 
         and citynetworkid = 7245 
         and city <> ''
         
   	 order by date DESC
   	
checkparenting (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 45 
         and citynetworkid = 7245 
         and city <> ''
         
   	 order by date DESC
   	
checkdreamfeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 45 
         and citynetworkid = 7245 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 45 
         and citynetworkid = 7245 
         and city <> ''
         
   	 order by date DESC
   	
checkculturefeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 45 
         and citynetworkid = 7245 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 45 
         and citynetworkid = 7245 
         and city <> ''
         
   	 order by date DESC
   	
checkmovingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 45 
         and citynetworkid = 7245 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 45 
         and citynetworkid = 7245 
   	 order by date DESC
   	
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 45 
         and citynetworkid = 7245 
		order by date DESC
checkliving (Datasource=expert, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 45 
         and citynetworkid = 7245 
   	 order by date DESC
   	
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 45 
         and citynetworkid = 7245 
   	 order by date DESC
   	
checkwork (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 45 
         and citynetworkid = 7245 
   	 order by date DESC
   	
checkschool (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 45 
         and citynetworkid = 7245 
   	 order by date DESC
   	
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:47.047
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74436 
getrealestateadvice (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:47.047
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 45
and allreports.networkid = 45
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=7ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:47.047
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 45
and allreports.networkid = 45
 and allreports.citynetworkid2 =  7245
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 @ 20:02:47.047
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=7ms, Records=11) in /home/www/html/expatguide.cfm @ 20:02:47.047
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 = 79416
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 79416 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=7ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:47.047
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 79416
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 79416
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:47.047
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79416'
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:47.047
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79416'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=11ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 185143
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 185143
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 185143
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 185143
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 185143
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:47.047
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 @ 20:02:47.047
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 79416 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:47.047
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '45'
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
	SELECT *
	FROM markers
	WHERE answerid = '79416'
	and lat <> ''
	and lng <> ''
checkstatus (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 20:02:47.047
SELECT *
FROM expertusers
WHERE userid = 185143
and startdate <{ts '2020-07-04 20:02:47'}
and enddate > {ts '2020-07-05 20:02:47'} 
getrestaurants (Datasource=tipripper, Time=12ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 45
and allreports.networkid = 45
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:47.047
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 45
and allreports.networkid = 45
 and allreports.citynetworkid2 =  7245
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=14ms, Records=3) in /home/www/html/expatguide.cfm @ 20:02:47.047
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 45
and allreports.networkid = 45
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=11ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:48.048
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 45
and allreports.networkid = 45
 and allreports.citynetworkid2 =  7245
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 @ 20:02:48.048
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=6ms, Records=5) in /home/www/html/expatguide.cfm @ 20:02:48.048
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 = 79250
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 79250 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:48.048
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 79250
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 79250
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:48.048
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79250'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:48.048
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79250'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:48.048
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 185143
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:48.048
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 185143
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:48.048
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 185143
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:48.048
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 185143
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:48.048
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 185143
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:48.048
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 79250 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:48.048
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '45'
getmarker (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 20:02:48.048
	SELECT *
	FROM markers
	WHERE answerid = '79250'
	and lat <> ''
	and lng <> ''
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:48.048
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74436 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 20:02:48.048
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 74132 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 20:02:48.048
	Select *
	From Networks
	Where networkID = 45 
checkrptarticles (Datasource=reports, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentbox.cfm @ 20:02:48.048
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-05"
     
         and rptarticlenetworks.networkid = 45 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=1, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 20:02:48.048
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 3
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 20:02:48.048
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 45 
getrptarticlephotos (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 20:02:48.048
SELECT  hiimg
FROM rptarticles
where rptarticleID = 3
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navcontentbox.cfm @ 20:02:48.048
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 45 
	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-05"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentbox.cfm @ 20:02:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 45 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 20:02:48.048
		Select summary, hiimg 
		FROM answers
         where answerid = 65345
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navcontentbox.cfm @ 20:02:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 45 
          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=45&citynetworkid=7245
REMOTE_ADDR=173.245.54.179
REMOTE_HOST=173.245.54.179
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=31115572
cftoken=85410722
sessionid=IBEXPATEXCHANGE.COM_31115572_85410722
urltoken=CFID=31115572&CFTOKEN=85410722
URL Parameters:
citynetworkid=7245
networkid=45
Debug Rendering Time: 10 ms