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

Spain Expat Forum

English speaking schools in Barcelona

Post New Topic
kiwifamily
6/27/2004 19:13 EST

Hi. We are moving to Barcelona in October and we're trying to decide on an English speaking school for our boys (nearly 12 and nearly 15). Because of where I'll be working (20km north of the city) we probably want a school in the city not in an outsie suburb. The ones on the net we have found are: Benjamin Franklin, Oak House, St Pauls, St Peters and Kensington. Does anyone know anything about any of these schools and their reputations? Also do you know about any other schools in/near Barcelona that are really good and we should consider. We did briefly think about Spanish schools but people have said that kids lose a year of schooling while they leanr to understand Spanish (we know none so far). Thanks for any help!

Post a Reply

00abuse

christyn2
7/10/2004 19:51 EST

Hi there. I am from San Diego and will moving in August to teach at the American School of Barcelona. It is an english speaking school although students receive additional instuction to learn Spanish. Obviously, I can't give you too much of a testimonial about the school since I haven't started yet but you can check out the website at A-S-B.com. 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! I think it is going to be wonderful and they use California teaching standards which I have considered very rigorous and effective. I hope this helps! Good luck! Oh, and I know a family who moved to Barcelona with their two children (elementary) and they were not impressed with the Benjamin Franklin school. The mother is a teacher as well.

Post a Reply

00abuse

expat health insurance from CIGNA

Choosing an expat health insurance provider is an important decision. Get a quote from our trusted expat health insurance partner, CIGNA. With Cigna Global Health Options, you can create an international health insurance plan that's perfectly tailored for the needs of you and your family.

Get a Quote

kiwifamily
7/20/2004 23:05 EST

Hi. Thanks for that reply. It was very helpful. We got very close to going with the Benjamin Franklin School, but in the end we found out about the Kensington School, which offers Japanese, which my older son is already studying. We did consider ASB but it is further out of town and I have to travel to Cabrils every day by train- we decided it would make the travel too long for everyone. However we will get them to go for one year there and can always change next year. It is really hard to decide from the other side of the world. Good luck with your teaching there- maybe we'll pop out and see you. Jill

Post a Reply

00abuse

Matilda
11/12/2007 10:47 EST

Hi, Kiwifamily!
How about the Kensington in Barcelona? We are thinking of changing our children to that school, but I can't find any information. Are you children happy there? Would you recommend it?
Thank you!

Post a Reply

00abuse

Matilda
11/12/2007 10:49 EST

Hi, Kiwifamily!
How about the Kensington in Barcelona? We are thinking of changing our children to that school, but I can't find any information. Are you children happy there? Would you recommend it?
Thank you!

Post a Reply

00abuse

jayninenelson
1/1/2008 23:28 EST

We have a 12 year old and are planning to live on a sail boat in Barcelona. Am interested in English speaking school not to pay 9000 Euros/year or $1300 monthly! Less expensive school than American school and closer to the waterfront port? Does anyone know of such a good school in Barcelona?

Post a Reply

00abuse

expat health insurance from CIGNA

Choosing an expat health insurance provider is an important decision. Get a quote from our trusted expat health insurance partner, CIGNA. With Cigna Global Health Options, you can create an international health insurance plan that's perfectly tailored for the needs of you and your family.

Get a Quote

jayninenelson
1/1/2008 23:28 EST

We have a 12 year old and are planning to live on a sail boat in Barcelona. Am interested in English speaking school not to pay 9000 Euros/year or $1300 monthly! Less expensive school than American school and closer to the waterfront port? Does anyone know of such a good school in Barcelona?

Post a Reply

00abuse

emrob
1/20/2008 13:50 EST

There are 2 port areas, Port Vell and Port Olimpic. The former is closer to the city centre and the latter closer to an area known as Vila Olimpica. They have a state school in Vila Olimpica that teaches some courses (i.e. history etc) in English. As with all state schools here it depends exactly on where you live as to whether you have a chance of getting a place. There is a drive to teach more English in public schools as of next year. If you are looking for an English Speaking school per se then the private option is the only solution. Most private English language schools are uptown or just out of town and cost around 600-700 euros monthly. Please also check out http://www.kidsinbarcelona.com for other information on living in the city with children.

Post a Reply

00abuse

kiwifamily
3/20/2008 08:47 EST

Hi
Sorry I didn't reply earlier- I haven't checked the forum for a while. Yes ours boys have been going to Kensington School for over 3 years now. We are happy with it but of course its 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. Not alot of subject choice or extra curricular activities. Ask any other questions you like.

Post a Reply

00abuse

eyerena
1/13/2010 12:06 EST

Hi,
i just read that you are teaching in an English school in Barcelona. I will be moving to BCN in July 2010 and am looking for a job as a psychologist/social worker/school counselor in English or French speaking schools in Barcelona. Could you give me any hints as to how to approach it?
Thank you

Post a Reply

00abuse

jubejubearabaraba
3/30/2010 10:35 EST

hi, do your kids still attend this school? we are visiting it next week. Is it sporty? Well located? Where are the best expat residential areas nearby? Many Thanks

Post a Reply

00abuse

kiwifamily
3/30/2010 20:44 EST

Hi,
No we left Barcelona 18 months ago. 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.
Its 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. Let me know if you have more questions.

Post a Reply

00abuse

HAJRA23
12/24/2010 09:58 EST

if any one need english teacher for home tuitions
do call me
600201689
thankyou

Post a Reply

00abuse

christina78756
4/28/2011 19:08 EST

Hello! I am getting ready to move to BCN in July. I was wondering if you ever found a position. I have a degree in Social Work. Thank you, Christina.

Post a Reply

00abuse

eyerena
5/10/2011 08:38 EST

Hi Christina,
In the end we are moving only this summer for this September so I have not yet found a job. are you already in BCN? Were you able to find anything?
Irina

Post a Reply

00abuse

robinmunday
3/29/2012 07:14 EST

Hi Kiwifamily,
my children (6, 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.

Post a Reply

00abuse

uclatutortutor
10/21/2015 07:01 EST

CURRENT ENGLISH TEACHER OF 1-4 E.S.O (NATIVE SPEAKER)
Hello :)

Looking for English lessons? Look no further, here in Barcelona you can have your child (or yourself) get real and authentic English conversations, and lessons, with a native English speaker from Los Angeles, California. My name is Abby and I have been educated at the famous university in Los Angeles known as UCLA. I would be delighted to tutor and assist with all of your English language learning needs. I will charge only 20 Euro per hour. My availabilities are Monday through Friday after 5pm. Please message me on whatsapp @ +685 04 71 06 to schedule a time for your lessons. Thank you!

Buscando clases de inglés? No busque más, aquí en Barcelona usted puede tener su hijo (o usted) conseguir conversaciones reales y auténticas en inglés y lecciones, con un hablante nativo de Inglés desde Los Angeles, California. Mi nombre es Abby y he sido educado en la famosa universidad de Los Angeles conocida como UCLA. Yo estaría encantado de dar clases y ayudar con todas sus necesidades de aprendizaje del idioma Inglés. Voy a cobrar solamente 20 Euros por hora. Mi disponibilidad es de lunes a viernes después de las 5pm. Por favor mensaje de WhatsApp @ +685 04 71 06 para programar un tiempo para sus lecciones. ¡Gracias!

Buscant classes d'anglès ? No busqui més , aquí a Barcelona vostè pot tenir el seu fill ( o vostè ) aconseguir converses reals i autèntiques en anglès i lliçons , amb un parlant nadiu d'anglès des de Los Angeles, Califòrnia. El meu nom és Abby i he estat educat en la famosa universitat de Los Angeles coneguda com UCLA . Jo estaria encantat de fer classes i ajudar amb totes les seves necessitats d'aprenentatge de l' idioma anglès. Cobraré només 20 euros per hora . La meva disponibilitat és de dilluns a divendres després de les 5pm . Si us plau missatge de WhatsApp @ +685 04 71 06 per programar un temps per a les seves lliçons. Gràcies!

Post a Reply

00abuse

wannabexpat
1/11/2016 19:42 EST

hi,
I know it is years after you posted your message, but I am looking into moving to BCN and was wondering if you ever found a job as a counselor, or know anything about the possibility of setting up on your own. I am a Mental Health Counselor, in my own business in NYC and would be interested to know the ins and outs of having my own office in BCN. I would also be interested in a position with an established clinic, if there is a place to find one. Can you help?

Post a Reply

00abuse

Expatriate Health Insurance

Get a quote for expat health insurance in Spain.

International Moving Companies

Moving to Spain? Get a moving quote.


Mail Forwarding to Spain

Mail Forwarding to Spain.


Expat Tax

Expat Tax Preparation, Expat Tax Professionals

Join Today (free)

Join Expat Exchange to meet expats in your area or get advice before your move. It's FREE and takes 1 minute!

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 /expat/index.cfm
Time Stamp 28-May-20 01:08 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.145
Host Name 173.245.54.145


Execution Time

Total Time Avg Time Count Template
126 ms 126 ms 1 /home/www/html/expat/Application.cfm
51 ms 51 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
50 ms 50 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
49 ms 49 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
36 ms 36 ms 1 /home/www/html/expat/messages_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/expat/message_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/navcontentbox.cfm
25 ms 25 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
14 ms 14 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
11 ms 1 ms 18 /home/www/html/navvote_rdesign5.cfm
9 ms 9 ms 1 /home/www/html/navtop_rdesign5.cfm
6 ms 6 ms 1 /home/www/html/navleader_rdesign5.cfm
3 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/expat/constants.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_GetModerators.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 18 /home/www/html/expat/common/formatmsg.cfm
0 ms 0 ms 1 /home/www/html/expat/copyright.cfm
0 ms 0 ms 1 /home/www/html/expat/datasources.cfm
0 ms 0 ms 1 /home/www/html/expat/ibkey.cfm
0 ms 0 ms 1 /home/www/html/expat/ibstyle.cfm
0 ms 0 ms 1 /home/www/html/expat/index.cfm
0 ms 0 ms 1 /home/www/html/expat/instaboard.cfm
0 ms 0 ms 1 /home/www/html/expat/navforumads_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_DesignSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GetCategory.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 1 /home/www/html/navjoin_rdesign4.cfm
0 ms 0 ms 3 /home/www/html/rewritearticle.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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
127 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GeneralSet.cfm @ 01:08:23.023
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=10ms, Records=1) in /home/www/html/expat/Application.cfm @ 01:08:23.023
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 01:08:23.023
	Select *
	From Networks
	Where frmid = 296 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 01:08:23.023
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 01:08:23.023
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 101 
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 01:08:23.023
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 296 
getcities (Datasource=expert, Time=1ms, Records=8) in /home/www/html/navmetaforums_rdesign5.cfm @ 01:08:23.023
	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/navmetaforums_rdesign5.cfm @ 01:08:23.023
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 01:08:23.023
	Select *
	From Networks
	Where networkID = 101 
GetTopicTitle (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 01:08:23.023
  SELECT f.frmid as frmid, frmname, t.tpcname, m.msgtext, t.urlchanged, t.tpcrewriteurl, t.section, t.citynetworkid, t.tpcnamenew, t.summary, t.keywords, m.msgid
  FROM forums f, topics t, messages m  
  WHERE f.frmid = 296 
  AND t.tpcid = 3324893 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
  AND t.tpcid = m.tpcid
  AND m.msgparent = 0
GetTopicInformation (Datasource=forum, Time=5ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 01:08:23.023
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext as msgintro, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.userid, u.userid, u.username, t.msgcount-1 as replycount, topicimage, topicimageapproved
  FROM messages m, users u, topics t
  WHERE m.tpcid = 3324893
  and  t.tpcid = 3324893
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=1ms, Records=36) in /home/www/html/navmetaforums_rdesign5.cfm @ 01:08:23.023
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 101
	order by lastsent ASC
GetTopicInformation (Datasource=forum, Time=3ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 01:08:23.023
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext as msgintro, m.msgparent, m.msghost, m.msgdate, m.msgupdate, t.tpcupdate, m.replylevel, m.userid, u.userid, u.username, t.msgcount-1 as replycount, topicimage, topicimageapproved
  FROM messages m, users u, topics t
  WHERE m.tpcid = 3324893
  and  t.tpcid = 3324893
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=0ms, Records=36, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 01:08:23.023
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 101
	order by lastsent ASC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 01:08:23.023
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.145'
and logtime > "2020-02-27"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 01:08:23.023
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.145'
and logtime > "2020-05-28 00:00:00.000"
and logtime < "2020-05-28 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 01:08:23.023
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.145'
and logtime > "2020-05-21"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 01:08:23.023
	SELECT *
	From contentcountcountry
	Where networkid = 101 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 01:08:23.023
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-05-27"
    and fromDate < "2020-05-28"
UpdatePageViews (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 01:08:23.023
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
GetNavigator (Datasource=forum, Time=0ms, Records=1) in /home/www/html/expat/Application.cfm @ 01:08:23.023
  SELECT catid, allowattach, isreviewed, isprivate, f.frmid as frmid, frmname, frmdesc, frmorder, frmpass, frmnotice, isapproved, f.isclosed as frmclosed, tpcname, tpcid, t.isclosed as tpcclosed, ispoll, isreviewed
  FROM forums f, topics t  
  WHERE f.frmid = 296 
  AND tpcid = 3324893 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
GetModerators (Datasource=forum, Time=0ms, Records=0) in /home/www/html/expat/queries/qry_GetModerators.cfm @ 01:08:23.023
  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 296
  AND u.userdbname = "ee"
  ORDER BY u.username
GetCategory (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GetCategory.cfm @ 01:08:23.023
  SELECT *
  FROM categories
  WHERE catid = "2"
DesignSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 01:08:23.023
  SELECT * FROM designset
  WHERE designsetid = 11 
GetFirstMessage (Datasource=forum, Time=4ms, Records=1) in /home/www/html/expat/messages_rdesign5.cfm @ 01:08:23.023
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.attachment, m.attachsize, m.updateuser, m.usesmilies, m. usesignature, m.isapproved, m.isdeleted, topics.isclosed, m.tpcid, m.userid, m.dbname, u.userid, u.usericon, u.username, u.useremail, u.userdbname, u.usertitle, u.isactive, u.signature, u.location, u.totalposts, u.userdate, u.allowpm, u.showicq, u.icqnumber, forums.frmid, topics.tpcid, topics.frmid, forums.dbname, m.guestname, m.guestemail, m.report, m.good, m.bad, topics.tpcname, forums.frmname, messageimage, messageimageapproved
  FROM messages m, users u, forums, topics  
  WHERE m.tpcid = 3324893
  AND m.userid = u.userid
  AND topics.tpcid = 3324893
  AND forums.frmid = topics.frmid
  AND forums.dbname = "ee"
  AND m.isapproved = 1
  AND m.msgparent = 0
  AND m.isdeleted <> 1
GetMessages (Datasource=forum, Time=5ms, Records=17) in /home/www/html/expat/messages_rdesign5.cfm @ 01:08:23.023
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.attachment, m.attachsize, m.updateuser, m.usesmilies, m. usesignature, m.isapproved, m.isdeleted, topics.isclosed, m.tpcid, m.userid, m.dbname, u.userid, u.usericon, u.username, u.useremail, u.userdbname, u.usertitle, u.isactive, u.signature, u.location, u.totalposts, u.userdate, u.allowpm, u.showicq, u.icqnumber, forums.frmid, topics.tpcid, topics.frmid, forums.dbname, m.guestname, m.guestemail, m.report, m.good, m.bad, messageimage, messageimageapproved
  FROM messages m, users u, forums, topics  
  WHERE m.tpcid = 3324893
  AND m.userid = u.userid
  AND topics.tpcid = 3324893
    AND m.isdeleted <> 1
  AND forums.frmid = topics.frmid
  AND forums.dbname = "ee"
     AND m.msgparent <> 0
  AND m.isapproved = 1
   
    ORDER BY m.msgid ASC 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 32719
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 32719
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 01:08:23.023
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 01:08:23.023
	Select *
	From Networks
	Where networkid = 101 
getnatadtype (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 01:08:23.023
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 01:08:23.023
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 101
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-05-27"
and natforumstart < "2020-05-28"
and natforumstatus = 'live'

and natforumweight = 'high'
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 32842
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 32842
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 51269
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 51269
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 51270
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 51270
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 52212
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 52212
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 01:08:23.023
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 01:08:23.023
	Select *
	From Networks
	Where networkid = 101 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 01:08:23.023
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 01:08:23.023
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 101
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-05-27"
and natforumstart < "2020-05-28"
and natforumstatus = 'live'

and (natforumweight = 'medium' or natforumweight = 'high')
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 01:08:23.023
SELECT resourceid, natforum as adcode, natforumweight, natadid
FROM natads 
WHERE natadid = 1 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 52213
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 52213
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 52640
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 52640
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 54303
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 54303
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 79266
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 79266
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 84711
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 84711
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 84756
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 84756
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 102000
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 102000
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 110880
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 110880
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 111494
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 111494
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 137722
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 137722
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 318108
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 318108
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 330713
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 01:08:23.023
SELECT vote
FROM votes
WHERE voteid = 330713
and vote = 'bad'
and liketype = 6 
getclasscheck (Datasource=tipripper, Time=21ms, Records=0) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 01:08:23.023
	SELECT answersphoto.photo, answersphoto.answerid, answersphoto.qid, answers.rid, allreports.networkname, allreports.networkid, allreports.city, allreports.state
	FROM answersphoto, answers, allreports 
	WHERE answersphoto.answerid = answers.answerid
	and allreports.answerid = answers.answerid
	and allreports.topicid = 6
	and allreports.hide <> 'y'
	and (answers.paid = 'yes' or answers.paid = 'free')
	AND answersphoto.qid = '104'
	AND allreports.networkid = 101
	AND "2020-05-28" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 01:08:23.023
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-28"
     
         and rptarticlenetworks.networkid = 101 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 01:08:23.023
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 10
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 01:08:23.023
	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:08:23.023
SELECT  hiimg
FROM rptarticles
where rptarticleID = 10
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 01:08:23.023
	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-05-28"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 01:08:23.023
		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:08:23.023
		Select summary, hiimg 
		FROM answers
         where answerid = 73345
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 01:08:23.023
		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:08:23.023
		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/expat/index.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/expat/index.cfm
QUERY_STRING=frmid=296&tpcid=3324893
REMOTE_ADDR=173.245.54.145
REMOTE_HOST=173.245.54.145
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expat/index.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Cookie Variables:
MS=flat
Session Variables:
cfid=28557272
cftoken=45322477
sessionid=IBEXPATEXCHANGE.COM_28557272_45322477
urltoken=CFID=28557272&CFTOKEN=45322477
URL Parameters:
frmid=296
tpcid=3324893
Debug Rendering Time: 11 ms