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

Moving to Netherlands > 7 Things to Know Before Moving to The Netherlands

7 Things to Know Before Moving to The Netherlands

By Betsy Burlingame

Apr 19, 2018

Summary: Expats who moved to the Netherlands talk about deciding whether to live in urban or suburban neighborhoods, adjusting to Dutch culture, finding an apartment and more.

The Netherlands - 7 Things to Know Before Moving to The Netherlands

Expats living in The Netherlands talks about how to find an apartment in Amsterdam's tight rental market, acclimating to the sometimes cold Dutch culture and trying to learn Dutch when locals are fluent in English.

Advice for Newcomers to Netherlands

"Finding an apartment is the difficult part of moving to the Netherlands. Amsterdam is probably the most difficult place to search. People are on waiting lists for years to get even a small place. The more you are willing to spend, the faster you will find a place. Knowing people helps you find a goods place both in terms of getting advice on neighborhoods and in terms of hearing of vacant places. The best places never even get advertised--a friend will offer his place to another friend first," said one expat who moved to Rotterdam.

"Hire a bicycle (at the train station or a bike shop) and look around - you can walk cycle thorough most of the town in an afternoon. Join a club to meet people. Take the initiative to meet neighbors. They may seem reserved at first, but all will appreciate the effort, and most will respond in time," mentioned another expat when asked about moving to Netherlands.

"Think long and hard about how you would live your life, what kind of life you really want. I chose to transition from working outside the home (US) to working at home (writer), so we wanted an urban, Dutch lifestyle. I actually enjoy wandering up to the shopping street to buy my daily groceries and run errands in the late afternoon. We use public transportation for everything except my picking up the kids from school (20 min. away) 3 days a week when they're in the middle of sports and activities (as they're in high school and have tons of homework). My husband walks to/from work, and we're able to eat meals as a family. My friends who live in the 'expat enclave' near the school 1) have no Dutch friends, 2) don't really speak any Dutch and 3) their husbands are 'ghosts' in their families - never around due to long commutes," said another expat.

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

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

Culture Shock in Netherlands

We asked expats about the culture shock they experienced when they moved to Netherlands. They replied:

"I thought I was settling in but suddenly I realized by 'settling in' I had become a recluse. I was afraid to leave the house because I didn't want to be laughed at for saying the wrong thing or something (not that anyone ever really laughed at me). I was really depressed and anxious and the more depressed/anxious I got the less I wanted to venture out, so it became a downward spiral. Finally I went home for a couple weeks and came back and decided to dive right into some social activities. I joined some clubs at Universiteit Twente, used websites such as this to find other expats, and gradually started returning to my normal self," said one expat who moved to Hengelo, Netherlands.

"I'd worked in the international arena for much of my life, so it wasn't too bad. I'd say I had a 'mild' case as did all but one of my family members. That one had a much harder time, so I was appreciative of the challenges," mentioned another expat when asked about moving to Netherlands.

"Oh, it was really hard. People seemed very cold and unfriendly. Though now I know it's not like that at all. My biggest shock was smallest amount of couples with children. No parks for kids to play, but a lot of places to go with pets. And when I could see woman strolling pushchair with dog sitting inside. Now it is funny when I remember all that facts," commented one expat who made the move to Netherlands.

"The culture shock I experienced was amplified by the terrible, dreary weather since I had come from South Florida. Also, I wasn't prepared because I didn't believe the culture could be so very different from the US. (After all, I wasn't moving to China!) We moved to the northern part of the country (Groningen) and cultural differences among the regions vary greatly in Holland. From what I heard from other expats, Amsterdam is a breeze," commented one expat who made the move to Netherlands.

"It was BIG! The street names are so long, everything looks different, people talked different, it wasnt the "dream" i thought... It took a few days to get over and really enjoy the uniqueness," said one expat who moved to Amsterdam, Netherlands.

"For me, significant. Despite the fact that Amsterdam is an english speaking city and many of my friends indicate that they did feel as much 'shock' themselves, I did, in a huge way," mentioned another expat when asked about moving to Netherlands.

"The most relevant ones were the social and mental attitude shock. As 'easy going' as they might seem, Dutch are very much for themselves and not very sociable. They are more or less direct in their approach, usually straight to the point in discussions, but cold. For a sociable 'warm blooded' person who likes to meet people and make friends (usually from Southern and Eastern Europe) the Dutch mentality of the easy approach to the coldness of their social relations is quite a 'cold shower'. Other then that, it is fine once you get to know more about their history, traditions, culture and habits. Especially when beginning to master Dutch language to a certain degree. Then social conversation gets more inter-active. Not that mastering Dutch cuts any corners in helping you making new friends with much more ease," remarked another expat in Tilburg, Netherlands.

What to Bring When Moving to Netherlands (and what to leave behind)

When we asked expats living in Netherlands what they wish they had brought when moving to Netherlands and what they wish they had left at home, they replied:

"Wish I had brought my friends, they wouldn't believe this place, also my Starbucks coffee, and The Gap," mentioned another expat when asked about moving to Netherlands.

"Brought: Golf set, Ski's and Lap Top. Left: Sun Glasses, Swimming Trousers, Tanning lotion :)," said one expat who moved to Amsterdam, Netherlands.

"We downsized and generally packed well, but I'd say we should have brought more jeans, running shoes, voetbal cleats. (Items are much more expensive here and there is less selection.) Left at home? More of the 'stuff' that may fit in American closets (but you really don't use). I continue to weed out clothes that are too big/small/never worn. We find that we like to update our photos/paintings and artwork based on our travels, so we need to downsize some of that. (Tom Frost at Expat Alley wrote a great post about living with less because you outgrow your stuff and have new experiences.) I thought I was being ruthless but I need to be more so as closet/storage space (especially the hanging kind) is at a premium," commented one expat who made the move to Netherlands.

Moving to Netherlands

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

Learning the Language

We asked expats in they learned the language before they moved, once abroad or are still planning to learn the language. They explained:

"Dutch is the native language here of course. I can speak it now, if haltingly. It's not the easiest language to learn. I took courses paid for through my employer after I arrived here and months after my employment started. I want to be much better at it and plan more training even if it's not covered by work," said one expat who moved to Amsterdam, Netherlands.

"Right after I first met my husband, I started learning some Dutch words here are there just for fun. There was a desperate scramble to learn all those polite phrases one needs to know as a dinner guest the first time I met his parents. But I didn't really start studying Dutch seriously until I had been here for a little over a month. I started classes at that point and a year later I'm still formally studying Dutch. My husband and I speak Dutch to each other three days a week and I joined an all-women Dutch singing group towards the end of my first year here. I think it's of utmost importance to learn the language of the country you're going to and/or living in, no matter how long you plan to be there," mentioned another expat when asked about moving to Netherlands.

"I now speak basic Nederlands. Before moving I did a class in introductory Dutch - after moving I realised how poor the class was. I spent 6 months doing part time classes - after the first term I was able to make very basic conversation. By the time I finished the classes I was able to understand Dutch quite well and can read the newspaper and also did not rely on the BBC TV channel only. I am now able to watch Dutch TV and can even understand the Dutch subtitles in English TV. I have a Job in a company where the official "taal"is English - but I thoroughly recommend that you learn Dutch so that you are able to understand your work associates," commented one expat who made the move to Netherlands.

"I'm trying to learn, but it's very difficult. Every time I try to speak Dutch with the natives, they say something really fast and I say 'Pardon?' and somehow they pick up on my accent and say 'Ohhh you speak English!' and then they just continue on in fluent English. I'm never going to learn the language if I never hear it," remarked another expat in Hengelo, Netherlands.

Finding a Job in Netherlands

If you're searching for a job in Netherlands, expats talk about popular industries and how expats find employment.

"Rotterdam is more of a working class city than Amsterdam. The difference between the cities are very much like Glasgow and Edinburgh, for anyone familiar with Scotland. Rotterdam has one of the largest harbours in the world and therefore has much shipping-related business. Unilever is also located in Rotterdam," said one expat who moved to Rotterdam, Netherlands.

"Utrecht is mostly a city of University and education. There are several hospitals (Medical Centers) in the area. Holland is not such a big country and therefore many people reside in the Utrecht province ,but commute to Amsterdam for work. The IT businesses employ many people here. If you have not re-located here through an existing job, then the best place to find work here (after you get the required work documents)is to go to an "Uitzendbureau"( a hiring firm) to be placed in a job (most of these are temp firms, but it's possible to get on permanently in a job here). There are many "Uitzenbureaus" in Holland," mentioned another expat when asked about moving to Netherlands.

"Meerssen is a small town located to the north of Maastricth, a much larger city. It is home to a paper mill however, which employs about 200 locals. The town itself is home to many small shops, a large basilica and a variety of schools," commented one expat who made the move to Netherlands.

"There is a university in the city, so there is a large student base. There are several internationally oriented companies, such as Akzo Nobel. Find a new job by going to city hall and subscribing to the CWI (Centrum voor Werk en Inkomst). Other options include search engines on the web (www.intermediair.nl). The provincial newspaper is the Gelderlander," remarked another expat in Nijmegen, Netherlands.

Typical Housing for Expats

When we asked expats in Netherlands about the type of home or apartment they life in and whether that is typical for expats, they replied:

"I live in a small flat. I have a large bedroom, a small open kitchen/living room, and a shower/toilet with no sink--so I have to use the kitchen sink. I consider this very below standards in the U.S. I did have to buy my own oven, refrigerator, and washing machine. Likewise, I had to carpet the place. To leave the floors bare was not an option--it was not a nice wood floor but more like construction material. This is pretty normal here, however, so getting the household items is easy and not too expensive," said one expat who moved to Rotterdam, Netherlands.

"I live in a lovely canal house in Amsterdam. Most of my colleagues live in Amsterdam Oud Zuid thought. I prefer to be living in the centre since I have no car any way," mentioned another expat when asked about moving to Netherlands.

"We live in a 3 story terraced house in quiet neighbourhood. This seems to be quite typical for the expats I know," commented one expat who made the move to Netherlands.

"We rent a 'rijtjeshuie' which is basically a 3-story brick 'town house' on a quiet street in a relatively upscale neighborhood, near a popular shopping street that is a great mix of everyday requirements (good grocery store, hardware stores, drug stores, great specialty stores and also fun boutiques and upscale stuff to window shop). It's fairly typical in this part of Den Haag/The Hague, although probably a bit on the bigger side than some," remarked another expat in The Hague, Netherlands.

Housing Costs in Netherlands

"Housing is cheaper than in large cities in the US, but is not cheap. In my experience, however, I am happy with what I pay. My apartment is small, but I live in one of the best neighborhoods in Rotterdam and I can afford to live alone. In NY, I had to share an apartment with someone I'd just met," said one expat who moved to Rotterdam, Netherlands.

"My housing costs are much higher. I pay around 1800 each month now agains around 800 US in Austin," mentioned another expat when asked about moving to Netherlands.

"Factoring in space/square footage, probably a little less. Depends on what you came from and where you settle here. It isn't cheap," commented one expat who made the move to Netherlands.

Expat Health Insurance in Netherlands

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

About the Author

AS Betsy BurlingameBetsy Burlingame is the Founder of Expat Exchange. She launched Expat Exchange in 1997 as her Master's thesis project at NYU. Some of Betsy's more popular articles include 6 Best Places to Live in Costa Rica, 12 Things to Know Before Moving to The Dominican Republic and 7 Tips for Obtaining Residence in Italy. Betsy loves to travel and spend time with her family. Connect with Betsy on LinkedIn.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Moving-To-NetherlandsExpats Talk about What it's Like Moving to Netherlands

Already living abroad? Write a report about moving overseas to help people preparing to move abroad.

About the Author

Betsy Burlingame Betsy Burlingame is the Founder of Expat Exchange. She launched Expat Exchange in 1997 as her Master's thesis project at NYU. Some of Betsy's more popular articles include 6 Best Places to Live in Costa Rica, 12 Things to Know Before Moving to The Dominican Republic and 7 Tips for Obtaining Residence in Italy. Betsy loves to travel and spend time with her family. Connect with Betsy on LinkedIn.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Join our Netherlands Expat Forum

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

More about Netherlands

5-Tips-for-Tech-Jobs-in-Amsterdam

5 Tips for Tech Jobs in Amsterdam

Expats in the tech sector of Amsterdam benefit from its famously open society that encourages tech development - both in larger companies and start ups. Find out more about this hot European tech hub.

Expats in the tech sector of Amsterdam benefit from its famously open society that encourages tech development - both in larger companies and start ups. Find out more about this hot European tech hub...

6-Tips-for-Expats-Having-a-Baby-in-The-Netherlands

6 Tips for Expats Having a Baby in The Netherlands

Expat moms share their experiences having a baby in The Netherlands - from wonderful prenatal care to the home birth option for uncomplicated pregnancies and everything in between. While many new moms have very short hospital stays, they receive at home care from a beloved Kraamzorg (home nurse) as part of their maternity care, which expats resoundingly say makes all the difference.

Expat moms share their experiences having a baby in The Netherlands - from wonderful prenatal care to the home birth option for uncomplicated pregnancies and everything in between. While many new mom...

10-Expat-Friendly-Cities-in-The-Netherlands-and-What-Its-Like-Living-There

10 Expat-Friendly Cities in The Netherlands and What It's Like Living There

Expats in The Netherlands talk about 10 expat-friendly cities, what life is like there and how to meet people.

Expats in The Netherlands talk about 10 expat-friendly cities, what life is like there and how to meet people. ...

10-Tips-for-Living-in-the-Netherlands

10 Tips for Living in the Netherlands

Expats from all over the Netherlands share their advice on what it's like to live there and what it takes to make the move a success.

Expats from all over the Netherlands share their advice on what it's like to live there and what it takes to make the move a success....

5-Tips-for-Living-in-Amsterdam

5 Tips for Living in Amsterdam

Amsterdam is a beautiful city with historic canals, incredible museums and a thriving cafe and nightlife scene. For those expats fortunate enough to move to Amsterdam, it can be an amazing place to live. Expat Exchange members in Amsterdam share their tips for living in Amsterdam and surrounding, commutable cities such as Amstelveen, Hilversum, Utrecht, The Hague and Rotterdam.

Amsterdam is a beautiful city with historic canals, incredible museums and a thriving cafe and nightlife scene. For those expats fortunate enough to move to Amsterdam, it can be an amazing place to l...

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

First Published: Apr 19, 2018

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Moving-To-NetherlandsExpats Talk about What it's Like Moving to Netherlands

Already living abroad? Write a report about moving overseas to help people preparing to move abroad.

Netherlands 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 /lib_rd.cfm
Time Stamp 13-Jul-20 05:34 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.68.65.192
Host Name 172.68.65.192


Execution Time

Total Time Avg Time Count Template
79 ms 79 ms 1 top level /home/www/html/lib_rd.cfm
13 ms 13 ms 1 /home/www/html/commentsnew_rdesign4.cfm
13 ms 13 ms 1 /home/www/html/lib_rd_ctrygd_readnext.cfm
12 ms 12 ms 1 /home/www/html/navcontentboxmovingmobile.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
9 ms 9 ms 1 /home/www/html/navbottomad_rdesign5.cfm
7 ms 2 ms 4 /home/www/html/nativerotationtop_tester13.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
3 ms 3 ms 1 /home/www/html/navmpu_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/breadcrumb.cfm
1 ms 1 ms 1 /home/www/html/navcontentboxmovingpc.cfm
1 ms 1 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/constants.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/natad/native_5047_10951.txt
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 9 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereportscountry.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
84 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 @ 17:34:02.002
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 17:34:02.002
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 17:34:02.002
	Select *
	From articles
	Where articleID = 5047
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/lib_rd.cfm @ 17:34:02.002
	Select *
	From sponcers
	Where sponcerID = 287 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 17:34:02.002
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 5047 
	and articles.articleID = 5047 
	and articlePlacement.networkID = Networks.networkID
	and articles.hinet = 'y'
  and (articles.general = 'no' or articles.general = 'city')
    and articles.hitopic <> ''
    and articles.hidescript <> ''
	and isCity <> "hold"
	AND networktype <> 2
	AND networktype <> 3
	AND networktype <> 4
	AND networktype <> 5
	AND networkname <> 'national'
	AND networkname <> 'Global Listing'
	AND (isCity = 'Country') 
citystatus (Datasource=expert, Time=0ms, Records=0) in /home/www/html/lib_rd.cfm @ 17:34:02.002
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 5047
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 5047
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 17:34:02.002
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 17:34:02.002
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 83 
getcities (Datasource=expert, Time=0ms, Records=8) in /home/www/html/navmeta_rdesign4.cfm @ 17:34:02.002
	Select *
	From citynetworks
	Where networkID = 83
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 17:34:02.002
  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
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 17:34:02.002
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5047 
commentcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 17:34:02.002
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 5047 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid DESC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 17:34:02.002
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
and logtime > "2020-04-13"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 17:34:02.002
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
and logtime > "2020-07-13 00:00:00.000"
and logtime < "2020-07-13 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 17:34:02.002
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
and logtime > "2020-07-06"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 17:34:02.002
	SELECT *
	From contentcountcountry
	Where networkid = 83 
gettopbanner (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 17:34:02.002
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-12"
    and fromDate < "2020-07-13"
    and bannerPlacement.networkid = '83'
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 17:34:02.002
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
checkcitynetwork (Datasource=expert, Time=1ms, Records=0) in /home/www/html/breadcrumb.cfm @ 17:34:02.002
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 5047 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 17:34:02.002
SELECT tag
FROM natadoptions 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:34:02.002
SELECT *
FROM natadoptions 
WHERE 'hiheader' = tag
getnatadtype (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:34:02.002
SELECT *
FROM natadoptions 
WHERE natadtypeid = 1 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:34:02.002
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 1
and natadPlacement.networkID = 83
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-07-12"
and headerparagraphstart < "2020-07-13"
and headerparagraphstatus = 'live'

and (headerparagraphweight = 'medium' or headerparagraphweight = 'high')
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:34:02.002
SELECT *
FROM natadoptions 
WHERE 'moveheader' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:34:02.002
SELECT *
FROM natadoptions 
WHERE natadtypeid = 6 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:34:02.002
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 6
and natadPlacement.networkID = 83
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-07-12"
and headerparagraphstart < "2020-07-13"
and headerparagraphstatus = 'live'

and headerparagraphweight = 'high'
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:34:02.002
SELECT *
FROM natadoptions 
WHERE 'movesentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:34:02.002
SELECT *
FROM natadoptions 
WHERE natadtypeid = 7 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:34:02.002
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 7
and natadPlacement.networkID = 83
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-12"
and natsentencestart < "2020-07-13"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:34:02.002
SELECT resourceid, natsentence as adcode, natsentenceweight, natadid
FROM natads 
WHERE natadid = 32
and natsentencetype = 7 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:34:02.002
SELECT *
FROM natadoptions 
WHERE 'realtysentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:34:02.002
SELECT *
FROM natadoptions 
WHERE natadtypeid = 44 
getnatadbottom (Datasource=expert, Time=0ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 17:34:02.002
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 44
and natadPlacement.networkID = 83
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-12"
and natsentencestart < "2020-07-13"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 17:34:02.002
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 44
and natadPlacement.networkID = 83
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-12"
and natsentencestart < "2020-07-13"
and natsentencestatus = 'live'
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxmovingmobile.cfm @ 17:34:02.002
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 83 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
   and (articleCategories.section = '1' or articleCategories.section = '2' or articleCategories.section = '4' or articleCategories.section = '5')   
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    
    and articles.articleID <> '5047'
	
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-13"
     ORDER by articles.sectionintro DESC, articles.articleID desc 
 
checkmovingfeature (Datasource=expert, Time=6ms, Records=4) in /home/www/html/navcontentboxmovingmobile.cfm @ 17:34:02.002
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
      
         and networkid = 83 
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=0) in /home/www/html/navcontentboxmovingmobile.cfm @ 17:34:02.002
		Select summary, hiimg 
		FROM answers
         where answerid = 25989
         and summary <> ''
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 17:34:02.002
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5047 
gettaxgeneral3 (Datasource=expert, Time=6ms, Records=4) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 17:34:02.002
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 83 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and articles.articleID <> 5047
    and publishdate < "2020-07-13"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettaxgeneral4 (Datasource=expert, Time=6ms, Records=1) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 17:34:02.002
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articlecityplace
	Where hitopic <> ''
	and articlePlacement.networkID = 83 
	AND articlePlacement.articleID = articles.articleID
		and articlecityplace.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.articleID <> 5047
    and publishdate < "2020-07-13"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=2ms, Records=0) in /home/www/html/navbottomad_rdesign5.cfm @ 17:34:02.002
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-07-12"
    and fromDate < "2020-07-13"
        and banners.promised = ''
    and banners.type <> 'swf'
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 17:34:02.002
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-07-12"
    and fromDate < "2020-07-13"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=4ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 17:34:02.002
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
gethpbox (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 17:34:02.002
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eehpboxcountry"
    and toDate > {ts '2020-07-12 17:34:02'}
    and fromDate <{ts '2020-07-13 17:34:02'}
    and weight > 7
    and bannerPlacement.networkid = 83
    and bannerPlacement.bannerid = banners.bannerid
    and banners.type <> 'swf'
gethpbox (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 17:34:02.002
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
	and weight > 7
    and toDate > {ts '2020-07-12 17:34:02'}
    and fromDate <{ts '2020-07-13 17:34:02'}
     and banners.type <> 'swf'
       
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 17:34:02.002
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 17:34:02.002
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 5047 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 17:34:02.002
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5047 


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/lib_rd.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/lib_rd.cfm
QUERY_STRING=articleID=5047&networkid=83
REMOTE_ADDR=172.68.65.192
REMOTE_HOST=172.68.65.192
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/lib_rd.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=31834502
cftoken=82232774
sessionid=IBEXPATEXCHANGE.COM_31834502_82232774
urltoken=CFID=31834502&CFTOKEN=82232774
URL Parameters:
articleID=5047
networkid=83
Debug Rendering Time: 16 ms