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

Costa Rica Expat Forum

Residency as an investor?

Post New Topic
PuraVida
10/15/2018 11:43 EST

If an expat buys a home for $350,000 and applies for residency as an investor, how much will the CAJA charge each month?

Post a Reply

00abuse

Kohl
10/15/2018 12:32 EST

Investor and Rentista premiums are much higher than for a Pensionado, And even more so, if one is under 55.

Unfortunately, you won't know what your premium will be until the final step of the application process.

http://www.usexpatcostarica.com/arcr-rate-hike-for-caja-plan/

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

princzz
10/15/2018 14:10 EST

No one no matter age will know until the final meeting.

Post a Reply

00abuse

princzz
10/15/2018 14:24 EST

According to this amount, and depending on the questions at time of enrollment, or will be 7.8 to 11.1% of your income v dependents and expenses.

Post a Reply

00abuse

Kohl
10/15/2018 16:18 EST

Although CCSS staff may ask a few questions about expenses, when you own a house, they won't give you a reduction. Neither will having car expenses, cable, etc. as these are not 'necessities.'

A friend who recently lost her husband, recently signed up as a 'single' and no longer a 'dependant' with a very low pension and even though she told them her rent, she had no reductions at all.

Post a Reply

00abuse

Zack59
10/16/2018 13:05 EST

May US health care expenses such as Medicare supplements be considered for reductions?

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

Kohl
10/16/2018 14:57 EST

No. Neither will private health insurance here.

Very few expenses will be considered. Rent, electricity and food are they costs they may ask about...but please don't count on the premiums to be lowered.

I've never actually met anyone that has had their premium lowered...8-(

Post a Reply

00abuse

carolvaughn
10/16/2018 15:05 EST

I had my premium lowered just a little
when I turned 65, officially retired, and
brought them documents proving it.
I was paying close to $300 in US for
health insurance, and pay $52 here.
Good health care, also. Health care is
a MUCH better deal here than in US.

Post a Reply

00abuse

shermanwc
10/16/2018 15:56 EST

My wife and I obtained Rentista residency and applied for CAJA, in 2013, when in our early 60s. We reported our income as $2500/month and completed a form with living expense categories such as rent, utilities, food, health care, etc. We were given a very low CAJA rate (well under $100). But I've heard of others that were given much higher rates. Unfortunately it seems to depend upon your location and who you get to review your application and set the rate. There is no way to be sure in advance!

Post a Reply

00abuse

shermanwc
10/16/2018 16:02 EST

We know a young couple that applied under Investor status and were given a very high CAJA rate (over $400/month). Most of their investment money went into starting some businesses in CR, and their monthly income was not very high. They were very upset that the CAJA rate they got seemed to be based on the value of money invested rather than their actual income from the businesses.

Post a Reply

00abuse

Kohl
10/16/2018 17:19 EST

" They were very upset that the CAJA rate they got seemed to be based on the value of money invested" and that is exactly how they, the CAJA, decide on the premium,

Of course, if under 55, the premiums are even higher. The more expensive the property, the more the 'Investor' pays. I have heard from many sources about the $400+ premiums...and some have 'bailed out' at the last moment. When the property is valued over the $200k they could then find themselves having to pay an additional, annual 'luxury tax'. Just like Manitoba Premier Brian Pallister found out. 8-)

We applied as 'Rentistas' before these 'new rules' cam into effect. I doubt they will be lowered. Canadians get the 'double whammy' with the low dollar and for some, if they have became a 'non-resident for tax purposes' and had their Canadian funds withheld.

Some new residents choose to join the ARCR group plan, if only because they know in advance what their premium will be, if only because they know in advance what their premium will be.

www.arcr.net

https://www.theglobeandmail.com/canada/article-manitoba-premier-brian-pallister-pays-8000-in-back-taxes-and/

Post a Reply

00abuse

princzz
10/16/2018 18:08 EST

That's "Your friend." It all depends on the agent in front of you....there is supposed to be set rules...but no.

Post a Reply

00abuse

k8esdad
7/22/2019 10:43 EST

My wife and I attended Chris Howard's program last December (www.liveincostarica.com). The 1st 3 days was a presentation by ARCR. They brought in legal, financial, insurance, dental, logistics (and other) experts. It appears to me that, in order to get a fair shake with CAJA (and other things Costa Rican), you should probably engage professionals (these being vetted by ARCR gives them more credibility). Even though a lot of things CAN be diy, having a local take care of it for you will be worth far more than their fee. (There was one individual that was not being treated fairly by the CAJA administrator where she lived and the expert there had a solution ready for her.)

Post a Reply

00abuse

peter2017
7/22/2019 19:41 EST

Under rentista category we are paying 118 thousand colones and some change.

Under the investor category you will pay more.

Post a Reply

00abuse

Kohl
7/22/2019 22:17 EST

Your age will determine what you will pay. If the principal is 55 and under, you may end up pay twice what a 55+ will pay. This 'usually' applies to both Investor and Rentista applicants... tut the more expensive the property the higher your monthly premium will be.

Unfortunately, what an expert is CAJA says they can do, it really depends on the person in the CAJA office that you are dealing with.

Post a Reply

00abuse

Expatriate Health Insurance

Get a quote for expat health insurance in Costa Rica.

International Moving Companies

Moving to Costa Rica? Get a moving quote.


Mail Forwarding to Costa Rica

Mail Forwarding to Costa Rica.


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!

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Top-5-Reasons-Expats-Move-to-Central-AmericaTop 5 Reasons Expats Move to Central America

From lower cost of living to affordable healthcare and beachfront living, expats discuss the top reasons they moved to Central America.
From lower cost of living to affordable healthcare and beachfront living, expats discuss the top reasons they moved to Central America....

Expat-Costa-Rica10 Tips for Living in Costa Rica

Should you wear jeans and a t-shirt in San Jose? Did you know that one place may have twice the rain and be windy compared to another place 10km away? Read our 10 Tips for Living in Costa Rica for insights from expats who have been there and done that.

Should you wear jeans and a t-shirt in San Jose? Did you know that one place may have twice the rain and be windy compared to another place 10km away? Read our 10 Tips for Living in Costa Rica for i...

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

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

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

Expats-Living-in-San-Jose,-Costa-Rica5 Tips For Living in San Jose, Costa Rica

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

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

Retirement-In-San-Isidro-de-HerediaAn Expat Shares What it's Like Retiring in San Isidro de Heredia, Costa Rica

Why retire in San Isidro de Heredia, Costa Rica? Can you live on $1,000 or $2,000 a month? How difficult is it if you aren't fluent in Spanish when you first arrive? A retiree who arrived in Costa Rica a month ago answers these and other questions.

Why retire in San Isidro de Heredia, Costa Rica? Can you live on $1,000 or $2,000 a month? How difficult is it if you aren't fluent in Spanish when you first arrive? A retiree who arrived in Costa ...

Moving-To-Playa-Hermosa-de-JacoAn Expat Talks about Moving to Playa Hermosa de Jaco, Costa Rica

An expat who has lived in Costa Rica gives all kinds of great advice on living there. Cost of housing, what to bring with you, how to settle in and much more is covered in this comprehensive expat report.

An expat who has lived in Costa Rica gives all kinds of great advice on living there. Cost of housing, what to bring with you, how to settle in and much more is covered in this comprehensive expat re...

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

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /expat/index.cfm
Time Stamp 29-May-20 07:34 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.62.46
Host Name 172.69.62.46


Execution Time

Total Time Avg Time Count Template
343 ms 343 ms 1 /home/www/html/expat/Application.cfm
61 ms 61 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
61 ms 61 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
60 ms 60 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
40 ms 40 ms 1 /home/www/html/expat/messages_rdesign5.cfm
31 ms 31 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
31 ms 31 ms 1 /home/www/html/navcontentbox.cfm
26 ms 26 ms 1 /home/www/html/expat/message_rdesign5.cfm
17 ms 17 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
10 ms 1 ms 15 /home/www/html/navvote_rdesign5.cfm
6 ms 6 ms 1 /home/www/html/navleader_rdesign5.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
2 ms 0 ms 15 /home/www/html/expat/common/formatmsg.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/expat/constants.cfm
1 ms 1 ms 1 /home/www/html/expat/ibstyle.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_DesignSet.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_GetModerators.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/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/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_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GetCategory.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 1 /home/www/html/navjoin_rdesign4.cfm
0 ms 0 ms 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
344 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 @ 19:34:29.029
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=207ms, Records=1) in /home/www/html/expat/Application.cfm @ 19:34:29.029
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 19:34:29.029
	Select *
	From Networks
	Where frmid = 194 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 19:34:29.029
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 19:34:29.029
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 33 
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 19:34:29.029
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 194 
getcities (Datasource=expert, Time=1ms, Records=9) in /home/www/html/navmetaforums_rdesign5.cfm @ 19:34:29.029
	Select *
	From citynetworks
	Where networkID = 33
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 19:34:29.029
  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=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 19:34:29.029
	Select *
	From Networks
	Where networkID = 33 
GetTopicTitle (Datasource=forum, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 19:34:29.029
  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 = 194 
  AND t.tpcid = 3433776 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
  AND t.tpcid = m.tpcid
  AND m.msgparent = 0
GetTopicInformation (Datasource=forum, Time=5ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 19:34:29.029
  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 = 3433776
  and  t.tpcid = 3433776
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=1ms, Records=45) in /home/www/html/navmetaforums_rdesign5.cfm @ 19:34:29.029
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 33
	order by lastsent ASC
GetTopicInformation (Datasource=forum, Time=7ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 19:34:29.029
  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 = 3433776
  and  t.tpcid = 3433776
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=0ms, Records=45, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 19:34:29.029
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 33
	order by lastsent ASC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 19:34:29.029
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
and logtime > "2020-02-28"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 19:34:29.029
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
and logtime > "2020-05-29 00:00:00.000"
and logtime < "2020-05-29 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 19:34:29.029
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
and logtime > "2020-05-22"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 19:34:29.029
	SELECT *
	From contentcountcountry
	Where networkid = 33 
gettopbanner (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navleader_rdesign5.cfm @ 19:34:29.029
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-05-28"
    and fromDate < "2020-05-29"
gettopbanner (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 19:34:29.029
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-05-28"
    and fromDate < "2020-05-29"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 19:34:29.029
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
GetNavigator (Datasource=forum, Time=0ms, Records=1) in /home/www/html/expat/Application.cfm @ 19:34:29.029
  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 = 194 
  AND tpcid = 3433776 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
GetModerators (Datasource=forum, Time=1ms, Records=0) in /home/www/html/expat/queries/qry_GetModerators.cfm @ 19:34:29.029
  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 194
  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 @ 19:34:29.029
  SELECT *
  FROM categories
  WHERE catid = "2"
DesignSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 19:34:29.029
  SELECT * FROM designset
  WHERE designsetid = 11 
GetFirstMessage (Datasource=forum, Time=7ms, Records=1) in /home/www/html/expat/messages_rdesign5.cfm @ 19:34:29.029
  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 = 3433776
  AND m.userid = u.userid
  AND topics.tpcid = 3433776
  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=7ms, Records=14) in /home/www/html/expat/messages_rdesign5.cfm @ 19:34:29.029
  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 = 3433776
  AND m.userid = u.userid
  AND topics.tpcid = 3433776
    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 @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499385
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499385
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 19:34:29.029
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:34:29.029
	Select *
	From Networks
	Where networkid = 33 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:34:29.029
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=0ms, Records=2) in /home/www/html/nativerotationtop_tester13.cfm @ 19:34:29.029
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 33
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-05-28"
and natforumstart < "2020-05-29"
and natforumstatus = 'live'

and (natforumweight = 'medium' or natforumweight = 'high')
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499403
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499403
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499404
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499404
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499416
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499416
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499509
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499509
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 19:34:29.029
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:34:29.029
	Select *
	From Networks
	Where networkid = 33 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:34:29.029
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=1ms, Records=2) in /home/www/html/nativerotationtop_tester13.cfm @ 19:34:29.029
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 33
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-05-28"
and natforumstart < "2020-05-29"
and natforumstatus = 'live'

and natforumweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:34:29.029
SELECT resourceid, natforum as adcode, natforumweight, natadid
FROM natads 
WHERE natadid = 1 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499532
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499532
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499534
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499534
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499538
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499538
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499539
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499539
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499551
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499551
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499556
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 499556
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 536554
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 536554
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 536606
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 536606
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 536615
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 19:34:29.029
SELECT vote
FROM votes
WHERE voteid = 536615
and vote = 'bad'
and liketype = 6 
getclasscheck (Datasource=tipripper, Time=29ms, Records=6) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 19:34:29.029
	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 = 33
	AND "2020-05-29" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkrptarticles (Datasource=reports, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 19:34:29.029
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-29"
     
         and rptarticlenetworks.networkid = 33 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=1ms, Records=6) in /home/www/html/rewritearticlefirsttitle.cfm @ 19:34:29.029
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 9
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 19:34:29.029
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 20 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 19:34:29.029
SELECT  hiimg
FROM rptarticles
where rptarticleID = 9
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 19:34:30.030
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 33 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-29"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 19:34:30.030
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 33 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 19:34:30.030
		Select summary, hiimg 
		FROM answers
         where answerid = 76511
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentbox.cfm @ 19:34:30.030
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 33 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 19:34:30.030
		Select summary, hiimg 
		FROM answers
         where answerid = 75202
         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/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=194&tpcid=3433776
REMOTE_ADDR=172.69.62.46
REMOTE_HOST=172.69.62.46
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=28658510
cftoken=89336640
sessionid=IBEXPATEXCHANGE.COM_28658510_89336640
urltoken=CFID=28658510&CFTOKEN=89336640
URL Parameters:
frmid=194
tpcid=3433776
Debug Rendering Time: 13 ms