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

Portugal Expat Forum

letter from doctor

Post New Topic
karen9093
4/8/2017 19:39 EST

Hi, All - I am applying for a residency visa and I have a question about the letter from the doctor that says one is in "good health". I did not see my question answered elsewhere - including Susan Korthase's wonderful set of instructions - so I apologize if it has been answered on the Forum already.

What does "in good health" mean? If one has high blood pressure or high cholesterol, is that ok? I imagine I can get the health insurance required, but understand that a letter from a doctor will also be asked for at some point.

Any tips much appreciated! - Karen

Post a Reply

00abuse

jm27746
4/8/2017 22:17 EST

I just applied and got approved through the DC embassy and we didn't need a letter of good health. Apparently they don't need it anymore but I would ask your specific embassy.

Post a Reply

00abuse

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.

Get a Quote

karen9093
4/9/2017 15:14 EST

Ah - interesting - thanks for the tip. I will be going to the Boston embassy, so will ask them.

Post a Reply

00abuse

craigandmicki
4/10/2017 12:13 EST

Karen: You should ask your current US physician for (a) a list of all prescriptions you are currently taking, with both generic and Latin names, as well as how much, how often. This gives you immediate access to all your scrips at any PT farmacia. Second, ask your physician for a statement of health--whatever conditions you have should be noted. This letter might be requested at SEF and / or your health insurer.

Post a Reply

10abuse

karen9093
4/11/2017 09:16 EST

Thanks, Craigandmicki - I will definitely be getting a list of my meds. As far as the letter goes (which I will get for the SEF, just to be cautious), do you know if people with particular health conditions get turned away from residency? I take meds for things like a thyroid condition and an autoimmune problem, but both conditions are totally managed by the scrips. Thanks!

Post a Reply

00abuse

Sixyears
4/11/2017 17:22 EST

Do they turn people away with health problems? Never heard that before

Post a Reply

00abuse

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.

Get a Quote

Yummmmmyme
4/11/2017 17:37 EST

I've never heard of needing a letter like this either, but you will want one for your medical care here so it won't hurt to have one.
Something I wasn't aware of is that there are some substantial differences in which medications are available here. For example, they have codeine cough syrup over the counter, but no sumatriptan for migraines. They also don't have extended release formulas in many drugs. They don't prescribe opioids (like Vicodin) outside of the hospital. If you have meds you need to take, you might want to do a little research on substitutions (or stock up there). I also recently learned that different pharmacies here carry different meds and brands of meds, so it's good to check a couple places.

Post a Reply

10abuse

karen9093
4/12/2017 09:36 EST

Those are helpful tips - thanks!

Post a Reply

00abuse

craigandmicki
4/13/2017 13:20 EST

To karen9093's question about what health conditions can cause you to be rejected: The SEF believes that a contagious disease can be cause for denial, but they would not deny you for lower-level chronic illnesses such as high blood pressure, thyroid, GI / reflux, diabetes, etc.

Post a Reply

00abuse

AnalogKid84
9/29/2017 18:50 EST

Can anyone who's done this explain how they got the letter from their doctor? I asked mine today, and they said they didn't issue them, but maybe if there was a specific form for them to fill out, maybe they could do that. Which kind of makes sense to me, considering how vague and open-ended a "letter of health" is from the perspective of one who's asked to write it.

Did you have to provide some sort of form or pre-printed letter to your doctor for them to fill out and sign? Thanks.

Post a Reply

00abuse

karen9093
10/2/2017 13:57 EST

All I got was a letter from my doctor on the clinics' letterhead that said - in one sentence - that I was in good health (despite having some chronic conditions that need regular meds) and that I am free from communicable diseases. No one blinked an eye on the stateside; awaiting an SEF appointment in February. But, as many long-timers here have suggested, this may be a non-issue. On the other hand, as it was listed on the requirements for application, it doesn't hurt to be on the safe side.

Post a Reply

10abuse

AnalogKid84
10/16/2017 19:42 EST

Karen, you say long-timers say it may be a non-issue. Could you explain that more? Are some people not asked for it at SEF?

I'm asking because I can't find it listed anywhere as a requirement by SEF. Granted, that doesn't mean anything and they may certainly require it ... but if there's a chance they won't, I might wait until I'm in Portugal to see if it's required since my doctor is asking for $100 to print such a statement on letterhead.

(I'm a new patient, so he's probably just charging because he thinks he can and has no reputation to lose with me by asking.)

Post a Reply

00abuse

karen9093
10/27/2017 06:55 EST

Hi - I was just repeating what was said above by more knowledgeable people :) The Boston consulate listed such a statement as one of their requirements. It sounds like this may not be true of all consulates. And my doctor did not charge me a penny!

Post a Reply

00abuse

Expatriate Health Insurance

Get a quote for expat health insurance in Portugal.

International Moving Companies

Moving to Portugal? Get a moving quote.


Mail Forwarding to Portugal

Mail Forwarding to Portugal.


Expat Tax

Expat Tax Preparation, Expat Tax Professionals

Join Today (free)

Join Expat Exchange to meet expats in your area or get advice before your move. It's FREE and takes 1 minute!

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 /expat/index.cfm
Time Stamp 30-May-20 05:47 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.151
Host Name 173.245.54.151


Execution Time

Total Time Avg Time Count Template
123 ms 123 ms 1 /home/www/html/expat/Application.cfm
63 ms 63 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
63 ms 63 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
62 ms 62 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
37 ms 37 ms 1 /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm
29 ms 29 ms 1 /home/www/html/expat/messages_rdesign5.cfm
23 ms 23 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
20 ms 20 ms 1 /home/www/html/expat/message_rdesign5.cfm
14 ms 14 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
8 ms 1 ms 13 /home/www/html/navvote_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/navtop_rdesign5.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/bottomnav_rdesign5.cfm
1 ms 0 ms 13 /home/www/html/expat/common/formatmsg.cfm
1 ms 1 ms 1 /home/www/html/expat/constants.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_GeneralSet.cfm
1 ms 1 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/expat/copyright.cfm
0 ms 0 ms 1 /home/www/html/expat/datasources.cfm
0 ms 0 ms 1 /home/www/html/expat/ibkey.cfm
0 ms 0 ms 1 /home/www/html/expat/ibstyle.cfm
0 ms 0 ms 1 /home/www/html/expat/index.cfm
0 ms 0 ms 1 /home/www/html/expat/instaboard.cfm
0 ms 0 ms 1 /home/www/html/expat/navforumads_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_DesignSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GetCategory.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GetModerators.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign4.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
123 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GeneralSet.cfm @ 05:47:37.037
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=4ms, Records=1) in /home/www/html/expat/Application.cfm @ 05:47:37.037
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 05:47:37.037
	Select *
	From Networks
	Where frmid = 278 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:47:37.037
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:47:37.037
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 92 
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:47:37.037
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 278 
getcities (Datasource=expert, Time=1ms, Records=6) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:47:37.037
	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/navmetaforums_rdesign5.cfm @ 05:47:37.037
  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
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:47:37.037
	Select *
	From Networks
	Where networkID = 92 
GetTopicTitle (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:47:37.037
  SELECT f.frmid as frmid, frmname, t.tpcname, m.msgtext, t.urlchanged, t.tpcrewriteurl, t.section, t.citynetworkid, t.tpcnamenew, t.summary, t.keywords, m.msgid
  FROM forums f, topics t, messages m  
  WHERE f.frmid = 278 
  AND t.tpcid = 3420969 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
  AND t.tpcid = m.tpcid
  AND m.msgparent = 0
GetTopicInformation (Datasource=forum, Time=4ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:47:37.037
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext as msgintro, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.userid, u.userid, u.username, t.msgcount-1 as replycount, topicimage, topicimageapproved
  FROM messages m, users u, topics t
  WHERE m.tpcid = 3420969
  and  t.tpcid = 3420969
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=1ms, Records=56) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:47:37.037
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 92
	order by lastsent ASC
GetTopicInformation (Datasource=forum, Time=3ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:47:37.037
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext as msgintro, m.msgparent, m.msghost, m.msgdate, m.msgupdate, t.tpcupdate, m.replylevel, m.userid, u.userid, u.username, t.msgcount-1 as replycount, topicimage, topicimageapproved
  FROM messages m, users u, topics t
  WHERE m.tpcid = 3420969
  and  t.tpcid = 3420969
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=0ms, Records=56, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:47:37.037
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 92
	order by lastsent ASC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 05:47:37.037
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.151'
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 @ 05:47:37.037
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.151'
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=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 05:47:37.037
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.151'
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 @ 05:47:37.037
	SELECT *
	From contentcountcountry
	Where networkid = 92 
gettopbanner (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 05:47:37.037
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 05:47:37.037
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 05:47:37.037
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
GetNavigator (Datasource=forum, Time=0ms, Records=1) in /home/www/html/expat/Application.cfm @ 05:47:37.037
  SELECT catid, allowattach, isreviewed, isprivate, f.frmid as frmid, frmname, frmdesc, frmorder, frmpass, frmnotice, isapproved, f.isclosed as frmclosed, tpcname, tpcid, t.isclosed as tpcclosed, ispoll, isreviewed
  FROM forums f, topics t  
  WHERE f.frmid = 278 
  AND tpcid = 3420969 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
GetModerators (Datasource=forum, Time=0ms, Records=0) in /home/www/html/expat/queries/qry_GetModerators.cfm @ 05:47:37.037
  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 278
  AND u.userdbname = "ee"
  ORDER BY u.username
GetCategory (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GetCategory.cfm @ 05:47:37.037
  SELECT *
  FROM categories
  WHERE catid = "2"
DesignSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 05:47:37.037
  SELECT * FROM designset
  WHERE designsetid = 11 
GetFirstMessage (Datasource=forum, Time=4ms, Records=1) in /home/www/html/expat/messages_rdesign5.cfm @ 05:47:37.037
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.attachment, m.attachsize, m.updateuser, m.usesmilies, m. usesignature, m.isapproved, m.isdeleted, topics.isclosed, m.tpcid, m.userid, m.dbname, u.userid, u.usericon, u.username, u.useremail, u.userdbname, u.usertitle, u.isactive, u.signature, u.location, u.totalposts, u.userdate, u.allowpm, u.showicq, u.icqnumber, forums.frmid, topics.tpcid, topics.frmid, forums.dbname, m.guestname, m.guestemail, m.report, m.good, m.bad, topics.tpcname, forums.frmname, messageimage, messageimageapproved
  FROM messages m, users u, forums, topics  
  WHERE m.tpcid = 3420969
  AND m.userid = u.userid
  AND topics.tpcid = 3420969
  AND forums.frmid = topics.frmid
  AND forums.dbname = "ee"
  AND m.isapproved = 1
  AND m.msgparent = 0
  AND m.isdeleted <> 1
GetMessages (Datasource=forum, Time=4ms, Records=12) in /home/www/html/expat/messages_rdesign5.cfm @ 05:47:37.037
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.attachment, m.attachsize, m.updateuser, m.usesmilies, m. usesignature, m.isapproved, m.isdeleted, topics.isclosed, m.tpcid, m.userid, m.dbname, u.userid, u.usericon, u.username, u.useremail, u.userdbname, u.usertitle, u.isactive, u.signature, u.location, u.totalposts, u.userdate, u.allowpm, u.showicq, u.icqnumber, forums.frmid, topics.tpcid, topics.frmid, forums.dbname, m.guestname, m.guestemail, m.report, m.good, m.bad, messageimage, messageimageapproved
  FROM messages m, users u, forums, topics  
  WHERE m.tpcid = 3420969
  AND m.userid = u.userid
  AND topics.tpcid = 3420969
    AND m.isdeleted <> 1
  AND forums.frmid = topics.frmid
  AND forums.dbname = "ee"
     AND m.msgparent <> 0
  AND m.isapproved = 1
   
    ORDER BY m.msgid ASC 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 420720
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 420720
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 05:47:37.037
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:47:37.037
	Select *
	From Networks
	Where networkid = 92 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:47:37.037
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=1ms, Records=2) in /home/www/html/nativerotationtop_tester13.cfm @ 05:47:37.037
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 92
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-05-29"
and natforumstart < "2020-05-30"
and natforumstatus = 'live'

and natforumweight = 'high'
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 420799
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 420799
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 420952
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 420952
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 421159
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 421159
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 421264
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 421264
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 05:47:37.037
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:47:37.037
	Select *
	From Networks
	Where networkid = 92 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:47:37.037
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=1ms, Records=2) in /home/www/html/nativerotationtop_tester13.cfm @ 05:47:37.037
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 92
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-05-29"
and natforumstart < "2020-05-30"
and natforumstatus = 'live'

and natforumweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:47:37.037
SELECT resourceid, natforum as adcode, natforumweight, natadid
FROM natads 
WHERE natadid = 1 
votecount (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 421270
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 421270
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 421343
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 421343
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 421612
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 421612
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 448858
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 448858
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 449144
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 449144
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 451209
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 451209
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 452791
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:47:37.037
SELECT vote
FROM votes
WHERE voteid = 452791
and vote = 'bad'
and liketype = 6 
getclasscheck (Datasource=tipripper, Time=25ms, Records=2) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 05:47:37.037
	SELECT answersphoto.photo, answersphoto.answerid, answersphoto.qid, answers.rid, allreports.networkname, allreports.networkid, allreports.city, allreports.state
	FROM answersphoto, answers, allreports 
	WHERE answersphoto.answerid = answers.answerid
	and allreports.answerid = answers.answerid
	and allreports.topicid = 6
	and allreports.hide <> 'y'
	and (answers.paid = 'yes' or answers.paid = 'free')
	AND answersphoto.qid = '104'
	AND allreports.networkid = 92
	AND "2020-05-30" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
getpropertyslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 05:47:37.037
SELECT *
FROM topics
WHERE topicid = 6
getclass (Datasource=tipripper, Time=23ms, Records=2) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 05:47:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid, answers.rid, allreports.networkname, allreports.networkid, allreports.city, allreports.state
	FROM answersphoto, answers, allreports 
	WHERE answersphoto.answerid = answers.answerid
	and allreports.answerid = answers.answerid
	and allreports.topicid = 6
	and allreports.hide <> 'y'
	and (answers.paid = 'yes' or answers.paid = 'free')
	AND answersphoto.qid = '104'
	AND allreports.networkid = 92
	AND "2020-05-30" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
getprice (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 05:47:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80700'
	AND answerstext.qid = 109
getbed (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 05:47:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80700'
	AND answerstext.qid = 113
getbath (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 05:47:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80700'
	AND answerstext.qid = 114
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 05:47:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '92'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 05:47:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80700'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 05:47:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80700'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 05:47:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80700'
AND answersmc.qoid = qoptions.qoid


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/expat/index.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/expat/index.cfm
QUERY_STRING=frmid=278&tpcid=3420969
REMOTE_ADDR=173.245.54.151
REMOTE_HOST=173.245.54.151
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expat/index.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Cookie Variables:
MS=flat
Session Variables:
cfid=28682463
cftoken=33712211
sessionid=IBEXPATEXCHANGE.COM_28682463_33712211
urltoken=CFID=28682463&CFTOKEN=33712211
URL Parameters:
frmid=278
tpcid=3420969
Debug Rendering Time: 10 ms