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

Banking in Costa Rica

By Betsy Burlingame

Last updated on: Jul 29, 2019

Summary: Information for expats living in Costa Rica about banking in Costa Rica, wire transfers, banking fees, banking limitations for those on a tourist visa and more.

Living in Costa Rica - Banking in Costa Rica

Can I Have My US Social Security Checks Direct Deposited in Costa Rica?

According to the US Embassy in Costa Rica: Receiving U.S. federal benefits via direct deposit is mandated by U.S. law. Social Security Beneficiaries in Costa Rica have several options for receiving benefits via direct deposit:

  1. Direct Deposit to a U.S. Bank Account ? You will need to supply the U.S. account information to the Federal Benefits Unit. The best way to provide your U.S. Bank information to the Federal Benefits Unit is by fax (hyperlink to Fax #) or using our online form.
  2. Corresponding direct deposit in U.S. dollars to a Costa Rican savings account through the Bank of New York Mellon by providing one of the following banking institutions with your completed enrollment form:
  3. International Direct Deposit through any Costa Rican Bank. You will need to complete form SSA-1199-OP-51 with your bank and return it to the Federal Benefits Unit via fax and/or mail. Note: If you fax or mail documents to our unit please make sure to include your name, claim number, e-mail address, and two telephone numbers where we can reach you.
  4. Direct Express ? https://www.usdirectexpress.com

Is it Difficult to Open an Bank Account in Costa Rica?

"I was easily able (in Spanish) to open an account at Bank of Costa Rica and at same time request social security to be deposited automatically. I opened the acct on the 15th of the month, and the 1st of the next month my social security was in there. I was shocked. (the first time you get it on the 1st, thereafter at 9am on the 3rd. Easy as pie. But a guy in the cafe told me that he had wrestled with the bank guy for one hour trying to open an account. But the second he said that he wanted social security deposited automatically, everything went fast. SO, I began my conversation with 'I would like an account and have my social security deposited automatically'. He immediately started doing it, but what was funny was, after he took care of account papers, he asked, do you still want your soc sec deposited. I said Yes. But it insinuated I would not have had to. I think what helps is having all the needed documents, speaking in Spanish (look up all the terms you will need in dictionary) and act like you have done your homework, instead of marching in speaking English," wrote one expat in Costa Rica.

Best Banks for Expats in Costa Rica

In a thread about the Banking in Costa Rica, a newcomer asked, "Any recommendations regarding which banks are the Best to use in Costa Rica???"

"I started with Banco Nacional, but one thing I don't like about them is (in Grecia) that everyone can see what you are doing at the ATM. I ended up later closing the account," commented one expat.

"I also like Bank of Costa Rica because they have separate little rooms for using ATM, with partially frosted windows. Also have locks which I normally do not use unless the security guard is not there or no one around," added another expat.

"Not all Bank of Costa Rica locations have separate rooms for ATMs. The BCR in Tamarindo has one exterior ATM in a public courtyard, and their seating area for banking is small, often requiring some people to wait outside. Banco Nacional in Tamarindo is much nicer. So visit each of the bank branches in your area. I currently have accounts at both BCR and BNCR. I encountered problems with BCR when setting up a CD for Rentista Residency so now I generally prefer BNCR," explained another expat.

Consider Opening Several Accounts in Costa Rica

"For me making sure I use credit cards with no foreign transaction fee, debit cards with no ATM fees. And several accounts in case for some reason one doesn't work or you lose your card," commented one expat.

Banking is Limited If You Have a Tourist Visa

While still not a 'legal resident', the banks will likely not permit you to deposit more than $1000 a month, so if you need more funds, you will have to use the ATM or make a wire transfer, both of which you will have to pay for. Be prepared to tell them where the funds are originating. Also the bank will likely only offer you basic electronic services. Once you have gained legal residency, you will be required to produce proof that your SS/guaranteed for life pension has been transferred into CR when you go to get your cedula renewed," explained an expat in Costa Rica.

"As I recall we were able to open BCR savings acct with just passport, though limited to deposits less than $1000 per month. Received a debit card to go with it. Local experience is that Scotia has more English speaking tellers but BCR is pretty much everywhere," said another expat.

Wire Transfers in Costa Rica & Wire Fees

In a thread about money in Costa Rica, one expat asked, "Anyone have ideas about getting money to Costa Rica from US banks without $40 wire fees each month that is charged by my US bank? I have a savings account with BCR. I am limited to having a balance of $1500 US per month the bank said. Has anyone opened a checking account and deposited a physical check each month to avoid these fees? BCR said it takes 3 weeks for US check to clear. Is this the best system? This account would be used to pay the electric, water, and cell phone, cable bill etc online. Thanks!!"

"In general, I have found the method of depositing a US check every month and allowing about 30 days for it to clear is the most cost effective method to bring moderate amounts of money to CR. (I pay the wire transfer fees for large amounts, such as to buy a car). I opened an account at BCR after I got residency and can now deposit up to $2500 each month by check, with no additional fees. I also just opened a new account at Banco Nacional, but they said that they charge a $40 fee for a US check deposit over $1000! So I started with a $1000 check deposit with no added fees, and it cleared after 15 days - and then I deposited another check for $1000," replied one expat.

"I have an account with Banco America Central. My deposits are ready to use as soon as the deposit is made. I pay a $6 a month fee, nothing else. Money transfers from the US are always in my account here within two working days. Opening the account required no more than my passport and filling out a considerable number of application pages. However, all my transactions are from US Federal Institutions, Social Security, Dept of Defense, Energy Research and Development Administration. I keep banking in Costa Rica to a minimum. And under $5000 to simplify things for my accountant. Preferring Swiss bank in Basel. Also I have had no use for credit cards in nearly 45 years. Only debit cards. With cars as well as homes I have always paid cash or balance in 30 days. Wiring money is expensive to North America, inexpensive to other Central American countries," explained another expat in Costa Rica.

"We personally used a company called Desyfin Financiera. We were and continue to be pleased with their service. I don't know what area you are in, but they have offices here and there. We use the one in Grecia. I did all in Spanish, and they have no one who speaks English well, but they can help you wire money in and would be $25 for even a chunk. Then you can put in an account in dollars or colones. But the account in colones you earn about 3.5%. You can pay bills from it. You need proof where the money came from though, if from sale of house or long standing savings account or whatever. If you want to invest in CD's, you can earn about 8% and more depending on length up to 2 years. Also, something you cannot do in US, you can receive your interest at end of term, every 3 months, or monthly at a slightly less rate. After you have your cedula, you can get CD's at Coop Grecia for about 9.25%. In colones. Can get in dollars but only about 2% or so, can't remember exactly. Desyfin has been around about 25 yrs and Coop Grecia over 50 yrs," said another expat.

Join our Costa Rica Expat Forum

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

Read Next

Expats-Talk-About-The-Biggest-Challenges-They-Face-Living-in-Latin-AmericaExpats Talk About The Biggest Challenges They Face Living in Latin America

Expats talk about some of the biggest challenges they've faced living in Latin America. Whether you're moving to Panama City or Punta del Este, this article is a must read to help you prepare (hint: you'll be much happier if you learn the language) and adjust your expectations (realities: the roads are rough, the pace of life is slower and bureaucracy is unavoidable). Despite all of the challenges, the list of what expats like about life in Latin America far exceeds the challenges.

Costa-Rica-vs-PanamaCost of Living: Costa Rica vs. Panama

People considering a move to Central America often narrow down their list to Panama and Costa Rica. Expats talk about the cost of living in Panama and Costa Rica - housing costs, gas, car, electric, internet, groceries, budgets for various lifestyles and more.

Expat-Costa-Rica10 Expats Share Tips for Moving to Costa Rica

Expats in Costa Rica answer the question: If a friend of yours was thinking of moving here, what other advice would you give them. One expat summed it up perfectly when he said not to let your desire to live in paradise get in the way of thinking about the logistics. Here's what other expats had to say.

Costa-Rica-ResidencyCosta Rica Residency

Applying for residency in Costa Rica can be a daunting process. Which type of residency is right for me? Do I need an attorney? Do I have to leave the country every 90 days? What is a cedula? This article answers these and many other questions.

Healthcare-in-Costa-RicaHealthcare in Costa Rica

Costa Rica is has both public and private healthcare systems. When you become a resident, you must enroll in the public healthcare system (CAJA). Many expats use the public system for routine healthcare and have private expat health insurance for specialists, surgeries and emergencies.

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

hockeyrick
Jul 29, 2019 15:37

No one makes any mention if the online banking(either pc or smartphone) sites/apps have multi languages or not. In Asia you ALWAYS have a pulldown menu or the local/English tab. What about in CR? Mexico was usually just Spanish, with some subtitles. How language friendly are the various bank sites and apps?

Updated On: Mar 26, 2019

First Published: Mar 26, 2019

Cigna Expat Health InsuranceExpatriate Health Insurance

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

10-Expats-Talk-About-What-Its-Like-Living-in-Costa-Rica10 Expats Talk About What It's Like Living in Costa Rica

Expats living in Costa Rica talk about Pura Vida, deciding where to live in Costa Rica, meeting people and more.
Expats living in Costa Rica talk about Pura Vida, deciding where to live in Costa Rica, meeting people and more....

Latin-AmericaExpats Talk About The Biggest Challenges They Face Living in Latin America

Expats talk about some of the biggest challenges they've faced living in Latin America. Whether you're moving to Panama City or Punta del Este, this article is a must read to help you prepare (hint: you'll be much happier if you learn the language) and adjust your expectations (realities: the roads are rough, the pace of life is slower and bureaucracy is unavoidable). Despite all of the challenges, the list of what expats like about life in Latin America far exceeds the challenges.

Expats talk about some of the biggest challenges they've faced living in Latin America. Whether you're moving to Panama City or Punta del Este, this article is a must read to help you prepare (hint:...

Cost-of-LivingCost of Living: Costa Rica vs. Panama

People considering a move to Central America often narrow down their list to Panama and Costa Rica. Expats talk about the cost of living in Panama and Costa Rica - housing costs, gas, car, electric, internet, groceries, budgets for various lifestyles and more.

People considering a move to Central America often narrow down their list to Panama and Costa Rica. Expats talk about the cost of living in Panama and Costa Rica - housing costs, gas, car, electric, ...

Retirement-In-San-Isidro-de-HerediaAn Expat Shares What it's Like Retiring in San Isidro de Heredia, Costa Rica

Why retire in San Isidro de Heredia, Costa Rica? Can you live on $1,000 or $2,000 a month? How difficult is it if you aren't fluent in Spanish when you first arrive? A retiree who arrived in Costa Rica a month ago answers these and other questions.

Why retire in San Isidro de Heredia, Costa Rica? Can you live on $1,000 or $2,000 a month? How difficult is it if you aren't fluent in Spanish when you first arrive? A retiree who arrived in Costa ...

Moving-To-Playa-Hermosa-de-JacoAn Expat Talks about Moving to Playa Hermosa de Jaco, Costa Rica

An expat who has lived in Costa Rica gives all kinds of great advice on living there. Cost of housing, what to bring with you, how to settle in and much more is covered in this comprehensive expat report.

An expat who has lived in Costa Rica gives all kinds of great advice on living there. Cost of housing, what to bring with you, how to settle in and much more is covered in this comprehensive expat re...

Costa Rica 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 29-May-20 07:59 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.68
Host Name 162.158.78.68


Execution Time

Total Time Avg Time Count Template
113 ms 113 ms 1 top level /home/www/html/lib_rd.cfm
37 ms 19 ms 2 /home/www/html/nativerotationtop_tester13.cfm
30 ms 30 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
30 ms 30 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
29 ms 29 ms 1 /home/www/html/navcontentbox.cfm
12 ms 12 ms 1 /home/www/html/commentsnew_rdesign4.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
8 ms 8 ms 1 /home/www/html/lib_rd_readnext.cfm
5 ms 5 ms 1 /home/www/html/navmpu_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
4 ms 4 ms 1 /home/www/html/navbottomad_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/navleader_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/breadcrumb.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.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_5266_20837.txt
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 9 /home/www/html/rewritearticle.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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
118 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 @ 19:59:55.055
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 19:59:55.055
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 19:59:55.055
	Select *
	From articles
	Where articleID = 5266
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/lib_rd.cfm @ 19:59:55.055
	Select *
	From sponcers
	Where sponcerID = 287 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 19:59:55.055
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 5266 
	and articles.articleID = 5266 
	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=1ms, Records=0) in /home/www/html/lib_rd.cfm @ 19:59:55.055
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 5266
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 5266
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 19:59:55.055
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 19:59:55.055
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 33 
getcities (Datasource=expert, Time=1ms, Records=9) in /home/www/html/navmeta_rdesign4.cfm @ 19:59:55.055
	Select *
	From citynetworks
	Where networkID = 33
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 19:59:55.055
  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 @ 19:59:55.055
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 5266 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid DESC
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 19:59:55.055
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.68'
and logtime > "2020-02-28"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 19:59:55.055
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.68'
and logtime > "2020-05-29 00:00:00.000"
and logtime < "2020-05-29 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 @ 19:59:55.055
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.68'
and logtime > "2020-05-22"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 19:59:55.055
	SELECT *
	From contentcountcountry
	Where networkid = 33 
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 19:59:55.055
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-05-28"
    and fromDate < "2020-05-29"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 19:59:55.055
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb.cfm @ 19:59:55.055
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5266 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 19:59:55.055
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 5266 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 19:59:55.055
SELECT tag
FROM natadoptions 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:59:55.055
SELECT *
FROM natadoptions 
WHERE 'bankheader' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:59:55.055
SELECT *
FROM natadoptions 
WHERE natadtypeid = 37 
getnatadbottom (Datasource=expert, Time=9ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 19:59:55.055
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 37
and natadPlacement.networkID = 33
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-05-28"
and headerparagraphstart < "2020-05-29"
and headerparagraphstatus = 'live'

and headerparagraphweight = 'high'
getnatadbottom (Datasource=expert, Time=9ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 19:59:55.055
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 37
and natadPlacement.networkID = 33
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-05-28"
and headerparagraphstart < "2020-05-29"
and headerparagraphstatus = 'live'
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:59:55.055
SELECT *
FROM natadoptions 
WHERE 'banksentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:59:55.055
SELECT *
FROM natadoptions 
WHERE natadtypeid = 38 
getnatadbottom (Datasource=expert, Time=9ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 19:59:55.055
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 38
and natadPlacement.networkID = 33
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-05-28"
and natsentencestart < "2020-05-29"
and natsentencestatus = 'live'

and (natsentenceweight = 'medium' or natsentenceweight = 'high')
getnatadbottom (Datasource=expert, Time=9ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 19:59:55.055
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 38
and natadPlacement.networkID = 33
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-05-28"
and natsentencestart < "2020-05-29"
and natsentencestatus = 'live'
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd_readnext.cfm @ 19:59:55.055
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5266 
gettaxgeneral (Datasource=expert, Time=6ms, Records=5) in /home/www/html/lib_rd_readnext.cfm @ 19:59:55.055
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 33 
	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 <> 5266
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-29"

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

    ORDER by articles.articleID desc
    
checkretirefeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 19:59:55.055
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 33 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 19:59:55.055
		Select summary, hiimg 
		FROM answers
         where answerid = 76511
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentbox.cfm @ 19:59:55.055
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 33 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 19:59:55.055
		Select summary, hiimg 
		FROM answers
         where answerid = 75202
         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=5266&networkid=33
REMOTE_ADDR=162.158.78.68
REMOTE_HOST=162.158.78.68
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=28659679
cftoken=13781200
sessionid=IBEXPATEXCHANGE.COM_28659679_13781200
urltoken=CFID=28659679&CFTOKEN=13781200
URL Parameters:
articleID=5266
networkid=33
Debug Rendering Time: 10 ms