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

Expat Guide to Living in Italy

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

10 Best Places to Live in Liguria, Italy

Liguria, Italy, also known as the Italian Riviera, is a stunning coastal region spanning from Tuscany to the French border. In Liguria you will find mild temperatures and a relaxed lifestyle. If you're thinking about moving here, our list of the 10 best places to live in Liguria is based upon expat advice and recommendations.

7 Best Places to Live in Piedmont, Italy

Piedmont (in Italian: Piemonte) is an expansive region in Northern Italy that borders Switzerland and France. This is a region of great variety - you will find everything from small hilltop towns to cosmopolitan cities set against the snow-capped Alps. If you're thinking about moving to Piedmont, check out our list of the 7 best places to live in Piedmont, which is based upon advice and recommendations from expats already there.

Rome

If you're moving to Rome, our Guide to Living in Rome provides answers to the questions most often asked by newcomers. Is living in Rome expensive? Which are the best International Schools in Rome? What if my apartment is a little smaller than the size required for obtaining a Residency Card? Where do expats live in Rome? The list goes on.

Puglia, Italy

Why is Puglia described as the new Tuscany? People are drawn to Puglia's low cost of living, amazing climate, beautiful beaches hidden away in coves, and, most importantly, the wonderful Pugliese people. If Puglia is on your shortlist, this overview of life in Puglia, Italy is an essential read.

Expat Health Insurance and Healthcare

Expat Health Insurance and Healthcare in

An expat in Italy discusses health care, pharmacies and health insurance costs. She explains that the cost of health insurance is nominal compared to the US and prescription medicine is very inexpensive.

Moving to Passignano sul Trasimeno, Italy

Imagine traveling in Italy, seeing a poster for an concert on a lake, attending the concert and finding a beautiful town, like Passignano sul Trasimeno. Dreams do come true!

Moving to Florence, Italy

An expat shares tips for moving to Florence. She wishes she hadn't brought so many heavy suitcases, because clothing and shoes are less expensive there. The cost of living in Florence is much higher than her home town.

Culture Shock in Perugia, Italy

An expat talks about living in Perugia, Italy where locals aren't glued to their cell phones and family values are important. He also talks about the challenges of learning the language, obtaining a drivers license and more.

Culture Shock in Florence, Italy

An experienced expat provides amazing insight into life in Florence, and how unpredictable the settling in process can be - even for someone who has lived all over the world! From the beautiful countryside to struggling with the health care system, read about the experience of moving to Florence, Italy.

Living in Minturno, Italy

An expat who retired in Minturno, Italy says the people there are the most welcoming, friendly and accepting group she has ever met. She appreciates the low cost of living, beautiful weather, history and culture of Minturno.

Living in Bologna, Italy

Many people come to study in Bologna, Italy and end up staying and living in Bologna. People in Bologna are typically well educated and career oriented. They are generally accepting of people from other cultures and religions, but may not interact with them.

Retirement in Minturno, Italy

An expat who retired in Minturno, Italy talks about health insurance, cost of living in Italy, residence permits and much more.

More Living in Italy Reports

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

More Moving to Italy Reports

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

Dream vs. Reality of Living in Italy Reports

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Italy. If you are already living in Italy, share how those "dreams" have been fulfilled, and how they have not. Below are some of the reports from expats in Italy:
Submit a Dream vs. Reality Report

Retiring in Italy Reports

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 Italy, by filling out our Overseas Retirement report. Below are some of the reports from expats in Italy:
Submit a Retire Abroad Report

Having a Baby in Italy Reports

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

Working in Italy Reports

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

Puglia or Apulia is sometimes referred to as the new Tuscany. With its low cost of living, friendly Pugliese people, beautiful beaches and villages of whitewashed homes, Puglia is a hidden gem among expats. If you're thinking about moving to Puglia, our list of the 10 best places to live in Puglia is based upon expat advice and recommendations.

Healthcare in Italy

An overview of the healthcare system in Italy - public and private hospitals, Servizio Sanitario Nazionale (SSN), getting your Tessera Sanitaria (healthcare card), vaccinations for Italy, prescription medication availability and more.

5 Expat Moms Talk about Having a Baby in Italy

5 expat moms offer candid insight into what it's like giving birth in Italy - from bringing towels and toilet paper with you to the hospital to being refused pain medication. And, like most advice in Italy, word of mouth is the best way to find a good OB/GYN.

Expat Banking: Tips for Expats in Italy

All expats in Italy face managing their finances while living there, and that always starts with finding a bank. Here are some tips from expats already living in Italy based on their actual experiences with banks there.

Top 6 Cities in Italy for Expat Jobs

Finding an expat job in Italy can be challenging. Here are 6 cities in Italy where expats have been able to find a job and live their expat dream.

Expats in Italy: 5 Movies to Get You Excited About Living in Italy

Life in Italy for expats is glamorized in the movies, and there's nothing at all wrong with that. Here are 5 movies set in Italy that will help you fall in love with Italy all over again.

Expats in Italy: 8 Tips For Living in Milan

Expats in Milan live in a city that is the financial and economic hub of Italy. Find information about life in Milan, the Milanese people, whether or not you need to speak Italian and more.

Moving to Italy: 7 Things to Know Before You Move to Italy

Expats moving to Italy envision a romantic lifestyle in one of the most beautiful countries in the world. However, it is important to make sure that you do comprehensive research and fully understand what it will mean to move to the city, town or village you choose.

Expats in Italy: Pros and Cons of Living in Italy

Expats in Italy discuss the pros and cons of living in Italy. From bureaucracy to expensive cities, Italy can be a challenge. Most expats find that the amazing food, charming countryside, beautiful beaches and public healthcare make up for the cons.

Buying Property in Italy

Avvocato Carlo Bottino offers an overview of the Italian property buying process and related legal considerations. Expats interested in buying property in Italy should understand the steps - and hire an Italian lawyer!

Retiring in Italy: 7 Important Tips for Retirees in Italy

Expats in Italy share 7 important tips for those preparing to retire in Italy - topics include healthcare and health insurance, the elective residency visa, taxes on pensions, inheritance and more.

9 Healthcare & Health Insurance Tips for Expats in Italy

Expats in Italy share tips and advice about healthcare and health insurance in Italy. Advice about finding an English-speaking doctor, using The Sistema Sanitario Nazionale (SSN) and more.

7 Tips for Obtaining Residency in Italy

Expats share their experiences obtaining residency in Italy. They discuss the ins and outs of the applying for the permesso di soggiorno, recent travel issues, permanent residency in Italy and more.

Expats Italy: 5 Tips for Living in Florence, Italy

A beloved tourist destination known for its art and architecture, expats in Florence have mixed reviews of living in Florence.

8 Tips for Living in Turin, Italy

Expats in Turin, Italy share advice for people moving to Turin. From the reality that life in Italy is challenging, to the fact that most apartments come without kitchens and should be negotiated for as part of your rent, expats constantly stress that you should be prepared what awaits you in this city in Northern Italy.

Retiring in Italy: The 7 Best Places to Retire in Italy

Italy's villages and cities appeal to retirees for many different reasons - the beautiful beaches, breathtaking countryside, amazing food, wonderful nightlife, bustling town markets and welcoming people. In this article, we cover several of our readers' favorite places.

The Italian Inheritance Process

Talking about inheritance is not an easy task due to the very nature and complication of the Italian Law. Giandomenico De Tullio of De Tullio Law Firm discusses Italian inheritance.

5 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!

10 Tips for Living in Italy

Italy is a dream destination for many, but some expats have difficulty adjusting to the rustic Italian lifestyle. Expats share their top tips for living in Italy.

Living in Italy: Challenges and Culture Shock

For many expats, settling into life in Italy is anything but a dream. Members share their experiences with culture shock and general frustration.

School Review: American School of Milan

Moving to Milan? An ExpatExchange member offers a review of American School of Milan - a friendly, welcoming school. To review your child's school, click here.

School Review: American School of Milan

Moving to Milan? An ExpatExchange member offers a review of American School of Milan - a friendly, welcoming school. To review your child's school, click here.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Expat-Italy10 Tips for Living in Italy

Italy is a dream destination for many, but some expats have difficulty adjusting to the rustic Italian lifestyle. Expats share their top tips for living in Italy.

Italy is a dream destination for many, but some expats have difficulty adjusting to the rustic Italian lifestyle. Expats share their top tips for living in Italy. ...

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 ...

Retiring-in-ItalyRetiring in Italy: The 7 Best Places to Retire in Italy

Italy's villages and cities appeal to retirees for many different reasons - the beautiful beaches, breathtaking countryside, amazing food, wonderful nightlife, bustling town markets and welcoming people. In this article, we cover several of our readers' favorite places.

Italy's villages and cities appeal to retirees for many different reasons - the beautiful beaches, breathtaking countryside, amazing food, wonderful nightlife, bustling town markets and welcoming peop...

Retirement-In-MinturnoAn Expat Shares What it's Like Retiring in Minturno, Italy

An expat who retired in Minturno, Italy talks about health insurance, cost of living in Italy, residence permits and much more.

An expat who retired in Minturno, Italy talks about health insurance, cost of living in Italy, residence permits and much more....

Moving-To-MinturnoAn Expat Talks about Moving to Minturno, Italy

An expat in Italy shares some thoughts about moving to Minturno, Italy, including how they gradually moved there and the costs associated with the transition. Also includes some ideas for what to bring to Italy with you, and what to leave at home.

An expat in Italy shares some thoughts about moving to Minturno, Italy, including how they gradually moved there and the costs associated with the transition. Also includes some ideas for what to b...

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


Execution Time

Total Time Avg Time Count Template
296 ms 296 ms 1 /home/www/html/expatguide.cfm
29 ms 29 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
28 ms 28 ms 1 /home/www/html/navcontentbox.cfm
28 ms 28 ms 1 /home/www/html/navrightmidcolumn_rdesign5.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 0 ms 29 /home/www/html/rewritearticle.cfm
2 ms 0 ms 63 /home/www/html/rewriteqoptionsctry.cfm
1 ms 1 ms 1 /home/www/html/constants.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 63 /home/www/html/rewritecityname.cfm
0 ms 0 ms 63 /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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
303 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 @ 16:12:47.047
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 16:12: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 @ 16:12:47.047
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 16:12:47.047
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 58 
getcities (Datasource=expert, Time=2ms, Records=15) in /home/www/html/navmeta_rdesign4.cfm @ 16:12:47.047
	Select *
	From citynetworks
	Where networkID = 58
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 16:12: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=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 16:12:47.047
	Select *
	From Networks
	Where networkID = 58 
getphoto (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 16:12:47.047
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 58
	and guidephoto = 'yes'
	and twimg <> ''
getphoto (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 16:12:47.047
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 58 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 16:12:47.047
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.57'
and logtime > "2020-04-14"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 16:12:47.047
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.57'
and logtime > "2020-07-14 00:00:00.000"
and logtime < "2020-07-14 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 @ 16:12:47.047
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.57'
and logtime > "2020-07-07"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 16:12:47.047
	SELECT *
	From contentcountcountry
	Where networkid = 58 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 16:12:47.047
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-13"
    and fromDate < "2020-07-14"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 16:12:47.047
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
gettaxgeneral (Datasource=expert, Time=6ms, Records=26) in /home/www/html/expatguide.cfm @ 16:12:47.047
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 58 
	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-07-14"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:47.047
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Italy' 

and qid = 46
checkretirefeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 58 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 58 
         and city <> ''
         
   	 order by city, date DESC
         
checkparenting (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 16:12:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 58 
         and city <> ''
         
   	 order by city, date DESC
         
checkdreamfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 16:12:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 58 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 16:12:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 58 
         and city <> ''
         
   	 order by city, date DESC
         
checkculturefeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 16:12:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 58 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=14) in /home/www/html/expatguide.cfm @ 16:12:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 58 
         and city <> ''
         
   	 order by city, date DESC
         
checkmovingfeaturereportarticle (Datasource=reports, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 16:12:47.047
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '1'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-14"
     
         and rptarticlenetworks.networkid = 58 
checkmovingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 16:12:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 58 
		order by date DESC
checkmoving (Datasource=expert, Time=6ms, Records=9) in /home/www/html/expatguide.cfm @ 16:12:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 58 
   	 order by city, date DESC
         
checklivingfeaturereportarticle (Datasource=reports, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 16:12:47.047
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '2'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-14"
      
         and rptarticlenetworks.networkid = 58 
checklivingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 16:12:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 58 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=9) in /home/www/html/expatguide.cfm @ 16:12:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 58 
   	 order by city, date DESC
         
checkbaby (Datasource=expert, Time=6ms, Records=7) in /home/www/html/expatguide.cfm @ 16:12:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 58 
   	 order by city, date DESC
         
checkwork (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 58 
   	 order by city, date DESC
         
checkschool (Datasource=expert, Time=5ms, Records=11) in /home/www/html/expatguide.cfm @ 16:12:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 58 
   	 order by city, date DESC
         
getrealestateadvice (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 16:12:47.047
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 58
and allreports.networkid = 58
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 16:12:47.047
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 58
and allreports.networkid = 58
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 @ 16:12:48.048
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 58
and allreports.networkid = 58
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 @ 16:12:48.048
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 58
and allreports.networkid = 58
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=8ms, Records=2) in /home/www/html/expatguide.cfm @ 16:12:48.048
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 58
and allreports.networkid = 58
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=8ms, Records=2) in /home/www/html/expatguide.cfm @ 16:12:48.048
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 58
and allreports.networkid = 58
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 @ 16:12: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=4ms, Records=5) in /home/www/html/expatguide.cfm @ 16:12: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 = 77305
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 77305 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 77305
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 77305
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
	SELECT summary
	FROM answers
	WHERE answers.answerid = '77305'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '77305'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 16:12:48.048
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 133883
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 16:12:48.048
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 133883
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 16:12:48.048
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 133883
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 16:12:48.048
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 133883
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 16:12:48.048
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 133883
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 77305 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '58'
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 16:12:48.048
	SELECT *
	FROM markers
	WHERE answerid = '77305'
	and lat <> ''
	and lng <> ''
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 75586 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 75203 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 75731 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 73402 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 72506 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 70161 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 37327 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74252 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 16:12:48.048
	Select *
	From Networks
	Where networkID = 58 
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24942
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 48462
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=0) in /home/www/html/expatguide.cfm @ 16:12:48.048
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 43537
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 21721
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 14840
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 5223
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 4604
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 72776
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 72741
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 66134
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 16:12:48.048
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 25277
				AND answerstext.qid = 82
					
checkrptarticles (Datasource=reports, Time=6ms, Records=0) in /home/www/html/navcontentbox.cfm @ 16:12:48.048
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-14"
     
         and rptarticlenetworks.networkid = 58 
    ORDER by rptarticles.rptarticleID asc   
    
gettaxgeneral2 (Datasource=expert, Time=7ms, Records=3) in /home/www/html/navcontentbox.cfm @ 16:12:48.048
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 58 
	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-14"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 16:12:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 58 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 16:12:48.048
		Select summary, hiimg 
		FROM answers
         where answerid = 74252
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 16:12:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 58 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 16:12:48.048
		Select summary, hiimg 
		FROM answers
         where answerid = 72507
         and summary <> ''


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/expatguide.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.expatexchange.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/home/www/html/expatguide.cfm
QUERY_STRING=networkID=58
REMOTE_ADDR=172.69.63.57
REMOTE_HOST=172.69.63.57
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=31894142
cftoken=55430197
sessionid=IBEXPATEXCHANGE.COM_31894142_55430197
urltoken=CFID=31894142&CFTOKEN=55430197
URL Parameters:
networkID=58
Debug Rendering Time: 14 ms