Home Spain Forum Spain Guide Moving to Spain Real Estate Healthcare in Spain
Spain
Resources
City Guides
JoinSign In
Take the 2020 Expat Exchange Survey

International Schools in Barcelona, Spain

By Betsy Burlingame

Last updated on: Apr 28, 2017

Summary: Families moving to Barcelona have a number of great schools to consider. There are several American and British schools plus foreign children are allowed to attend public school. In this article we highlight several of the more popular English schools and expats' advice with regard to public vs. private English schools.

Expats in Barcelona - International Schools in Barcelona

American School of Barcelona

The American School of Barcelona (ASB) is an independent, coeducational day school, which offers an educational program from pre-kindergarten through grade 12 for students of all nationalities. The School was founded in 1962. The school year is comprised of two semesters, extending from early September to late June. Located in an attractive, residential area just 15 minutes from the center of Barcelona, ASB overlooks the city and the Mediterranean Sea. The School is housed in two main buildings that include classrooms, science laboratories, a media resource center, computer laboratories, art rooms, a music room, and a spacious modern lunch room with full kitchen. Physical education facilities include two outdoor sports courts, a soccer field, and several playgrounds. The early childhood center has its own self-contained facility with purpose-built play areas. "I am moving to Barcelona to teach at the American school of Barcelona. It is an English speaking school although students receive additional instuction to learn Spanish. I have been really impressed by the elementary principal, the school director, and the administrative staff. I have been in contact with some of the teachers working there already and they love it," said one teacher who was moving to Barcelona to teach at ASB.

The British School of Barcelona

The British School of Barcelona has programs for early years through secondary and 6th form. It is located in Castelldefels, a quite residential area about 30 minutes by car north of central Barcelona and about 10 minutes from the airport.

Kensington School in Barcelona

The Kensington School in Barcelona receives a tremendous amount of praise from parents on Expat Exchange. It is located in Pedralbes and is one of the oldest British curriculum schools in Spain. "Our boys have been going to Kensington school for over 3 years now. We are happy with it, but of course it's expensive now over 10K euro a year. They have both been sitting UK exams. The classes are small so they get plenty of help from the teachers. The teachers work them quite hard to keep the standard up," said one parent with children at Kensington. Another parent said, "our kids went to Kensington school for 4 years. We were very happy with it. Very good academically. They do some sport at school but for team sports the kids have to join local clubs, which is quite challenging. It's in Pedralbes, which has good access by local busses and not too far from the Metro. Families live all around. We lived near the centre of Barcelona and the boys went by bus to school." Yet another parent who chose Kensington said, "my children (6 and 7) go to Kensington school. Being small it is very friendly with over 20 nationalities. My children are half Japanese and there are currently 6 Japanese families at the school. I understand that the only other school with a Japanese connection is the full Japanese school in Sant Cugat. We chose Kensington initially because unlike EVERY other school including American, German and French, it is not subsidised in some way by the Catalan goverment and so does not teach in Catalan unlike ALL the other schools which can have a high Catalan content, to the detriment we feel of the national language and Spanish. The school GCSE and exam results are good at the top of the school. The school caters largely for families from embassies and executives of big foreign companies who are posted to Barcelona and so the average stay is 3-4 years and is designed for children to be able to slip in and out of an English type education."

Benjamin Franklin International School (BFIS)

The Benjamin Franklin International School (BFIS) is an independent, coeducational day school, which offers an English language college-preparatory program from nursery (age 3) through grade 12 for students of all nationalities. Founded in 1986, the School offers a differentiated, American curriculum, fully accredited with strong academic programs, including learning support and foreign languages. Graduates receive an American high school diploma, a Spanish high school bachillerato certificate or an IB Diploma. To maintain its global community, the School has a unique admissions policy, which strives for 1/3 of the students to be American, 1/3 Spanish, and 1/3 international. The School also has a highly involved school community and strong Parent Teacher Association (PTA). The School moved to its present location in a residential area of SarriĆ , Barcelona in 1991. In September of 2011, the School expanded by opening its new middle and high school building at Torras i Bajes, with library and common area, including state of the art technology. The elementary school includes an early childhood center with its own patio and a separate building for grades K-5, with playground, art facilities, and garden. In 2012 BFIS inaugurated a new library for elementary school, and in 2013 the school inaugurated a completely new auditorium and new fully equipped science labs. The entire campus has wireless Internet access.

Oak House School in Barcelona

Oak House School in Barcelona is located in a residential area 15 minutes northwest of central Barcelona. It welcomes students from ages 3 to 18 years of age. The school has over 800 students.

Attending a Public School In Spain

"Yes, foreign children are allowed to go to the public schools in Spain. Once you arrive and have an address, you have to "empadronar" -- that is, register at the nearest Ayuntamiento. Even illegal immigrants can do this. You will then go to the "scholarization office" and be assigned to a school close to where you live (we got to pick our top five choices), so keep that in mind when finding an apartment. Since your son is older, you may also need to get his transcript from his current school. I'm not sure if it will need an apostille (certification from the state where the school is located). I would contact the Spanish consulate to find out for sure. In Spain, there are public schools and also concertados. Concertados are publicly subsidized private schools (mostly Catholic) where parents pay a supplement (though not too much per month). To go to one of these schools, you also have to follow the above process (empadronamiento then Comision de escolarizacion)," explained one expat.

Another said, "if anyone else is relocating to Barcelona with children then yes it is correct that they may attend state/public schools. As long as you are renting a property and register yourself at the local town hall, your children can be registered for one of the schools in your district. Places are hard to come by, however, and if you are applying during term time, the department of education will let you know which schools have places in or outside of your catchment area. Remember that schools in Barcelona are Catalan. This is the main language with Spanish being taught as a foreign language for approx. 2-4 hours a week. Your other school option is concertada schools that are semi-private so more affordable."

"We moved to Barcelona from New Zealand 4 months ago with two boys aged 14 & 11 (now 15 & 12). We wondered where to send them to school but decided on an English Private school in the end (luckily my work agreed to pay the fees). People have said that if they go to a Spanish school that they lose a year of education but they become very fluent in Spanish (and its pretty hard to start with so they need to be kids that can cope). Our oldest boy he didn't want to lose a year of school when he was heading into examination years. Also it is harder here in Bcn to find a school that speaks Spanish not Catalan. We decided it would be better if they were both in the same school. They have both settled into the school well, although the work is harder (they have skipped half a year each because of the season difference and the syllabus is different). I think if they had been a couple of years younger we would have considered a Spanish school more seriously," said one expat who chose English schools for her children.

Join our Spain Expat Forum

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

Read Next

10-Tips-for-Living-in-SpainExpat Spain: 10 Tips for Living in Spain

With it's warm culture, thriving cities and beautiful countryside, expats agree that Spain has it all. Expats share their tips and experiences living in Spain.

5-Tips-for-Living-in-Barcelona5 Tips for Living in Barcelona

Barcelona is the capital of Catalonia, a region where some citizens are fighting for their independence from Spain. Barcelona is a beautiful city that's rich in history and architecture with a thriving nightlife scene.

5-Affordable-Places-to-Retire-in-Spain5 Affordable Places to Retire in Spain

Many retirees move to Spain in search of a better lifestyle and lower cost of living. Here are 5 affordable places to retire in Spain that range from bustling coastal cities, like Valencia, to regions with small coastal villages, like Huercal-Overa in Andalucia.

5-Tips-For-Living-in-Madrid5 Tips For Living in Madrid

Expats in Madrid live in a city with a broad appeal to people throughout the world, rich cultural traditions and some of the most delicious food in the world!

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 International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Comments about this Article

guest
Apr 28, 2017 10:28

Hi! I personally recommend Hamelin-Laie International School in Montgat, Barcelona. We have relocated there 5 months ago. The location is increible and the beaches are great. Hamelin-Laie is a very good school, for students from 0 to 18 years old, and offer National Baccalaureate and International Baccalaureate. My concern was that my daughter doesn't speak Spanish, but the school has also a Language School and they offer extra spanish lessons, and also for parents! The school has a really international feel, there is more than a half of international students for sure.

First Published: Oct 14, 2014

Cigna Expat Health InsuranceExpatriate Health Insurance

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

12-Expats-Talk-About-What-Its-Like-Moving-to-Spain12 Expats Talk About What It's Like Moving to Spain

Expats in Spain share their experiences moving to Spain. From what to bring to learning Spanish, culture shock to finding a flat.
Expats in Spain share their experiences moving to Spain. From what to bring to learning Spanish, culture shock to finding a flat. ...

Expat-SpainExpat Spain: 10 Tips for Living in Spain

With it's warm culture, thriving cities and beautiful countryside, expats agree that Spain has it all. Expats share their tips and experiences living in Spain.

With it's warm culture, thriving cities and beautiful countryside, expats agree that Spain has it all. Expats share their tips and experiences living in Spain....

Expats-in-Barcelona5 Tips for Living in Barcelona

Barcelona is the capital of Catalonia, a region where some citizens are fighting for their independence from Spain. Barcelona is a beautiful city that's rich in history and architecture with a thriving nightlife scene.

Barcelona is the capital of Catalonia, a region where some citizens are fighting for their independence from Spain. Barcelona is a beautiful city that's rich in history and architecture with a thrivi...

Expats-in-BarcelonaInternational Schools in Barcelona, Spain

Families moving to Barcelona have a number of great schools to consider. There are several American and British schools plus foreign children are allowed to attend public school. In this article we highlight several of the more popular English schools and expats' advice with regard to public vs. private English schools.

Families moving to Barcelona have a number of great schools to consider. There are several American and British schools plus foreign children are allowed to attend public school. In this article we ...

Retirement-In-SalamancaAn Expat Shares What it's Like Retiring in Salamanca, Spain

This report on retiring to Salamanca in Spain offers a great deal of advice for expats who might consider moving to this university city later in life. Find out about some of the the specifics to living in Salamanca and also what motivated this retiree to pick this ancient Celtic city in Northwestern Spain.

This report on retiring to Salamanca in Spain offers a great deal of advice for expats who might consider moving to this university city later in life. Find out about some of the the specifics to liv...

Moving-To-BarcelonaAn Expat Talks about Moving to Barcelona, Spain

An expat in Barcelona talks about the cost of living in Barcelona, finding an apartment that's pet friendly, learning the language and more.

An expat in Barcelona talks about the cost of living in Barcelona, finding an apartment that's pet friendly, learning the language and more....

Spain 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 02-Jun-20 01:56 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.141
Host Name 173.245.54.141


Execution Time

Total Time Avg Time Count Template
65 ms 65 ms 1 top level /home/www/html/lib_rd.cfm
32 ms 32 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
31 ms 31 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
30 ms 30 ms 1 /home/www/html/navcontentbox.cfm
8 ms 8 ms 1 /home/www/html/navtop_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/commentsnew_rdesign4.cfm
7 ms 7 ms 1 /home/www/html/lib_rd_readnext.cfm
6 ms 6 ms 1 /home/www/html/breadcrumb.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
3 ms 3 ms 1 /home/www/html/navbottomad_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
3 ms 3 ms 1 /home/www/html/navmpu_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 0 ms 7 /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 2 /home/www/html/navinjection.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /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
70 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 @ 01:56:26.026
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 01:56:26.026
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 01:56:26.026
	Select *
	From articles
	Where articleID = 4459
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/lib_rd.cfm @ 01:56:26.026
	Select *
	From sponcers
	Where sponcerID = 287 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 01:56:26.026
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 4459 
	and articles.articleID = 4459 
	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 @ 01:56:26.026
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 4459
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 4459
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 01:56:26.026
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 01:56:26.026
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 101 
getcities (Datasource=expert, Time=1ms, Records=8) in /home/www/html/navmeta_rdesign4.cfm @ 01:56:26.026
	Select *
	From citynetworks
	Where networkID = 101
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 01:56:26.026
  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=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 01:56:26.026
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 4459 
  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 @ 01:56:26.026
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.141'
and logtime > "2020-03-03"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 01:56:26.026
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.141'
and logtime > "2020-06-02 00:00:00.000"
and logtime < "2020-06-02 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 @ 01:56:26.026
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.141'
and logtime > "2020-05-26"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 01:56:26.026
	SELECT *
	From contentcountcountry
	Where networkid = 101 
gettopbanner (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 01:56:26.026
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-06-01"
    and fromDate < "2020-06-02"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 01:56:26.026
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 874 
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb.cfm @ 01:56:26.026
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4459 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 01:56:26.026
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 4459 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getschoolintro (Datasource=expert, Time=5ms, Records=0) in /home/www/html/breadcrumb.cfm @ 01:56:26.026
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 101 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
    and sectionintro = 'y'
   and articleCategories.section = '4'
    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-06-02"

    ORDER by articles.articleID asc   
    
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 01:56:26.026
SELECT tag
FROM natadoptions 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd_readnext.cfm @ 01:56:26.026
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4459 
gettaxgeneral (Datasource=expert, Time=6ms, Records=4) in /home/www/html/lib_rd_readnext.cfm @ 01:56:26.026
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 101 
	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.articleID <> 4459
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-02"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 01:56:26.026
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-06-01"
    and fromDate < "2020-06-02"
    and bannerPlacement.networkid = 101
    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 @ 01:56:26.026
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
gethpbox (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navmpu_rdesign5.cfm @ 01:56:26.026
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-06-01 01:56:26'}
    and fromDate <{ts '2020-06-02 01:56:26'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 01:56:26.026
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 01:56:26.026
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 4459 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 01:56:26.026
  SELECT *
  FROM users
  WHERE userid = 2 
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 01:56:26.026
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4459 
checkrptarticles (Datasource=reports, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 01:56:26.026
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-02"
     
         and rptarticlenetworks.networkid = 101 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 01:56:26.026
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 10
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 01:56:26.026
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 101 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 01:56:26.026
SELECT  hiimg
FROM rptarticles
where rptarticleID = 10
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 01:56:26.026
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 101 
	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-06-02"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 01:56:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 101 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 01:56:26.026
		Select summary, hiimg 
		FROM answers
         where answerid = 73345
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 01:56:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 101 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 01:56:26.026
		Select summary, hiimg 
		FROM answers
         where answerid = 72927
         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/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=4459&networkid=101
REMOTE_ADDR=173.245.54.141
REMOTE_HOST=173.245.54.141
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=28854689
cftoken=39472256
sessionid=IBEXPATEXCHANGE.COM_28854689_39472256
urltoken=CFID=28854689&CFTOKEN=39472256
URL Parameters:
articleID=4459
networkid=101
Debug Rendering Time: 12 ms