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

8 Tips for Obtaining Long-Term Residency in Spain

By Betsy Burlingame

Jun 16, 2016

Summary: An overview of the different types of long-term residency visas in Spain including expat advice on the application process. Covers the three main types: residence visa, work and residence visa and student visa. Plus, the retirement visa, investment and entrepreneurial visas and several others.

Moving to Spain - 8 Tips for Obtaining Long-Term Residency in Spain

Long-term residence visas in Spain authorize residency for an indefinite period of longer than 5 years. The US Embassy in Madrid covers temporary residency, less than 5 years, on their Website. In this article, we discuss the three main types of long-term residence visas, several other types of long-term visas and the Pareja Hecha option.

According to the Embassy of Spain in Washington D.C., "These [long-term] visas entitle their holders to reside, to reside and work, to study, or to research in Spain. All foreigners wishing to enter Spain to reside, reside and work, or study, need to hold a visa of this kind, unless they are citizens of the European Union, Iceland, Liechtenstein, Norway or Switzerland." The embassy goes on to explain that the long-term visa application must be filed in person, but may also be filed by a "duly accredited representative" if you don't live in a town where a Diplomatic Mission or Consular Office is located or have "a sickness or physical condition that significantly reduces your mobility."

According to the Spanish Consulate in Los Angeles, there are three main types of long-term residence visas:

  1. Residence Visa: this type of visa enables the visa holder to live in Spain without working or performing any professional activities.
  2. Work and Residence Visa: this type of visa enables the visa holder to work and live in Spain.
  3. Student Visa: this type of visa enables the visa holder to live in Spain while studying, researching or doing an internship.
In addition to these three main types of visas, there are a number of other types described below. It is important to get the advice of the consulate when deciding which type of long-term visa best suits your situation. Plus, you may want to get the advice of other expats already in Spain by posting your questions on our Spain Forum.

The Visa Process Varies by Embassy or Consulate

"The visa process is somewhat dependent on which embassy or consulate covers your area. The requirements are mostly similar except minimum income may be different. You cannot file your application until 3 - 4 months before your arrival date. Start about 4-6 weeks before that, as it takes about that long to get your state police records with fingerprints, and then get everything apostilled. Everything has to have a certified translation - we used an online service and the turn-around was less than a week. I can answer as many specific questions as you need," advised one expat. "Yes, I was surprised to find that different Spanish embassies in the US have different requirements. In the US, there are Spanish embassies in San Francisco, Los Angeles, Boston, Chicago, Miami, Houston, New Orleans, New York, and Washington D.C. You must go to the one which has jurisdiction over your application. Info easily found by googling Spanish embassies in the US or Spanish visa for US citizens," added another expat. "My husband and I fell under the jurisdiction of the San Francisco consulate. For that embassy, they required proof of income statements from our individual pensions. The amount of money in our bank accounts were totally irrelevant. Though the overall rules may be the same, I think the details vary depending on the consulate. San Francisco was quite difficult to be honest," explained another expat. Spain's Ministry of Foreign Affairs and Cooperation has an interactive map with all of Spain's consulates and embassies around the world.

Proof of Medical Insurance Requirement

According to the Consulate of Spain in Washington DC, all four types of residence visas require you to have overseas medical insurance from a company licensed to operate in Spain. If you are interested in private health insurance, you may get a quote from our trusted expat health insurance partner, CIGNA.

The Residence (or Non-Lucrative) Visa

The Consulate of Spain in Los Angeles offers information (in English) about applying for the Residence Visa (non-lucrative). Their site cautions that, "We cannot overstate the importance of paying the utmost attention to filling out the application and the accompanying information. INCOMPLETE OR INCORRECT APPLICATIONS WILL BE REJECTED, REQUIRING THE APPLICANT TO MAKE A NEW APPOINTMENT AT A LATER DATE." Additionally, they state that all documents must be translated into Spanish. You must submit your application in person no more than 90 days in advance of the intended travel date. If approved, the Residence Visa must be picked up in person within one month of receiving notification of approval.

Documents to submit include the visa application form and visa documents checklist, passport photo, passport or travel document, I.D. card, Alien Registration Card or long-term US Visa (if you are not a US citizen), medical certificate, EX 01 form, 790-52 form, no police record certification, proof of economic funds, proof of travel insurance, property signed disclaimer and visa fees. The instructions for filling out and submitting these documents are very specific.

"Your most likely option is the Visado de Residencia No Lucrativa (Non-Working Residence Visa). For this, you'll need to show that you have a certain amount of money available in your bank account (USA bank account is ok); or a contract guaranteeing you a certain monthly income (for example, from a USA company that employs you, while you work from home, wherever home happens to be). To find out just how much this total or monthly requirement is, contact the consulate to which you will apply for the visa. (It will be "around" 25,000 euro per person per year.) You'll also need to show that you have housing for the upcoming year, or a reasonable plan for procuring it (Again: I recommend asking the responsible consulate for further specification). Also: health insurance. Also: no police record. And some other paperwork-type items. Again, the thing to do here is to contact the consulate to which you'll apply and get the right/exact details from the people who will process and approve your application," advised one expat in Spain. Another expat added, "There are numerous steps to obtain a non-lucrative visa. For documentation of income, I used my savings, statement of value of my retirement plan, and projected social security benefits once I turn 62 (not much help if you are young.) I had my financial adviser write a letter projecting how much money I would have available monthly based on these three documents. Of course, it also had to be translated into Spanish."

Work and Residence Visa

Visados de residencia y trabaj (work and residence visa) allows foreigners to work and live in Spain for an indefinite period of time, longer than 5 years. Like the Residence Visa (above), the Consulate of Spain in Los Angeles warns that the forms must be filled out in full and correctly. The required document list is also similar, but includes the authorization of work and residence permit approval document and your work contract proving fulfillment of economic funds. The specific instructions for the required documents and forms are very detailed. The visa must be applied for in person within 90 days of your travel date (but not exceeding 90 days).

"To work (legally) will require you to have a work-permitting visa, and you will not be able to 'just apply for one' and then, say, show up and start applying for jobs. It would be theoretically possible to get a job with a Spanish employer ahead of time and go from there, but this is extremely likely: the unemployment rate for Spanish young people ranges from 25-50% depending on the region, and, unless you're a world-recognized astrophysicist contracting with the national science laboratory, employers are unlikely to receive "permission" to hire you. So, if you want to work, you'll need to (1) get a job or contract with an American or international company which happens to have a branch in Spain, and manage to get yourself assigned to Spain; (if this interests you and you have some good qualifications, think about, e.g., the international consulting companies); (2) position yourself as a "teacher" of some sort and get a contract with one of the international schools or language schools; (3) work for yourself, and be sure – before applying for the visa – that you can prove the necessary income or savings availability (e.g., if you are, say, a translator or a web designer, show that you have a history of regular and sufficiently remunerating contracts). I don't want to dissuade you with the "hardness" of the process. You can do it! Be aware, though, that it's going to take a lot of work, and maybe some creative problem-solving along the way," advised an expat living in Spain.

Student Visa

For students traveling to Spain for studies of 180 days or longer, they must first go to the local police department to obtain a student ID. After that, the application is similar to the residence visa application with the addition of submitting a letter of acceptance as a full time student in Spain. The Consulate of Spain in Los Angeles provides detailed information about the application for a Student Visa. One expat discussed some added benefits of the Student Visa saying, "FYI: students can apply for their family members to join them while studying in Spain. The relatives' residence permits are usually granted for the same duration as the student's residence permit, and allow the holders over 18 to take on employment in Spain without a work permit." Please note this only applies to an internship in your area of study in collaboration with the university.

Other Types of Long-Term Residence Visas

There are several other types of long-term residence visas. A number of them were introduced as part of the Residence visas Law 14-2013 (aka Law of entrepreneurs and its internationalization).

They include:

  • Residence visa for Capital Investors
  • Residence visa for buyers of Real State in Spain
  • Residence visa for entrepreneurs and business investors
  • Residence visa for highly skilled professionals
  • Residence visa by intracorporate transfer and residence visa for training, research, development and innovation.

Additionally, there are a few other long-term visas:

The Pareja Hecha Route

"You could go the pareja hecha route. This is simple ceremony carried out in your local town hall (Ayuntamieto) and is basically a civil partnership. If your lady friend is willing to follow this route she needs to consult at her local Ayuntamieto but l'm sure you would need to register with them first. If it is possible to carry out the procedure you should be able to apply for residency as you are in a relationship that carries status in Spain equal to all intents and purposes to marriage. To register you need to get to Spain, move in with your lady friend and register on the padron (register) at her local Ayuntamiento. I'm assuming your lady friend is Spanish and if this is the case she should be familiar with the padron process. I went the pareja hecha route myself some years ago and I was in and out of the Ayuntamiento in less than half an hour although I didn't go through the process for visa reasons. I don't know if you would have any problems if you were to enter Spain on a tourist visa and then do a pajera hecha but the Spanish are very sympathetic regarding affairs of the heart and it seems completely feasible to me. To be sure I think a visit to your nearest Spanish consul would be advisable although your LF can contact the Spanish Ministry of the Interior as well. If you just go ahead and jump in feet first I can't see what problem might arise as far as regularising your situation in Spain would be," recommended an expat in Spain who had gone through the pareja hecha process.

Private Health Insurance for Expats in Spain

If you would like information about private expat health insurance in Spain, get a quote from our trusted expat health insurance partner, CIGNA.

Join our Spain Expat Forum

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

Read Next

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

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

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

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

International-Schools-in-BarcelonaInternational Schools in Barcelona, Spain

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

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

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

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

First Published: Jun 16, 2016

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Culture-Shock-in-Granada-An Expat Talks about Culture Shock & Living in Granada , Spain

One expat in Granada appreciates the fresh air and food, the weather and the focus on family. He says that life is slower in Granada and advises newcomers to learn Spanish before they arrive.

One expat in Granada appreciates the fresh air and food, the weather and the focus on family. He says that life is slower in Granada and advises newcomers to learn Spanish before they arrive. ...

Living-in-ValenciaAn Expat Discusses Living in Valencia, Spain

An expat in Valencia talks about enjoying the Mediterranean lifestyle. You'll need to learn Castellano and a little Valenciano.

An expat in Valencia talks about enjoying the Mediterranean lifestyle. You'll need to learn Castellano and a little Valenciano. ...

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

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

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

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

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

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

International-Schools-in-BarcelonaInternational Schools in Barcelona, Spain

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

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

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

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

Spain Guide
Other Links
Our Story Our Team Contact Us Submit an Article Advertising Travel Warnings

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /lib_rd.cfm
Time Stamp 30-May-20 10:12 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.69
Host Name 173.245.54.69


Execution Time

Total Time Avg Time Count Template
114 ms 114 ms 1 top level /home/www/html/lib_rd.cfm
36 ms 36 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
36 ms 36 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
35 ms 35 ms 1 /home/www/html/navcontentbox.cfm
33 ms 33 ms 1 /home/www/html/commentsnew_rdesign4.cfm
27 ms 27 ms 1 /home/www/html/Application.cfm
23 ms 23 ms 1 /home/www/html/navtop_rdesign5.cfm
16 ms 16 ms 1 /home/www/html/navbottomad_rdesign5.cfm
16 ms 16 ms 1 /home/www/html/navleader_rdesign5.cfm
16 ms 16 ms 1 /home/www/html/navmpu_rdesign5.cfm
8 ms 8 ms 1 /home/www/html/breadcrumb.cfm
7 ms 7 ms 1 /home/www/html/lib_rd_readnext.cfm
4 ms 4 ms 1 /home/www/html/navmeta_rdesign4.cfm
1 ms 1 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 2 /home/www/html/rewritecityname.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 8 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereport.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/datasources.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
142 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 @ 22:12:18.018
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=23ms, Records=1) in /home/www/html/Application.cfm @ 22:12:18.018
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 22:12:18.018
	Select *
	From articles
	Where articleID = 4770
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 22:12:18.018
	Select *
	From sponcers
	Where sponcerID = 367 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 22:12:18.018
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 4770 
	and articles.articleID = 4770 
	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 @ 22:12:18.018
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 4770
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 4770
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:12:18.018
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 22:12:18.018
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 101 
getcities (Datasource=expert, Time=1ms, Records=8) in /home/www/html/navmeta_rdesign4.cfm @ 22:12:18.018
	Select *
	From citynetworks
	Where networkID = 101
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:12:18.018
  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 @ 22:12:18.018
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 4770 
  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 @ 22:12:18.018
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.69'
and logtime > "2020-02-29"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 22:12:18.018
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.69'
and logtime > "2020-05-30 00:00:00.000"
and logtime < "2020-05-30 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 @ 22:12:18.018
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.69'
and logtime > "2020-05-23"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:12:18.018
	SELECT *
	From contentcountcountry
	Where networkid = 101 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 22:12:18.018
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
UpdatePageViews (Datasource=expert, Time=16ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 22:12:18.018
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb.cfm @ 22:12:18.018
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4770 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 22:12:18.018
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 4770 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getlivingintro (Datasource=expert, Time=7ms, Records=1) in /home/www/html/breadcrumb.cfm @ 22:12:18.018
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 101 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
    and sectionintro = 'y'
   and articleCategories.section = '6'
    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-30"

    ORDER by articles.articleID asc   
    
getnatadcount (Datasource=expert, Time=1ms, Records=48) in /home/www/html/lib_rd.cfm @ 22:12:18.018
SELECT tag
FROM natadoptions 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd_readnext.cfm @ 22:12:18.018
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4770 
gettaxgeneral (Datasource=expert, Time=6ms, Records=4) in /home/www/html/lib_rd_readnext.cfm @ 22:12:18.018
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 101 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and articles.articleID <> 4770
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-30"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 22:12:18.018
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=13ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 22:12:18.018
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 22:12:18.018
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-05-29 22:12:18'}
    and fromDate <{ts '2020-05-30 22:12:18'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=14ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 22:12:18.018
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 22:12:18.018
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 4770 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 22:12:18.018
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4770 
checkculturefeature (Datasource=expert, Time=9ms, Records=2) in /home/www/html/navcontentbox.cfm @ 22:12:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 101 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:12:18.018
		Select summary, hiimg 
		FROM answers
         where answerid = 76449
         and summary <> ''
checklivingfeature (Datasource=expert, Time=8ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:12:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 101 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:12:18.018
		Select summary, hiimg 
		FROM answers
         where answerid = 75819
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 22:12:18.018
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 101 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-30"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:12:18.018
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-30"
     
         and rptarticlenetworks.networkid = 101 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 22:12:18.018
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 10
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 22:12:18.018
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 101 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:12:18.018
SELECT  hiimg
FROM rptarticles
where rptarticleID = 10
and hiimg <> ''


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=4770&networkid=101
REMOTE_ADDR=173.245.54.69
REMOTE_HOST=173.245.54.69
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=28727600
cftoken=17385328
sessionid=IBEXPATEXCHANGE.COM_28727600_17385328
urltoken=CFID=28727600&CFTOKEN=17385328
URL Parameters:
articleID=4770
networkid=101
Debug Rendering Time: 10 ms