Home Costa Rica Forum Costa Rica Guide Moving to Costa Rica Real Estate Healthcare in Costa Rica
Costa Rica
Resources
City Guides
JoinSign In
AGS Worldwide Movers

Costa Rica Visa & Residency > Costa Rica Immigration FAQ > Do I need to be living in Costa Rica to apply for residency?

Do I need to be living in Costa Rica to apply for residency?

By Betsy Burlingame

Last updated on: Feb 05, 2020

One member asked, "I've been reading the responses on this topic and finding them very helpful. Just have one question. If someone starts the application process from the U.S., and say it gets approved in a year (or whenever), does anyone know the requirements at that point of having to move to CR? Is there a time limit there?"

"Not, to actually move, but you will have to be here to finalize the process. This means signing up for CAJA, the healthcare system and apply for your cedula, for which you will have to have so set an appointment," wrote one member in Costa Rica in a discussion about residency.

The initial posted asked, "Ok, so say I start the application process today. Fast forward 1 year and I am at the point where they are ready for me to make my appointment to finalize the application. Maybe I have some family commitments that mean I won't be able to go down for 6 months. How long will they keep it open before closing the file and requiring you to start the process all over again?"

"I think it is 3 months, but you would have to check that. Note that most lawyers require all the funds up front...as many applicants change their minds, and you won't get a refund. Visit a few time before starting the process. Sorry to say, that I don't think the type of business you mention that you're presently involved in, is something that would 'go down well' here," responded one member.

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.

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

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

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.

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

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

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.

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


Execution Time

Total Time Avg Time Count Template
81 ms 81 ms 1 top level /home/www/html/lib_rd.cfm
27 ms 27 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
26 ms 26 ms 1 /home/www/html/navcontentboxmovingpc.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
9 ms 9 ms 1 /home/www/html/commentsnew_rdesign4.cfm
8 ms 8 ms 1 /home/www/html/lib_rd_readnext.cfm
7 ms 7 ms 1 /home/www/html/breadcrumb.cfm
5 ms 5 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/navmeta_rdesign4.cfm
4 ms 4 ms 1 /home/www/html/navmpu_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/nativerotationtop_tester13.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 0 ms 11 /home/www/html/rewritearticle.cfm
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/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/natad/native_5521_26609.txt
0 ms 0 ms 2 /home/www/html/navinjection.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
87 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:03:00.000
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 19:03:00.000
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 19:03:00.000
	Select *
	From articles
	Where articleID = 5521
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=0) in /home/www/html/lib_rd.cfm @ 19:03:00.000
	Select *
	From sponcers
	Where sponcerID = 0 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 19:03:00.000
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 5521 
	and articles.articleID = 5521 
	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:03:00.000
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 5521
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 5521
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 19:03:00.000
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 19:03:00.000
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 33 
getcities (Datasource=expert, Time=0ms, Records=9, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 19:03:00.000
	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:03:00.000
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
commentcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 19:03:00.000
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 5521 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid DESC
getrandomphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 19:03:00.000
	Select twimg as guidephoto, hpimg
	From countryphotos
	Where networkID = 33
	and guidephoto = 'yes'
	and twimg <> ''
getrandomphoto (Datasource=expert, Time=1ms, Records=26) in /home/www/html/navmeta_rdesign4.cfm @ 19:03:00.000
	Select twimg as guidephoto, hpimg
	From countryphotos
	Where networkID = 33
		and twimg <> ''
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 19:03:00.000
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.75'
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:03:00.000
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.75'
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:03:00.000
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.75'
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:03:00.000
	SELECT *
	From contentcountcountry
	Where networkid = 33 
gettopbanner (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 19:03:00.000
	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
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 19:03:00.000
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb.cfm @ 19:03:00.000
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5521 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 19:03:00.000
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 5521 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getimmigrationintro (Datasource=expert, Time=6ms, Records=1) in /home/www/html/breadcrumb.cfm @ 19:03:00.000
	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-05-29"

    ORDER by articles.articleID desc
    
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 19:03:00.000
SELECT tag
FROM natadoptions 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:03:00.000
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:03:00.000
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=0ms, Records=2) in /home/www/html/nativerotationtop_tester13.cfm @ 19:03:00.000
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-05-28"
and natsentencestart < "2020-05-29"
and natsentencestatus = 'live'

and (natsentenceweight = 'medium' or natsentenceweight = 'high')
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd_readnext.cfm @ 19:03:00.000
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5521 
gettaxgeneral (Datasource=expert, Time=6ms, Records=5) in /home/www/html/lib_rd_readnext.cfm @ 19:03:00.000
	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 <> 5521
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-29"

    ORDER by articles.articleID desc
    
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navbottomad_rdesign5.cfm @ 19:03:00.000
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-05-28"
    and fromDate < "2020-05-29"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=4ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 19:03:00.000
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
gethpbox (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 19:03:00.000
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eehpboxcountry"
    and toDate > {ts '2020-05-28 19:03:00'}
    and fromDate <{ts '2020-05-29 19:03:00'}
    and weight < 7
    and bannerPlacement.networkid = 33
    and bannerPlacement.bannerid = banners.bannerid
    and banners.type <> 'swf'
  
gethpbox (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 19:03:00.000
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
	and weight < 7
    and toDate > {ts '2020-05-28 19:03:00'}
    and fromDate <{ts '2020-05-29 19:03:00'}
    and banners.type <> 'swf'
    
gethpbox (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 19:03:00.000
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
    and toDate > {ts '2020-05-28 19:03:00'}
    and fromDate <{ts '2020-05-29 19:03:00'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 19:03:00.000
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 19:03:00.000
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 5521 
  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 @ 19:03:00.000
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5521 
gettaxgeneral2 (Datasource=expert, Time=7ms, Records=2) in /home/www/html/navcontentboxmovingpc.cfm @ 19:03:00.000
	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 <> '5521'
	
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-29"
     ORDER by articles.sectionintro DESC, articles.articleID desc 
 
checkmovingfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentboxmovingpc.cfm @ 19:03:00.000
		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=10ms, Records=2) in /home/www/html/navcontentboxmovingpc.cfm @ 19:03:00.000
	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-05-29"
    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=5521&networkid=33
REMOTE_ADDR=173.245.54.75
REMOTE_HOST=173.245.54.75
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=28657325
cftoken=54400230
sessionid=IBEXPATEXCHANGE.COM_28657325_54400230
urltoken=CFID=28657325&CFTOKEN=54400230
URL Parameters:
articleID=5521
networkid=33
Debug Rendering Time: 10 ms