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

Costa Rica Residency

By Betsy Burlingame

Last updated on: Feb 05, 2020

Summary: 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.

Living in Costa Rica - Costa Rica Residency

Newcomers to Costa Rica have lots of questions about obtaining residency in Costa Rica. Which type of residency is right for me? How much does it cost? Do I need a lawyer? Where should I open a bank account? What is a cedula? This article covers the 5 common types of residency and answers many of the most commonly asked questions. Plus, expats talk about their experiences obtaining residency in Costa Rica.

"If you choose to be a resident, you will need to qualify under one of five different categories. As an approved resident, you will not be required to leave the country every 90 days. Five of the categories to qualify for residency is as follows: Family relationship to a Costa Rican, pensioner, small investor, investor, or company work visa," wrote one expat living in Playa Hermosa.

The 5 Residency Options for Expats in Costa Rica

Here's an overview of the 5 main residency programs that expats living in Costa Rica pursue:

Pensionado

Pensionado Visa Requirements

The Pensionado Residency Program, or Pensioner Visa, is Costa Rica's retirement visa for people moving to Costa Rica who are 55 years of age and over. You must show proof of US $1,000 income for life. "One way is to come in as a pensioner. This only requires showing a minimum of $1000 a month income for life, as well as of course dealing with a lot of paperwork and paying fees. Those who can't or prefer not to show the $1000 a month income for life can obtain residency as either rentistas or investors," wrote one expat.

Rentista

Rentista Visa Requirements

The Rentista Residency Program, or Small Investor Visa, requires proof of $2,500 per month in income for a 2-year period (must be guaranteed by a bank) or a $60,000 deposit in an approved Costa Rican bank. One member said, "Please be aware that a second US $60,000 will be needed to be deposited, 2 years later for Rentista residency," cautioned one expat in a discussion about depositing the $60k for the Rentista Visa in the bank.

Inversionista

Inversionista Visa Requirements

The Inversionista Residency Program, or Investor Visa, requires a $200,000 USD investment in a business or property. "If you want to start a business in Costa Rica, the minimum investment is US $200,000. You will be required to remain in the country at least six months per year, and you cannot claim a spouse or dependants under 18. You are entitled to income from the project, and can own a company and receive dividends," wrote Lic Giovanna Barrantes in his article, What you need to know to become a resident of Costa Rica.

"Inversionista status is the most difficult to achieve. You would have to present plans and documentation of how many workers etc you intend to employ. Plus, you have to have the property already in your possession, when you apply and there is no guarantee that it will be accepted by immigration. This is what happened to us, so then had to reapply for Rentista status. Also those with Inversionista status tend to pay the highest premium for the mandatory CAJA coverage. And if the principal applicant is under 55 you could find yourself paying over $450 monthly," wrote one expat.

Representante

Representante Visa Requirements

The Representante Residency Program, or Representative or Company Visa, is offered to company directors. "If you are a representative of a company (a Representante), the applicant must be a company director, and employ a minimum number of local workers as established by the labor law, with financial statements certified by a public accountant. The representative must remain in Costa Rica at least six months per year, cannot claim a spouse or dependants under 18, but can earn an income from the company, and can own a company and receive income," wrote Lic Giovanna Barrantes.

Permanente

Permanent Residency Requirements

Permanent Residency is available to someone with a first-degree relative (via marriage or family).

Expat Health Insurance in Costa Rica

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

Do I need to hire an attorney to apply for residency?

The answer to this question depends upon whom you talk with and their experience obtaining residency. Some expats are able to do the paperwork themselves and navigate the process. Others fully appreciate having the advice, language skills and assistance of an attorney. Others try it themselves and end up hiring an attorney. Here are a few expat responses to this question:

"It is absolutely worth paying a representative to act on your behalf," responded one expat.

"I've just gone through the process on my own behalf because my lawyer wanted to charge too much and he kept making mistakes. I did everything myself for a lot less money. The big expenditure is paying the initial fee which if you're applying outside of Costa Rica is only about $50 but if you're applying inside Costa Rica it's $200, I think is what I paid. It's time consuming either way. There's no fast way. But it's just a question of submitting some documents i.e. birth certificate properly certified, background check properly certified (apostille), proof that your income is at $1000/month, etc. You'll have to resign yourself to making a few trips to the immigration offices and wait in line for an hour or two. There are seats to sit in and since you are 65 or over you have a legal right to go to the head of the line without waiting. It's exactly what your lawyer would have to do but you'd have to pay him at least $1000. If you do it yourself it's a lot cheaper. If you don't speak Spanish you'd probably need a translator to go with you however. Just paying a Tico 10,000colones ($20) would be a reasonable rate. Or you could pay someone $40 and just have them do it for you for the day. You don't need a lawyer," said another.

"I got my residency without a lawyer and had no problem. Spanish language skills would definitely help you understand and work through the bureaucracy. The CR Migracion website has instructions to get you started. Be patient and good luck," added another.

"I need to jump in with my thoughts or even questions. We do have our residency, and I got the documents together that were needed, and I did all of them correctly. Takes being detailed and thorough. But we did use a lawyer, and he did a good job and stuck fully to his quote. But without him, if I had to do it today and did not know Spanish, nor the area, I would today have a problem finding Immigration and where to get fingerprints. But there were umpteen buildings there, and trying to find the right line to get in and remembering which building. And then it was noisy, and even though at that point in time the lawyer was not with us, they would holler the instructions and it was a miracle we could even understand our name as mis-pronounced it so much barely could recognize. Years ago, I read that you could hire a runner that would guide you through to process there. Even though I speak Spanish well, to me, I wouldn't be able to find the fingerprint building or right line at Immigration. That is the problem I would have. I also read once, that if you don't have a lawyer or a 'runner' or whatever he was called, they kind of play their ignoring games or head games that they can at times do, and make it take a whole lot longer and difficult," wrote another expat.

What is the expediente?

"Once you have received your "Expediente" which is proof that your residency is in process, you do not have to leave the country every 90 days. We received our Expediente three weeks after giving the lawyer all correct documents. Then returned to CR and stayed until we received our cedula, which took a total of 9 months," explained one expat.

"Once you have received the "expediente" (file saying that your application is under consideration) you do not have to leave, UNLESS you wish to keep driving, as I previously mentioned," added another member in Costa Rica.

Car Insurance & Border Crossings

If you are in the middle of the residency application process and have your expediente, you are not required to make border crossings every 90 days (for your residency); however, if you and driving and have auto insurance, you are required to leave the country every ninety days until you have your cedula.

Our partner, Clements Worldwide offers international auto insurance to expats in Costa Rica. Their unique international policy does NOT require expat policyholders to leave the country every 90 days. For more information about their international insurance plans or Get a Quote.

What is a Cedula?

The Cedula, or c?dula de identidad, is the identity card that residents of Costa Rica receive. It is about the size of the credit card and includes the resident's photo, personal identification number, expediente number, nationality, the resident's DIMEX number (if they have one), other personal information and the resident's signature. DIMEX, Documento de Identificaci?n Migratorio para Extranjeros, is the number used by the immigration and banking system in Costa Rica to keep track of the flow of money. If you have a DIMEX number, it is printed on the bottom right of your Cedula.

Type of Residency & CAJA Payments

CAJA is the common term for Caja Costarricense de Seguro Social (abbreviated as CCSS). CAJA is Costa Rica's social security system which provides public healthcare. "You are required to be a legal resident of Costa Rica. Once the application process is almost complete, it is mandatory that you become affiliated with CAJA. This process may take a year or more."

The type of residency you obtain in Costa Rica definitely impacts your monthly CAJA costs. "Investor and Rentista premiums are much higher than for a Pensionado, And even more so, if one is under 55. Unfortunately, you won't know what your premium will be until the final step of the application process," wrote one expat in a discussion about residency as an investor.

Additional Info: Healthcare in Colombia

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

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

How do I register with my embassy?

To apply for residency in Costa Rica, the Costa Rican government requires applicants register with their home country's embassy.

For Americans, complete the following steps:

  1. Complete the Smart Traveler Enrollment Program process online and print the profile info page.
  2. Turn in the profile page to the Costa Rican immigration office where you are applying.

PLEASE NOTE: It is no longer a requirement to have the STEP profile or confirmation page notarized at the U.S.Embassy. Smart Traveler Enrollment Program

How do I request a criminal history?

For Americans, you may request a criminal history, or "Identity History Summary", from the FBI. The FBI website states that: "Current processing time for Identity History Summary requests submitted via the mail is 2-4 weeks. Allow additional time for mail delivery." To be safe, you should request the criminal history 2+ months before the date you need it.

Apostille vs. Notary Requirements

According to the US State Department: Apostilles are federally-issued documents for use in countries that are members of the 1961 Hague Convention may need to be authenticated with an apostille issued by the U.S. Department of State. Documents signed by the following officials require an apostille issued by the U.S. Department of State:

  • U.S. federal official
  • U.S. consular officer
  • A military notary, judge advocate (10 USC 1044a), or a foreign consul diplomatic official registered with the U.S. Department of State's Office of Protocol

Note: All certifications must include a legible signature of the official's name, title, and seal of the agency.

Here's a list of the members of the Hague Convention.

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

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

About the Author

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

Cigna Expat Health InsuranceExpatriate Health Insurance

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

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.

More about Costa Rica

Best-Places-to-Live-in-Costa-Rica

7 Best Places to Live in Costa Rica

Costa Rica is a relatively safe, eco-friendly, expat-friendly destination with gorgeous beaches and friendly locals. Many expats say that housing and food prices in Costa Rica are high. We've gathered information submitted by expats about Tamarindo, Dominical, Ojochal, Atenas, Escazu, Grecia and others popular towns.

Costa Rica is a relatively safe, eco-friendly, expat-friendly destination with gorgeous beaches and friendly locals. Many expats say that housing and food prices in Costa Rica are high. We've gathere...

Staying-Safe-in-Costa-Rica

Staying Safe in Costa Rica

Recent crimes in Costa Rica have involved robbers arriving at homes and impersonating police officers. Alley Cat offers great advice and detailed information about what you need to know when the police are at your door.

Recent crimes in Costa Rica have involved robbers arriving at homes and impersonating police officers. Alley Cat offers great advice and detailed information about what you need to know when the polic...

3-Ways-to-Get-Rich-as-an-Expat-in-Costa-Rica

3 Ways to Get Rich as an Expat in Costa Rica

Expats in Costa Rica have three main ways to make money legally -- you can obtain permanent residency, find an online job or start your own business. Bill Ripley covers each of these options and offers great tips for expats looking to make money while living in Costa Rica.

Expats in Costa Rica have three main ways to make money legally -- you can obtain permanent residency, find an online job or start your own business. Bill Ripley covers each of these options and offe...

8-Things-to-Know-Before-Moving-to-Costa-Rica

Moving to Costa Rica: 8 Things to Know Before Moving to Costa Rica

Moving to Costa Rica has become more popular among expats. Making this choice requires a lot of research to ensure the expat experience you hope for will be realized. Expats that live there stress that it should start with a trip there before any major decisions are made.

Moving to Costa Rica has become more popular among expats. Making this choice requires a lot of research to ensure the expat experience you hope for will be realized. Expats that live there stress t...

5-Tips-For-Living-in-San-Jose,-Costa-Rica

5 Tips For Living in San Jose, Costa Rica

The majority of expats in San Jose, actually choose to live not in the city, but outside of it. There are great options in the surrounding area, including places that are closer to the coast than San Jose.

The majority of expats in San Jose, actually choose to live not in the city, but outside of it. There are great options in the surrounding area, including places that are closer to the coast than San...

6-Things-to-Do-in-Jaco,-Costa-Rica

6 Things to Do in Jaco, Costa Rica

An expat in Jaco, Costa Rica shares 6 fun activities for expats (and tourists) to do in Jaco. From surfing to bar hopping to shopping for organic fruits and veggies at the local markets, Jason Mueller shares some great activities.

An expat in Jaco, Costa Rica shares 6 fun activities for expats (and tourists) to do in Jaco. From surfing to bar hopping to shopping for organic fruits and veggies at the local markets, Jason Muelle...

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Updated On: Feb 05, 2020

First Published: Feb 05, 2020

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

Cost-of-Living-in-Costa-RicaCost of Living in Costa Rica

If you're moving to Costa Rica, you'll want to understand the cost of living in Costa Rica. Lifestyle, location and health insurance are part of the formula. Expats talk about real estate prices, rents, international school tuition, travel expenses and the fun stuff - travel, dining out and more.

If you're moving to Costa Rica, you'll want to understand the cost of living in Costa Rica. Lifestyle, location and health insurance are part of the formula. Expats talk about real estate prices, re...

8-Things-to-Know-Before-Moving-to-Costa-RicaMoving to Costa Rica: 8 Things to Know Before Moving to Costa Rica

Moving to Costa Rica has become more popular among expats. Making this choice requires a lot of research to ensure the expat experience you hope for will be realized. Expats that live there stress that it should start with a trip there before any major decisions are made.

Moving to Costa Rica has become more popular among expats. Making this choice requires a lot of research to ensure the expat experience you hope for will be realized. Expats that live there stress t...

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.

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, ...

Moving-To-Costa-RicaExpats Talk about What it's Like Moving to Costa Rica

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

17-Best-Places-to-Live-in-Costa-Rica17 Best Places to Live in Costa Rica

Costa Rica has a lot to offer expats with its tropical climate, eco-friendly culture, beautiful beaches, welcoming people, good healthcare system and relative safety. Many expats warn newcomers about the high cost of housing and food. In this updated version of the best places to live in Costa Rica we cover many more locations such as Playa Flamingo, Nosara, Lake Arenal, Jaco Beach and Ojochal.

Costa Rica has a lot to offer expats with its tropical climate, eco-friendly culture, beautiful beaches, welcoming people, good healthcare system and relative safety. Many expats warn newcomers about...

13-Best-Places-for-Families-to-Live-in-Costa-Rica13 Best Places for Families to Live in Costa Rica

Expats in Costa Rica talk about the best places for families to live in Costa Rica. From the cool climate of the Central Valley to the beautiful beach towns in Gaunacaste and Costa Ballena, proximity to international and bilingual schools, safety and lifestyle are all taken into consideration.

Expats in Costa Rica talk about the best places for families to live in Costa Rica. From the cool climate of the Central Valley to the beautiful beach towns in Gaunacaste and Costa Ballena, proximity...

Best-Places-to-Live-in-Costa-Rica7 Best Places to Live in Costa Rica

Costa Rica is a relatively safe, eco-friendly, expat-friendly destination with gorgeous beaches and friendly locals. Many expats say that housing and food prices in Costa Rica are high. We've gathered information submitted by expats about Tamarindo, Dominical, Ojochal, Atenas, Escazu, Grecia and others popular towns.

Costa Rica is a relatively safe, eco-friendly, expat-friendly destination with gorgeous beaches and friendly locals. Many expats say that housing and food prices in Costa Rica are high. We've gathere...

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 02-Jul-20 06:24 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.127
Host Name 172.69.63.127


Execution Time

Total Time Avg Time Count Template
191 ms 191 ms 1 top level /home/www/html/lib_rd.cfm
56 ms 56 ms 1 /home/www/html/lib_rd_ctrygd_readnext.cfm
54 ms 54 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
53 ms 53 ms 1 /home/www/html/navcontentboxmovingpc.cfm
53 ms 53 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
32 ms 32 ms 1 /home/www/html/breadcrumb.cfm
20 ms 20 ms 1 /home/www/html/navtop_rdesign5.cfm
12 ms 12 ms 1 /home/www/html/navmeta_rdesign4.cfm
6 ms 6 ms 1 /home/www/html/commentsnew_rdesign4.cfm
5 ms 2 ms 3 /home/www/html/nativerotationtop_tester13.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
4 ms 4 ms 1 /home/www/html/navleader_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navbottomad_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navmpu_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/natad/native_5523_88661.txt
0 ms 0 ms 1 /home/www/html/boolsearch.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/constants.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 16 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 1 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 1 /home/www/html/rewritereportscountry.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/datasources.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
196 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 @ 18:24:34.034
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 18:24:34.034
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 18:24:34.034
	Select *
	From articles
	Where articleID = 5523
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 18:24:34.034
	Select *
	From sponcers
	Where sponcerID = 367 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 18:24:34.034
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 5523 
	and articles.articleID = 5523 
	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 @ 18:24:34.034
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 5523
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 5523
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=2ms, Records=153) in /home/www/html/navmeta_rdesign4.cfm @ 18:24:34.034
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 18:24:34.034
	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 @ 18:24:34.034
	Select *
	From citynetworks
	Where networkID = 33
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=7ms, Records=154) in /home/www/html/navmeta_rdesign4.cfm @ 18:24:34.034
  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=0) in /home/www/html/navmeta_rdesign4.cfm @ 18:24:34.034
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 5523 
  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 @ 18:24:34.034
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-04-02"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 18:24:34.034
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-07-02 00:00:00.000"
and logtime < "2020-07-02 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 18:24:34.034
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-06-25"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 18:24:34.034
	SELECT *
	From contentcountcountry
	Where networkid = 33 
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 18:24:34.034
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-01"
    and fromDate < "2020-07-02"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 18:24:34.034
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb.cfm @ 18:24:34.034
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5523 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 18:24:34.034
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 5523 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getimmigrationintro (Datasource=expert, Time=31ms, Records=1) in /home/www/html/breadcrumb.cfm @ 18:24:34.034
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 33 
	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 = '2'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
     and hpimg <> 'none'
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-02"

    ORDER by articles.articleID asc   
    
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 18:24:34.034
SELECT tag
FROM natadoptions 
getnatadtopull (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:24:34.034
SELECT *
FROM natadoptions 
WHERE 'hiheader' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:24:34.034
SELECT *
FROM natadoptions 
WHERE natadtypeid = 1 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:24:34.034
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 1
and natadPlacement.networkID = 33
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-07-01"
and headerparagraphstart < "2020-07-02"
and headerparagraphstatus = 'live'

and (headerparagraphweight = 'medium' or headerparagraphweight = 'high' or headerparagraphweight = 'low')
getnatadtopull (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:24:34.034
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:24:34.034
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:24:34.034
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 33
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-01"
and natsentencestart < "2020-07-02"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:24:34.034
SELECT resourceid, natsentence as adcode, natsentenceweight, natadid
FROM natads 
WHERE natadid = 46
and natsentencetype = 2 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:24:34.034
SELECT *
FROM natadoptions 
WHERE 'movesentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:24:34.034
SELECT *
FROM natadoptions 
WHERE natadtypeid = 7 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:24:34.034
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 7
and natadPlacement.networkID = 33
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-01"
and natsentencestart < "2020-07-02"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 18:24:34.034
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5523 
gettaxgeneral3 (Datasource=expert, Time=27ms, Records=4) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 18:24:34.034
	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 keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and articles.articleID <> 5523
    and publishdate < "2020-07-02"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettaxgeneral4 (Datasource=expert, Time=28ms, Records=2) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 18:24:34.034
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articlecityplace
	Where hitopic <> ''
	and articlePlacement.networkID = 33 
	AND articlePlacement.articleID = articles.articleID
		and articlecityplace.articleid = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and articles.articleID <> 5523
    and publishdate < "2020-07-02"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 18:24:34.034
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-01"
    and fromDate < "2020-07-02"
    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 @ 18:24:34.034
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 18:24:34.034
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-07-01 18:24:34'}
    and fromDate <{ts '2020-07-02 18:24:34'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 18:24:34.034
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 18:24:34.034
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 5523 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 18:24:34.034
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5523 
gettaxgeneral2 (Datasource=expert, Time=16ms, Records=3) in /home/www/html/navcontentboxmovingpc.cfm @ 18:24:34.034
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 33 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
   and (articleCategories.section = '1' or articleCategories.section = '2' or articleCategories.section = '4' or articleCategories.section = '5')   
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    
    and articles.articleID <> '5523'
	
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-02"
     ORDER by articles.sectionintro DESC, articles.articleID desc 
 
checkmovingfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentboxmovingpc.cfm @ 18:24:34.034
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
      
         and networkid = 33 
         and city <> ''
         order by date DESC
getbestplaces (Datasource=expert, Time=29ms, Records=3) in /home/www/html/navcontentboxmovingpc.cfm @ 18:24:34.034
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl, publishdate
	FROM articles, articlePlacement, articleCategories 
 	Where hitopic <> ''
	and (((title LIKE '%Best%') OR (author LIKE '%Best%') OR (hitopic LIKE '%Best%') OR (hidescript LIKE '%Best%')) AND ((title LIKE '%Places%') OR (author LIKE '%Places%') OR (hitopic LIKE '%Places%') OR (hidescript LIKE '%Places%')))
	and articlePlacement.networkID = 33
	AND articlePlacement.articleID = articles.articleID
	  and articleCategories.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and (articleCategories.section <> '1' and articleCategories.section <> '2' and articleCategories.section <> '4' and articleCategories.section <> '5')   
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and summary <> ''
    and publishdate < "2020-07-02"
    ORDER by articles.articleID desc


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=5523&networkid=33
REMOTE_ADDR=172.69.63.127
REMOTE_HOST=172.69.63.127
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=30848061
cftoken=74213754
sessionid=IBEXPATEXCHANGE.COM_30848061_74213754
urltoken=CFID=30848061&CFTOKEN=74213754
URL Parameters:
articleID=5523
networkid=33
Debug Rendering Time: 11 ms