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

Living in Portugal >

How to Get Your First Residence Permit in Portugal

By Susan Stults Korthase

Last updated on: Jun 06, 2018

Summary: Wondering how to obtain your first residency permmit in Portugal? Susan Stults Korthase provides the information that you'll need to make it happen.

Portugal Residence Permit - How to Get Your First Residence Permit in Portugal

You've arrived in Portugal, ready to turn your Type 1 Visa (also called Type D in Portugal) into a Temporary Residence Permit or Titulo de Residencia. This article outlines the steps, timing and required documentation along with links to the official government sites and forms. Remember that the Type 1/D Visa allows unlimited travel in the Schengen zone and two trips to/back from the US during the 120 days for which it is valid. You can travel to non-Schengen countries as well; you simply must comply with the respective countries rules for entry. NOTE: This is the process you will follow for each renewal, until the 5th year application for a Permanent Residence Permit when you must also prove A2 level language skills.

Scheduling Your Appointment

Apply for your Temporary Residence Permit at the Serviço de Estrangeiros e Fronteiras (SEF) bureau that covers the area where you reside. The full list of bureaus is at the SEF Portal (see link in References at the end of this article). Due to the high volume of Residence Permit applications, the Serviço de Estrangeiros e Fronteiras (SEF) offices are currently (since mid-2015) asking that you book your initial appointment by calling their main customer service number. Call center hours are Monday-Friday from 09:00 a.m. to 05:30 p.m. The numbers are 808 202 653 (fixed network) or 808 962 690 (mobile network). These numbers can only be called from within Portugal.

  • The automated message is in Portuguese so either wait until the end of the message, when an English-speaking person will come on the line, or hand your phone to a Portuguese friend to navigate the menu for you.
  • Your appointment date might exceed the viability of your 120-day Visa. When this happens, the SEF sends you an email confirming the appointment (be certain to ask them to do that!). You are expected to print out that email and carry it with you, as it officially extends the duration of your 120-day Visa until that appointment.
  • When you go to SEF for your appointment, you will get a number and wait.... while the appointment itself takes less than an hour you might spend the entire day waiting, as many SEF offices give you an appointed time to get an appointment, not to meet with the official.

What to Bring with You

At the SEF website you will find a list of 10 documents to bring to your SEF appointment. That list is copied below along with "notes" if further explanation is helpful. At the end of this section are important links, in blue.

TEMPORARY RESIDENCE PERMIT (GENERAL REGIME, INCLUDING THE FOLLOWING CATEGORIES OF APPLICANTS: RETIRED / WITH OWN FINANCIAL INCOME /RELIGIOUS) (ARTICLE 77, PARAGRAPH 1 OF THE REPSAE (LEGAL FRAMEWORK ON THE ENTRY, PERMANENCE, EXIT AND REMOVAL OF FOREIGNERS FROM NATIONAL TERRITORY), IN CONJUNCTION WITH ARTICLES 51 AND 53 OF THE REGULATORY DECREE NUMBER 2/2013)

1. Application delivered personally (on a standard form) signed by the applicant (where the applicant is either a minor or legally disabled person the form shall be signed by his/her legal representative):

2. Two recent, identical photographs, in color with blank background and easily identifiable, except in SIGAP Service Bureaus. NOTE: At the SEF site, the SIGAP Service Bureaus are noted as such. These bureaus take your photo there.

3. Passport or any other valid travel document

4. Valid residence visa NOTE: This is the Visa that was inserted into your passport

5. Evidence of sufficient means of subsistence, as per the provisions of Order number 1563/2007, of 11/12. NOTE: This is the same evidence you provided for your Visa, however account statements should be no more than 3 months old and pension / social security income letters should be dated for the current year.

6. Evidence that the applicant has adequate accommodation NOTE: Provide your rental contract, hotel booking or home purchase contract. The address on the document you provide will be the address used on your Permit. If/when you move, you'll need to update your address at your local Junta da Freguesia (essentially a parish or city town hall) for a fee, taking their validation letter within 30 days to your SEF and paying a fee for new cards. When you are close to the date of a renewal, SEF usually asks you to simply wait until that renewal appointment and change your address then because they are currently too busy to accept simple address changes. If you fail to update your address within 60 days of a change you will be charged a late fee.

7. Permission for checking criminal records (see standard form)- (except people under 16 years old) NOTE: Your signature on the Application form, number 1 above, is permission for checking with the Portuguese Police to ensure your criminal record is clean since arriving in Portugal. There is no separate form for this and it does not refer to any US records, such as the FBI report.

8. A document attesting to the existence of a family relationship, where applicable NOTE: applicable when moving to Portugal to reunite with family and includes birth and/or marriage certificates as applicable

9. Document proving the applicant's tax situation, where applicable. NOTE: This has nothing to do with the US IRS... it's just your NIF number if you have already received one. SEF enters your NIF into the system to detect any fines or unpaid fees.

10. Document proving that the applicant is registered with the Social Security. NOTE: The phrase ‘social security’ refers to the national health plan. As a Type 1/D Visa holder, you must have private health insurance. You need to provide your proof of private health insurance and proof of payment. This is usually a one-page document with your name, dates the policy is effective and policy coverage amounts.

Expats living in Portugal 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 Portugal interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA.

Sticky Points

Be prepared for someone to ask you for more documentation than is officially required. Respectfully providing what you can, respectfully declining what isn't necessary--so therefore you don't have it--are appropriate responses. I recommend taking a print-out of the SEF Required Documentation with you to indicate that you've come prepared according to their specific requirements.

  • Some applicants have been told by other applicants or even by their SEF official that a new FBI report is required. That isn't correct. Perhaps the applicants misunderstand what is asked for in point 7, above. At this stage, the FBI report has done what it needed to do, which is get you your Schengen Visa. You can bring a copy of that original FBI report with you as a pre-emptive measure but don't let that derail your appointment.
  • Some applicants have been asked for Birth Certificates, Marriage Certificates and/or IRS reports. You can have your birth and marriage certificates with you, and in fact I've always recommended that applicants bring a copy of all of their original Visa application documents with them. However, "IRS" doesn't mean the United States 1040 filing. This is never necessary with the SEF. "IRS" means the Portuguese IRS; at this point, you won't have filed taxes with the IRS and might not yet have your NIF number. [If you do have your NIF, provide that so it's included on your Residence Permit card. Note that the SEF can enter your NIF number into their system and determine your status with the Financas office.]

You should be able to complete the process and be told you are approved at this appointment. If you fail to bring any required documentation, you will have to make another appointment and return. This rarely happens, usually only to applicants who aren't clear, firm and convinced of what they are doing or who don't follow instructions. You can pay your fees in cash or with a Portuguese bank card (Multibanco) but not with a credit card.

The Titulo Card is sent to your address or your post office might send you a notice to come pick it up, and it arrives within a couple of weeks. It has photo, name and address.

expat health insurance from CIGNA

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

Learn More Get a Quote

Further Renewals

You will renew your Titulo de Residencia 30 days prior to each expiration...or you will try to, yet back logs are pushing out the renewals depending on how busy your SEF office is. The first Titulo de Residencia expires after one year, followed by two, two-year renewals and a final renewal at 5 years that can be a Permanent Residence card if you meet the language requirements. Otherwise, you continue to renew for two-year periods. You are limited as to how much time you can be away from Portugal during your temporary residence cycles. Absences from Portugal for periods of less than six consecutive months during the validity period of any residence permit (and not exceeding ten months in total within the five-year period) or for specific reasons provided for by national law (e.g. military service, secondment for work purposes, serious illness, maternity, research or studies) will be regarded as not interrupting the period of residence.

References:

Moving to Portugal 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 Portugal 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

Susan moved to Portugal in 2010 following a career in international human resources and consulting. As CEO of Communications Matters, Susan has completed many writing, project management and website optimization projects from the sunny home in Cascais that she shares with freelance photographer husband Craig. Her articles have appeared in the Wall Street Journal, Newsweek, International Living and on several blogs.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Join our Portugal Expat Forum

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

More about Portugal

Demystifying-the-Paper-Trail

United States Citizens Moving to Portugal: Demystifying the Paper Trail

Thanks to Susan Stults Korthase for this helpful overview of current requirements to begin the process of obtaining a Residency Visa when moving from the US to Portugal. Note: Information Updated December 2018.

Thanks to Susan Stults Korthase for this helpful overview of current requirements to begin the process of obtaining a Residency Visa when moving from the US to Portugal. Note: Information Updated Dece...

5-Best-Places-to-Retire-in-Portugal

5 Best Places to Retire in Portugal

Expat retirees love Portugal for its welcoming people, gorgeous beaches, quaint towns and wonderful restaurants. In this article, we cover 5 great places to retire in Portugal.

Expat retirees love Portugal for its welcoming people, gorgeous beaches, quaint towns and wonderful restaurants. In this article, we cover 5 great places to retire in Portugal. ...

The-8-Best-Countries-for-Brits-to-Retire-Abroad

The 8 Best Countries for Brits to Retire Abroad

Many Brits choose to retire to Australia and the United States. In addition to these popular locales, Ryan Smith recommends several other great retirement destinations for British retirees.

Many Brits choose to retire to Australia and the United States. In addition to these popular locales, Ryan Smith recommends several other great retirement destinations for British retirees....

Renewing-Your-Portuguese-Residence-Permit

Renewing Your Portuguese Residence Permit

Expats in Portugal need to periodically renew their residence permit. Susan Stults Korthase offers up the information you'll need to get it done.

Expats in Portugal need to periodically renew their residence permit. Susan Stults Korthase offers up the information you'll need to get it done....

5-Tips-for-Living-in-Cascais,-Portugal

5 Tips for Living in Cascais, Portugal

Expats in the beautiful seaside city of Cascais, Portugal discuss how they chose to move to Cascais. They share information about expat life in Cascais - cost of living, international schools, housing and more.

Expats in the beautiful seaside city of Cascais, Portugal discuss how they chose to move to Cascais. They share information about expat life in Cascais - cost of living, international schools, housin...

5-Neighborhoods-to-Consider-in-Lisbon,-Portugal

5 Neighborhoods to Consider in Lisbon, Portugal

There are a lot of options when picking a neighborhood in Lisbon. Find a few of the many possibilities for living and just exploring.

There are a lot of options when picking a neighborhood in Lisbon. Find a few of the many possibilities for living and just exploring....

5-Tips-for-Living-in-Lisbon,-Portugal

5 Tips for Living in Lisbon, Portugal

Expats living in Lisbon, Portugal enjoy a historic cross-roads that has become an economic hub in Western Europe. Expats from all over the world enjoy the Mediterranean climate and diversity of people and culture.

Expats living in Lisbon, Portugal enjoy a historic cross-roads that has become an economic hub in Western Europe. Expats from all over the world enjoy the Mediterranean climate and diversity of peopl...

Lisbon,-Portugal

Lisbon, Portugal

Lisbon is the capital and largest city in Portugal, which is one of the most popular countries for expats in Europe. You'll find basic information to help you get acquainted with Lisbon and what it has to offer.

Lisbon is the capital and largest city in Portugal, which is one of the most popular countries for expats in Europe. You'll find basic information to help you get acquainted with Lisbon and what it h...

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Comments about this Article

KevinfromKinsaleviaNYC
Jul 6, 2016 11:19

Susan, thanks for your helpful article. I am thinking of purchasing a house in Portugal in order to qualify for a "golden visa". A new policy lowers the required purchase price to €350,000 if the house is more than 30 years old or located in "urban regeneration areas". Do you happen to know where to find such investments and whether they are popular? Also, can you tell me if I can qualify for a Schengen Visa without qualifying for a Portuguese passport? I desire to move to Europe with the full freedom to move freely throughout. Thanks in advance. Kevin

enuzzijr1
Jul 29, 2016 04:52

BE PATIENT! Bring someone that speaks LOCAL Portuguese to help you. I used the professional translation services from a Brazilian born person and we were faced with a barrage of PREJUDICIAL REMARKS! Interesting to say the least ):

bcartmill
Nov 22, 2016 12:47

Does anyone know of a attorney in Portugal that can help us through the process of getting our Temporary Residence Permit or Titulo de Residencia. Thank you

RobertEaston
Mar 3, 2017 10:53

My wife is Canadian, I have British and Canadian citizenship. How would this affect a residency application? Does one us being British (and consequently have, at the moment, free access to the EU) have any effect? Thank you

Fortune80
Jan 24, 2018 09:04

Thank you for this article. I have made it to Part 2, and I have an appointment confirmation email from SEF in Lisbon. I went to SEF to make the appointment in October, and the appointment date is for July. My US visitor visa expires in February, and with a 5-month span of time between the expiration and the appointment, I am concerned about staying here based on an email print-out. Can I leave Portugal and regain entry? Do I need to go somewhere for 3 month? Or can I just sit-tight here in Lisbon? I would prefer not to leave, because that would be another expense I did not plan for in the time this process has taken. Thank you in advance for any opinion you might have.

Updated On: Jun 06, 2018

First Published: Jun 29, 2016

Cigna Expat Health InsuranceExpatriate Health Insurance

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

9-Expats-Talk-About-What-Its-Really-Like-Living-in-Portugal9 Expats Talk About What It's Really Like Living in Portugal

With it's beautiful beaches, historic cities, lower cost of living and welcoming Portuguese people, Portugal continues to be a popular expat destination. 9 expats talk about what it's really like living in Portugal.
With it's beautiful beaches, historic cities, lower cost of living and welcoming Portuguese people, Portugal continues to be a popular expat destination. 9 expats talk about what it's really like liv...

Expat-Portugal10 Tips for Living in Portugal

Expats in Portugal enjoy the Portuguese lifestyle, the beautiful landscapes, and the variety of places to visit and live. Find information about where to live, health care, residency visas and more as you delve into how to live well in Portugal.

Expats in Portugal enjoy the Portuguese lifestyle, the beautiful landscapes, and the variety of places to visit and live. Find information about where to live, health care, residency visas and more a...

Retiring-Abroad5 Great Places to Retire in Western Europe

We asked expats about great places to retire in Western Europe. While many Western European countries have prohibitively high living costs, there are a few areas that fit the retirement bill. These are some of the recommendations!

We asked expats about great places to retire in Western Europe. While many Western European countries have prohibitively high living costs, there are a few areas that fit the retirement bill. These ...

Expats-in-Portugal5 Best Places to Retire in Portugal

Expat retirees love Portugal for its welcoming people, gorgeous beaches, quaint towns and wonderful restaurants. In this article, we cover 5 great places to retire in Portugal.

Expat retirees love Portugal for its welcoming people, gorgeous beaches, quaint towns and wonderful restaurants. In this article, we cover 5 great places to retire in Portugal. ...

Retirement-In-CascaisAn Expat Shares What it's Like Retiring in Cascais, Portugal

Here is a wonderful, detailed report about what it's like to retire in Portugal. Written by a woman with dual US/Dutch citizenship, she has left no stone unturned!

Here is a wonderful, detailed report about what it's like to retire in Portugal. Written by a woman with dual US/Dutch citizenship, she has left no stone unturned!...

Moving-To-PortoAn Expat Talks about Moving to Porto, Portugal

An expat talks about moving to Porto, Portugal - moving costs, renting a condo, the lower cost of living in Porto and more.

An expat talks about moving to Porto, Portugal - moving costs, renting a condo, the lower cost of living in Porto and more....

Portugal 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 12-Jul-20 05:56 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.79.9
Host Name 162.158.79.9


Execution Time

Total Time Avg Time Count Template
104 ms 104 ms 1 top level /home/www/html/lib_rd.cfm
29 ms 29 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
28 ms 28 ms 1 /home/www/html/navcontentbox.cfm
28 ms 28 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
20 ms 20 ms 1 /home/www/html/lib_rd_ctrygd_readnext.cfm
11 ms 11 ms 1 /home/www/html/navtop_rdesign5.cfm
10 ms 10 ms 1 /home/www/html/commentsnew_rdesign4.cfm
7 ms 7 ms 1 /home/www/html/breadcrumb.cfm
6 ms 6 ms 1 /home/www/html/navleader_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/Application.cfm
5 ms 2 ms 3 /home/www/html/nativerotationtop_tester13.cfm
3 ms 3 ms 1 /home/www/html/navbottomad_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmpu_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/natad/native_4776_80555.txt
1 ms 0 ms 14 /home/www/html/rewritearticle.cfm
1 ms 1 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereport.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/datasources.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
110 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 @ 17:56:09.009
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 17:56:09.009
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 17:56:09.009
	Select *
	From articles
	Where articleID = 4776
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 17:56:09.009
	Select *
	From sponcers
	Where sponcerID = 454 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 17:56:09.009
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 4776 
	and articles.articleID = 4776 
	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 @ 17:56:09.009
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 4776
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 4776
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 17:56:09.009
	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 @ 17:56:09.009
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 92 
getcities (Datasource=expert, Time=0ms, Records=6, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 17:56:09.009
	Select *
	From citynetworks
	Where networkID = 92
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 17:56:09.009
  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
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 17:56:09.009
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4776 
commentcount (Datasource=forum, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 17:56:09.009
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 4776 
  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 @ 17:56:09.009
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-04-12"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 17:56:09.009
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-07-12 00:00:00.000"
and logtime < "2020-07-12 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 @ 17:56:09.009
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-07-05"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 17:56:09.009
	SELECT *
	From contentcountcountry
	Where networkid = 92 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 17:56:09.009
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-11"
    and fromDate < "2020-07-12"
UpdatePageViews (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 17:56:09.009
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 17:56:09.009
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 4776 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getlivingintro (Datasource=expert, Time=5ms, Records=0) in /home/www/html/breadcrumb.cfm @ 17:56:09.009
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 92 
	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-07-12"

    ORDER by articles.articleID asc   
    
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 17:56:09.009
SELECT tag
FROM natadoptions 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:56:09.009
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:56:09.009
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:56:09.009
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 92
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-11"
and natsentencestart < "2020-07-12"
and natsentencestatus = 'live'

and (natsentenceweight = 'medium' or natsentenceweight = 'high')
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:56:09.009
SELECT *
FROM natadoptions 
WHERE 'hibox' = tag
getnatadtype (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:56:09.009
SELECT *
FROM natadoptions 
WHERE natadtypeid = 4 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:56:09.009
SELECT resourceid, natbox as adcode, natboxweight, natads.natadid
FROM natads, natadPlacement
WHERE natboxtype = 4
and natadPlacement.networkID = 92
and natadPlacement.natadid = natads.natadid
and natboxend > "2020-07-11"
and natboxstart < "2020-07-12"
and natboxstatus = 'live'

and natboxweight = 'high'
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:56:09.009
SELECT resourceid, natbox as adcode, natboxweight, natadid
FROM natads 
WHERE natadid = 46
and natboxtype = 4 
getnatadtopull (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:56:09.009
SELECT *
FROM natadoptions 
WHERE 'movesentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:56:09.009
SELECT *
FROM natadoptions 
WHERE natadtypeid = 7 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:56:09.009
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 7
and natadPlacement.networkID = 92
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-11"
and natsentencestart < "2020-07-12"
and natsentencestatus = 'live'

and (natsentenceweight = 'medium' or natsentenceweight = 'high')
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 17:56:09.009
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4776 
gettaxgeneral3 (Datasource=expert, Time=6ms, Records=4) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 17:56:09.009
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 92 
	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 <> 4776
    and publishdate < "2020-07-12"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettaxgeneral4 (Datasource=expert, Time=9ms, Records=4) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 17:56:10.010
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articlecityplace
	Where hitopic <> ''
	and articlePlacement.networkID = 92 
	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 <> 4776
    and publishdate < "2020-07-12"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navbottomad_rdesign5.cfm @ 17:56:10.010
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-11"
    and fromDate < "2020-07-12"
    and bannerPlacement.networkid = 92
    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 @ 17:56:10.010
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 17:56:10.010
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-07-11 17:56:10'}
    and fromDate <{ts '2020-07-12 17:56:10'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 17:56:10.010
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=5) in /home/www/html/commentsnew_rdesign4.cfm @ 17:56:10.010
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 4776 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 17:56:10.010
  SELECT *
  FROM users
  WHERE userid = 148812 
GetUser (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 17:56:10.010
  SELECT *
  FROM users
  WHERE userid = 162102 
GetUser (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 17:56:10.010
  SELECT *
  FROM users
  WHERE userid = 138950 
GetUser (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 17:56:10.010
  SELECT *
  FROM users
  WHERE userid = 181003 
GetUser (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 17:56:10.010
  SELECT *
  FROM users
  WHERE userid = 206105 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 17:56:10.010
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4776 
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 17:56:10.010
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-12"
     
         and rptarticlenetworks.networkid = 92 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 17:56:10.010
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 30
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 17:56:10.010
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 92 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 17:56:10.010
SELECT  hiimg
FROM rptarticles
where rptarticleID = 30
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=3) in /home/www/html/navcontentbox.cfm @ 17:56:10.010
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 92 
	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-07-12"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 17:56:10.010
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 92 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 17:56:10.010
		Select summary, hiimg 
		FROM answers
         where answerid = 75637
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 17:56:10.010
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 92 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 17:56:10.010
		Select summary, hiimg 
		FROM answers
         where answerid = 76515
         and summary <> ''


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/lib_rd.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.expatexchange.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/home/www/html/lib_rd.cfm
QUERY_STRING=articleID=4776&networkid=92
REMOTE_ADDR=162.158.79.9
REMOTE_HOST=162.158.79.9
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=31777273
cftoken=95779028
sessionid=IBEXPATEXCHANGE.COM_31777273_95779028
urltoken=CFID=31777273&CFTOKEN=95779028
URL Parameters:
articleID=4776
networkid=92
Debug Rendering Time: 13 ms