Home Czech Rep Forum Czech Rep Guide Moving to Czech Rep Real Estate Healthcare in Czech Rep
Czech Rep
Resources
City Guides
Prague, Czech Republic
JoinSign In

Living in Czech Rep > Prague > 11 Tips for Living in Prague

11 Tips for Living in Prague

By Betsy Burlingame

Last updated on: Nov 10, 2018

Expats in Prague offer advice to newcomers about living in Prague. Topics covered include international schools, best neighborhoods for expats, clubs for expats and more.

Expats in Prague - 11 Tips for Living in Prague

Prague is the largest city in Czech Republic and home to approximately 1.3 million people (2.6 million in the metropolitan area Wikipedia). Prague was under communist rule from 1948 until 1989. In 1993, Czechoslovakia dissolved into the Czech and Slovak Republics.

Prague 6 is the Best Neighborhood for Expat Families

In a thread about moving to Prague, a newcomer asked about the best neighborhoods for expat families. One expat replied, "Prague 6 for me everytime, especially with kids, lived there for 8 year."

"I am an American expat who has been living in Prague 6 for the past 13 years. I have four children who have grown up here and attended both private and Czech schools (Czech Mother). I can say unequivocally that Prague 6 is much better than Prague 2 for family life... especially an American expat family," added another expat living in Prague.

Prague 2 is the Best Neighborhood for Young, Single Expats

"I would recommend the same, Prague 2 for younger, single people and Prague 6 for families," said one Czech woman on the forum. Another expat said, "We live in an apartment complex close to downtown Prague (Praha 2, Nove Mesto). Our apartment has a small garden, a common area, a swimming pool and fitness facilities. Other expats live in our building, but many expat friends live in houses outside of town."

Moving to Czech Rep 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 Czech Rep 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.

Schools in Prague for Expats

Riverside School

The Riverside School welcomes students of all ages and has early years school (3+), a primary school, a junior high and a senior high. "I personally love Riverside School, but I am very fond of the director there so I am probably not unbiased. My children attended there for many years. Presently the two youngest are in Czech school and one attends English College in Prague....which is probably one of the best of it kind anywhere. They must be 13 years old to start there. Riverside starts them from 3 years. If there is anything you would like to know specifically just write and I will try to help," wrote one expat parent.

prague

International School of Prague

The International School of Prague is located in Nebusice in Prague 6, about 30 minutes from central Prague. It welcomes students from early childhood through high school.

Prague British International School

Prague British International School (PBIS) welcomes students from 2 through 18 years of age. The school has 3 campuses. Vlastina is in the west of the city and serves students through Year 9. The 2 other campuses are located in the southwest of the city. One serves students through Year 9 and other serves students from Year 10 through Year 13.

Parklane International School

Parklane International School has 2 campuses. The Primary and preschool (nursery - Year 5) building is located in Prague 6. The Primary and Senior School (Year 6 - Year 13) is located in Prague 1.

English College in Prague

The English College in Prague is a unique school in that it was founded to provide an English-based education to young people in Prague, the majority students are locals not expats. Most graduates go on to attend universities in the UK.

Crime in Prague

According to the US Embassy in Prague, "While violent crime in Czech Republic is rare, theft is, unfortunately, quite common. 'Pickpockets' are especially frequent near tourist attractions and on public transportation. Thieves often work in groups, allowing them greater access to unsuspecting tourists and opportunities to escape. If you are the victim of a theft, report it to the Czech police as soon as possible. The Foreigner's Police is located at Olsanska 2, Prague 3, 974.820.238. A police station is also located next to the Embassy at Vlasska 362/3, 974.851.730."

Cost of Living in Prague

A person thinking about moving to Czech Republic asked, "Could someone describe the cost of living in Check Republic, like homes, apartments, food and shopping. I see $1US Dollar=$25 CZ Koruna. Would an American be able to retire here comfortably. What is an average monthly income for CZ people. Happy to see CZ does not use the Euro!" A member replied, "Easy answers: average salary is 25k CZK, monthly rent of appartment is from 6k CZK to 20k CZK, the cost in Prague is doubled than outside. Single person can easy live with 1000 USD/month, with 2000 USD you are very comfortable even in Prague. Many Americans are in Prague."

Meeting People in Prague

International Women's Association of Prague hosts meetings, luncheons, events and has a number of special interest groups including a happy hour group, a cinema group, a book club and an American Women's Group of Prague that meets on the 3rd Wednesday of each month at various cafes around Prague. Prager Runde is a club for German-speaking residents in Prague.

prague

Obtaining a Driver's License in Prague

According to the US Embassy in Prague, "Long term residents for more than 1 year and permanent residents are required to obtain a Czech driver's license (DL) to drive in the Czech Republic within 3 months of issuance of their long term stay/permanent residence. A precondition for the issuance of a DL is the successful completion of a test of driver competency, on the basis of which – provided that other conditions, such as age, adequate health, and others, are met – a person is granted a Driving Entitlement(s). Applications for DLs are processed by the appropriate office (based on the locale of the applicant's permanent/residence) of the Driver Registry of the municipal authorities of municipalities with delegated powers, or by the town hall of a city in the Czech Republic. Application forms may be obtained at any office of the Driver Registry of the municipal authority of municipalities with delegated powers, or at the town hall of a city. For more information on obtaining a Czech drivers license please check the webpage of the Ministry of Transportation of the Czech Republic dealing with drivers licenses at www.mdcr.cz. A list of driving schools can be found at www.firmy.cz or www.google.com."

What Expats Appreciate About Living in Prague

"There ARE some manners I like. People willing hop up to give somebody older their seat on the bus/train. People offer the help with directions a lot. There are no standards with dress, everyone wears what they want to wear! It's great. There is no corporate standard.. levels within society. Most people like to relax and enjoy life.. with a beer," wrote one expat in a report about culture shock in Prague.

"Once you have friends, they are wonderful friends. The food is not so healthy but delicious, the beer is the best. Magical architecture, beautiful countryside, Prague has excellent, inexpensive public transportation," explained another expat living in Prague.

Challenging Aspects of the Living in Prague

"Culture shock for me was pretty intense. I'm used to people smiling on the st, saying hi, good vibes, welcoming culture and it was actually the opposite here. People are rude, they don't walk around you, they walk into you. People don't say 'excuse me'. These small things were hard to take for the first month or two. Now I'm getting used to it more, I'm more 'immune' to it," explained one expat.

Another expat added, "I think it's a leftover from the communist era, the mistrust, the retaliation for a slight you didn't even know you committed, no one will make a decision in the Visa office. It's necessary to work through your job or an attorney. My friend got rejected because he did not "have a purpose. He's retired and was told point blank, after many months, that he could not be here just because he wanted to."

Visa Requirements

From the US State Department:

The Czech Republic (official short name: Czechia) is a party to the Schengen Agreement. Visit the Embassy of the Czech Republic's website for the most current visa and entry requirement information and its FAQ section on Schengen visas.

  • Passports should be valid for at least six months beyond the arrival date into Schengen, to avoid difficulties entering and traveling within the Schengen zone. For additional details about travel into and within Schengen countries, please see our Schengen fact sheet.
  • You may enter the Czech Republic for up to 90 days for tourist, business, study and most other purposes (except work) without a visa. This is counted along with presence in all Schengen countries for up to 90 days out of any 180-day period.
  • You will need a visa for longer stays or to work for any period of time in the Czech Republic. When a visa is required, submit your application to the nearest Czech diplomatic mission at least 3-4 months in advance of traveling to the Czech Republic. The U.S. Embassy cannot help speed up foreign visa applications.
  • The Czech Government requires travelers to be able to show proof, upon request, of sufficient finances to cover the cost of a traveler's stay.
  • You must also carry proof of a valid medical insurance policy contracted for payment of all costs for hospitalization and medical treatment while in the Czech Republic.

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

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

Finding a Job in Prague

For information about job openings in Prague for English speakers, search Glassdoor under 'English Speaking Jobs' in Prague and Jobs.cz for Prague.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

More about Prague

Healthcare in Czech Rep

Healthcare in Czech Rep

Important information about healthcare in Czech Republic, including health insurance requirements, quality of healthcare and more.

Moving-to-Prague

Moving to Prague

Expats have been arriving in Prague in ever increasing numbers for years. It's still regarded as an amazing city for expats, but it's popularity is starting to catch up with it. However, the scare housing and higher cost of living isn't keeping others from making a move to Prague.

Expats have been arriving in Prague in ever increasing numbers for years. It's still regarded as an amazing city for expats, but it's popularity is starting to catch up with it. However, the scare h...

Digital-Nomads-in-Prague,-Czech-Republic

Living Abroad: Digital Nomads in Prague, Czech Republic

Digital nomads are drawn to Prague for a wide variety of reasons: cost of living, nightlife, food and beer. This is a primer that will be continuously updated.

Digital nomads are drawn to Prague for a wide variety of reasons: cost of living, nightlife, food and beer. This is a primer that will be continuously updated....

Culture Shock in Prague

An American expat in Prague, Czech Republic shares his experiences living in Prague and also some advice on how to make a smooth transition.

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.

Join our Czech Rep Expat Forum

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

More about Czech Rep

10-Best-Places-in-the-World-to-Get-in-the-Christmas-Spirit10 Best Places in the World to Get in the Christmas Spirit

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

Digital-Nomads-in-Prague,-Czech-RepublicLiving Abroad: Digital Nomads in Prague, Czech Republic

Digital nomads are drawn to Prague for a wide variety of reasons: cost of living, nightlife, food and beer. This is a primer that will be continuously updated.

Moving-to-PragueMoving to Prague

Expats have been arriving in Prague in ever increasing numbers for years. It's still regarded as an amazing city for expats, but it's popularity is starting to catch up with it. However, the scare housing and higher cost of living isn't keeping others from making a move to Prague.

Healthcare-in-the-Czech-RepublicHealthcare in the Czech Republic

Important information about healthcare in Czech Republic, including health insurance requirements, quality of healthcare and more.

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Updated On: Nov 10, 2018

First Published: Nov 10, 2018

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Guide to Living in PragueGuide to Living in Prague

Expats in Prague offer advice to newcomers about living in Prague. Topics covered include international schools, best neighborhoods for expats, clubs for expats and more.

Healthcare in Czech RepHealthcare in Czech Rep

Important information about healthcare in Czech Republic, including health insurance requirements, quality of healthcare and more.

Restaurants in PragueRestaurants in Prague

Support your favorite restaurants in Prague as they recover from the pandemic. Submit a free listing for them on Expat Exchange to help spread the word about them to the expat community.

Moving-to-PragueMoving to Prague

Expats have been arriving in Prague in ever increasing numbers for years. It's still regarded as an amazing city for expats, but it's popularity is starting to catch up with it. However, the scare housing and higher cost of living isn't keeping others from making a move to Prague.

Expats have been arriving in Prague in ever increasing numbers for years. It's still regarded as an amazing city for expats, but it's popularity is starting to catch up with it. However, the scare h...

Digital-Nomads-in-Prague,-Czech-RepublicLiving Abroad: Digital Nomads in Prague, Czech Republic

Digital nomads are drawn to Prague for a wide variety of reasons: cost of living, nightlife, food and beer. This is a primer that will be continuously updated.

Digital nomads are drawn to Prague for a wide variety of reasons: cost of living, nightlife, food and beer. This is a primer that will be continuously updated....

Culture Shock in Prague

An American expat in Prague, Czech Republic shares his experiences living in Prague and also some advice on how to make a smooth transition.

10-Best-Places-in-the-World-to-Get-in-the-Christmas-Spirit10 Best Places in the World to Get in the Christmas Spirit

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

Digital-Nomads-in-Prague,-Czech-RepublicLiving Abroad: Digital Nomads in Prague, Czech Republic

Digital nomads are drawn to Prague for a wide variety of reasons: cost of living, nightlife, food and beer. This is a primer that will be continuously updated.

Moving-to-PragueMoving to Prague

Expats have been arriving in Prague in ever increasing numbers for years. It's still regarded as an amazing city for expats, but it's popularity is starting to catch up with it. However, the scare housing and higher cost of living isn't keeping others from making a move to Prague.

Healthcare-in-the-Czech-RepublicHealthcare in the Czech Republic

Important information about healthcare in Czech Republic, including health insurance requirements, quality of healthcare and more.

Czech Rep 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 05-Jul-20 10:44 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.193
Host Name 172.69.63.193


Execution Time

Total Time Avg Time Count Template
98 ms 98 ms 1 top level /home/www/html/lib_rd.cfm
25 ms 8 ms 3 /home/www/html/nativerotationtop_tester13.cfm
19 ms 19 ms 1 /home/www/html/navcontentboxcitymobile.cfm
10 ms 10 ms 1 /home/www/html/navcontentboxcitypc.cfm
10 ms 10 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
10 ms 10 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
9 ms 9 ms 1 /home/www/html/lib_rd_ctygd_readnext.cfm
7 ms 7 ms 1 /home/www/html/navtop_ctygd2.cfm
6 ms 6 ms 1 /home/www/html/breadcrumb_ctygd.cfm
6 ms 6 ms 1 /home/www/html/commentsnew_rdesign4.cfm
3 ms 3 ms 1 /home/www/html/Application.cfm
3 ms 3 ms 1 /home/www/html/navbottomad_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navmpu_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 0 ms 15 /home/www/html/rewritearticle.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/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/natad/native_5148_98556.txt
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.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/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
102 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 @ 22:44:05.005
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 22:44:05.005
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 22:44:05.005
	Select *
	From articles
	Where articleID = 5148
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 22:44:05.005
	Select *
	From sponcers
	Where sponcerID = 287 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 22:44:05.005
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 5148 
	and articles.articleID = 5148 
	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=1) in /home/www/html/lib_rd.cfm @ 22:44:05.005
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 5148
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 5148
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:44:05.005
	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 @ 22:44:05.005
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 36 
getcities (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:44:05.005
	Select *
	From citynetworks
	Where networkID = 36
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:44:05.005
  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
commentcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 22:44:05.005
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 5148 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid DESC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 22:44:05.005
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.193'
and logtime > "2020-04-05"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_ctygd2.cfm @ 22:44:05.005
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.193'
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_ctygd2.cfm @ 22:44:05.005
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.193'
and logtime > "2020-06-28"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 22:44:05.005
	SELECT *
	From contentcountcountry
	Where networkid = 36 
citycontentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 22:44:05.005
	SELECT *
	From contentcountcity
	Where citynetworkid = 4108 
citykeyimg (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navtop_ctygd2.cfm @ 22:44:05.005
	SELECT *
	From countryphotos
	Where citynetworkid = 4108
	and keyimg <> ''
	and usekey = 'y'
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 22:44:05.005
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5148 
checkcitynetwork (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 22:44:05.005
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 5148 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getlivingintro (Datasource=expert, Time=5ms, Records=0) in /home/www/html/breadcrumb_ctygd.cfm @ 22:44:05.005
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 36 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
      and keycity = 0
    and cityintro = 'n'
    and sectionintro = 'y'
   and articleCategories.section = '6'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
     and hpimg <> 'none'
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-05"

    ORDER by articles.articleID asc   
    
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 22:44:05.005
SELECT tag
FROM natadoptions 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:44:05.005
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:44:05.005
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:44:05.005
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 36
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-04"
and natsentencestart < "2020-07-05"
and natsentencestatus = 'live'

and (natsentenceweight = 'medium' or natsentenceweight = 'high')
getnatadtopull (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:44:05.005
SELECT *
FROM natadoptions 
WHERE 'movesentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:44:05.005
SELECT *
FROM natadoptions 
WHERE natadtypeid = 7 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:44:05.005
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 7
and natadPlacement.networkID = 36
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-04"
and natsentencestart < "2020-07-05"
and natsentencestatus = 'live'

and (natsentenceweight = 'medium' or natsentenceweight = 'high' or natsentenceweight = 'low')
getnatadtopull (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:44:05.005
SELECT *
FROM natadoptions 
WHERE 'banksentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:44:05.005
SELECT *
FROM natadoptions 
WHERE natadtypeid = 38 
getnatadbottom (Datasource=expert, Time=10ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 22:44:05.005
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 38
and natadPlacement.networkID = 36
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-04"
and natsentencestart < "2020-07-05"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getnatadbottom (Datasource=expert, Time=9ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 22:44:05.005
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 38
and natadPlacement.networkID = 36
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-04"
and natsentencestart < "2020-07-05"
and natsentencestatus = 'live'
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentboxcitymobile.cfm @ 22:44:05.005
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articleCategories, articlecityplace
	Where hitopic <> ''
	and hidescript <> ''
    and type = '3'
   and articlecityplace.citynetworkid = 4108
	and articlecityplace.articleid = articles.articleID
     and articleCategories.articleID = articles.articleID
    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 <> '5148'
	
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-05" 
    ORDER by articles.articleID desc  
gethealthsummary (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 22:44:05.005
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 36 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
checkculturefeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentboxcitymobile.cfm @ 22:44:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
         and networkid = 36
          and citynetworkid = 4108
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 22:44:05.005
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 69488 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 22:44:05.005
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 25353 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd_ctygd_readnext.cfm @ 22:44:05.005
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5148 
gettaxgeneral (Datasource=expert, Time=7ms, Records=4) in /home/www/html/lib_rd_ctygd_readnext.cfm @ 22:44:05.005
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 36 
	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 <> 5148
    and publishdate < "2020-07-05"
    and publishdate > "2014-01-01"
 
    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 22:44:05.005
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-04"
    and fromDate < "2020-07-05"
    and bannerPlacement.networkid = 36
    and bannerPlacement.bannerid = banners.bannerid
    and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 22:44:05.005
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 22:44:05.005
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-07-04 22:44:05'}
    and fromDate <{ts '2020-07-05 22:44:05'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 22:44:05.005
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 22:44:05.005
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 5148 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
getguidesummary (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:44:05.005
	Select summary, hiimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4108
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
gethealthsummary (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 22:44:05.005
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 36 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
checkculturefeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentboxcitypc.cfm @ 22:44:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
                    
         and networkid = 36
          and citynetworkid = 4108
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:44:05.005
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 69488 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:44:05.005
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 25353 


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=5148&networkid=36
REMOTE_ADDR=172.69.63.193
REMOTE_HOST=172.69.63.193
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=31122705
cftoken=59073345
sessionid=IBEXPATEXCHANGE.COM_31122705_59073345
urltoken=CFID=31122705&CFTOKEN=59073345
URL Parameters:
articleID=5148
networkid=36
Debug Rendering Time: 10 ms