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

Nicaragua Expat Forum

Safety

Post New Topic
kumusta
3/10/2019 21:01 EST

I have a question for the forum looking to relocate in my retirement in approximately two months and was wondering how safe is it to retire in Nicaragua at this point any help in this matter would be greatly appreciated. Thank you.

Post a Reply

00abuse

waltermboyleses
3/10/2019 21:36 EST

It is as safe now as before the April Problem. But Dan's replacement needs to be in place before you move here.

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

KeyWestPirate
3/10/2019 22:09 EST

Safe depends on where you plan to relocate, and how you are going to live.

There is more police presence in Granada, SJdS,, specifically detailed to keep an eye out for the tourists.

Managua will see more petty crime as the economy deteriorates and more people lose their employment. Your wallet and cell phone means food for their kids. Lack of oil to keep the lights on may create some additional hardship,, and danger. Nicaragua cannot survive without donations and external loans.

If you drive, Transito has been ignoring Gringos, I've never driven this long before, without being solicited for a bribe,,, in fact,, where I was constantly stopped before,, now it's rare to be pulled over.

There are great deals, especially if you plan to rent,, and lots of vacancies to choose from. Make an offer. As a Gringo who can pay the rent promptly without being chased down,, you are a desirable tenant.

If I were buying,, I would wait another 6 months to a year,,and then start seriously looking. The economy is going no where but down,, the question is how far,, and how fast,, and how long. No one is going to loosen the purse strings as long as Danny is still running the show.

Oddly, basics like rice, beans,, flour sugar,, just about everything else,, has risen in price,,, but this is still an inexpensive place to retire.

Good luck,, and welcome to Nicaragua. I've been here almost ten years. The country certainly has its warts,, but the good outweighs the bad --- most days.

Post a Reply

20abuse

novato1953
3/10/2019 22:55 EST

Expect to find both saints and sinners in Nicaragua, and in roughly the same percentages as most other places in the world. It won't cost much to take a sightseeing trip before actually retiring here, check out the various regions and see for yourself. It's a small country, but the presence of mountains means wide variances in climate.

Post a Reply

00abuse

peggyjune
3/10/2019 23:27 EST

I was in Granada - a few years ago, I really liked the area. For many reasons, I decided to not move there. I traveled to a few places - and the historic city was really a magical place. I went there 2 times, I never felt unsafe, of course - using common sense.

Post a Reply

00abuse

FelipeWambango
3/11/2019 09:52 EST

Esteli in Northern Nicaragua is very safe at this time.

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

novato1953
3/11/2019 11:26 EST

It's been a while since I swung left to Esteli instead of right to Matagalpa when I head up north. Tell me, is the fabulous Hotel Las Iguanas still thriving in Esteli?

Post a Reply

00abuse

Expatriate Health Insurance

Get a quote for expat health insurance in Nicaragua.

International Moving Companies

Moving to Nicaragua? Get a moving quote.


Mail Forwarding to Nicaragua

Mail Forwarding to Nicaragua.


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 Nicaragua from our partner, Cigna Global Health.
Get a Quote

12-Expats-Talk-About-Living-in-Nicaragua12 Expats Talk About Living in Nicaragua

Expats in Nicaragua talks about living in Nicaragua - the high numbers of retirees, the kind and welcoming Nicas, the challenges they face learning the language and more.
Expats in Nicaragua talks about living in Nicaragua - the high numbers of retirees, the kind and welcoming Nicas, the challenges they face learning the language and more....

Expat-Nicaragua10 Tips for Living in Nicaragua

Did you know that lots of homes in Nicaragua don't have hot water? Did you know that it's very easy to meet other expats in Nicaragua? Expats share their tips for living in Nicaragua.

Did you know that lots of homes in Nicaragua don't have hot water? Did you know that it's very easy to meet other expats in Nicaragua? Expats share their tips for living in Nicaragua. ...

Retiring-Abroad5 Great Places to Retire in Central America

Central America is an increasingly popular retirement destination. Retirees love it's proximity to the United States, lower cost of living, beautiful cities, amazing beaches, healthy lifestyle and friendly people.

Central America is an increasingly popular retirement destination. Retirees love it's proximity to the United States, lower cost of living, beautiful cities, amazing beaches, healthy lifestyle and fr...

Expats-in-Nicaragua5 Best Places to Retire in Nicaragua

Expats discuss the best places to retire in Nicaragua. From upscale communities on the Emerald Coast to the beautiful city of Granada, Nicaragua is no longer just a haven for surfers.

Expats discuss the best places to retire in Nicaragua. From upscale communities on the Emerald Coast to the beautiful city of Granada, Nicaragua is no longer just a haven for surfers....

Moving-To-LeonAn Expat Talks about Moving to Leon, Nicaragua

An expat who moved to Leon, Nicaragua talks about how she chose Leon, finding her first place to live with the help of a local real estate agency, getting advice from other expats before she moved and much more. She advises others to bring more sheets and towels, more pots and pans and to leave fancy, warm clothing and shoes at home.

An expat who moved to Leon, Nicaragua talks about how she chose Leon, finding her first place to live with the help of a local real estate agency, getting advice from other expats before she moved and...

Nicaragua 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 02-Jun-20 05:26 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.60
Host Name 162.158.78.60


Execution Time

Total Time Avg Time Count Template
112 ms 112 ms 1 /home/www/html/expat/Application.cfm
53 ms 53 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
53 ms 53 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
52 ms 52 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
26 ms 26 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
25 ms 25 ms 1 /home/www/html/expat/messages_rdesign5.cfm
25 ms 25 ms 1 /home/www/html/navcontentbox.cfm
16 ms 16 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
13 ms 13 ms 1 /home/www/html/expat/message_rdesign5.cfm
8 ms 8 ms 1 /home/www/html/navtop_rdesign5.cfm
6 ms 1 ms 7 /home/www/html/navvote_rdesign5.cfm
5 ms 3 ms 2 /home/www/html/nativerotationtop_tester13.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.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_GeneralSet.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_GetModerators.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 7 /home/www/html/expat/common/formatmsg.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_DesignSet.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 1 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 1 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 1 /home/www/html/rewritereport.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
113 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=1ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GeneralSet.cfm @ 05:26:32.032
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/expat/Application.cfm @ 05:26:32.032
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 05:26:32.032
	Select *
	From Networks
	Where frmid = 654 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:26:32.032
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:26:32.032
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 295 
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:26:32.032
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 654 
getcities (Datasource=expert, Time=0ms, Records=4) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:26:32.032
	Select *
	From citynetworks
	Where networkID = 295
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:26:32.032
  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 @ 05:26:32.032
	Select *
	From Networks
	Where networkID = 295 
GetTopicTitle (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:26:32.032
  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 = 654 
  AND t.tpcid = 3436242 
  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 @ 05:26:32.032
  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 = 3436242
  and  t.tpcid = 3436242
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=1ms, Records=10) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:26:32.032
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 295
	order by lastsent ASC
GetTopicInformation (Datasource=forum, Time=4ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:26:32.032
  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 = 3436242
  and  t.tpcid = 3436242
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=0ms, Records=10, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:26:32.032
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 295
	order by lastsent ASC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 05:26:32.032
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.60'
and logtime > "2020-03-03"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 05:26:32.032
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.60'
and logtime > "2020-06-02 00:00:00.000"
and logtime < "2020-06-02 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 @ 05:26:32.032
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.60'
and logtime > "2020-05-26"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 05:26:32.032
	SELECT *
	From contentcountcountry
	Where networkid = 295 
gettopbanner (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 05:26:32.032
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-06-01"
    and fromDate < "2020-06-02"
gettopbanner (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 05:26:32.032
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-06-01"
    and fromDate < "2020-06-02"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 05:26:32.032
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
GetNavigator (Datasource=forum, Time=1ms, Records=1) in /home/www/html/expat/Application.cfm @ 05:26:32.032
  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 = 654 
  AND tpcid = 3436242 
  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:26:32.032
  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 654
  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:26:32.032
  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:26:32.032
  SELECT * FROM designset
  WHERE designsetid = 11 
GetFirstMessage (Datasource=forum, Time=6ms, Records=1) in /home/www/html/expat/messages_rdesign5.cfm @ 05:26:32.032
  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 = 3436242
  AND m.userid = u.userid
  AND topics.tpcid = 3436242
  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=5ms, Records=6) in /home/www/html/expat/messages_rdesign5.cfm @ 05:26:32.032
  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 = 3436242
  AND m.userid = u.userid
  AND topics.tpcid = 3436242
    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:26:32.032
SELECT vote
FROM votes
WHERE voteid = 518139
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:26:32.032
SELECT vote
FROM votes
WHERE voteid = 518139
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=1ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 05:26:32.032
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:26:32.032
	Select *
	From Networks
	Where networkid = 295 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:26:32.032
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:26:32.032
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 295
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-06-01"
and natforumstart < "2020-06-02"
and natforumstatus = 'live'

and natforumweight = 'high'
votecount (Datasource=forum, Time=0ms, Records=2) in /home/www/html/navvote_rdesign5.cfm @ 05:26:32.032
SELECT vote
FROM votes
WHERE voteid = 518143
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:26:32.032
SELECT vote
FROM votes
WHERE voteid = 518143
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:26:32.032
SELECT vote
FROM votes
WHERE voteid = 518147
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:26:32.032
SELECT vote
FROM votes
WHERE voteid = 518147
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:26:32.032
SELECT vote
FROM votes
WHERE voteid = 518152
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:26:32.032
SELECT vote
FROM votes
WHERE voteid = 518152
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:26:32.032
SELECT vote
FROM votes
WHERE voteid = 518180
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:26:32.032
SELECT vote
FROM votes
WHERE voteid = 518180
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=1ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 05:26:32.032
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:26:32.032
	Select *
	From Networks
	Where networkid = 295 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:26:32.032
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:26:32.032
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 295
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-06-01"
and natforumstart < "2020-06-02"
and natforumstatus = 'live'

and (natforumweight = 'medium' or natforumweight = 'high')
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:26:32.032
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 @ 05:26:32.032
SELECT vote
FROM votes
WHERE voteid = 518205
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:26:32.032
SELECT vote
FROM votes
WHERE voteid = 518205
and vote = 'bad'
and liketype = 6 
getclasscheck (Datasource=tipripper, Time=26ms, Records=0) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 05:26:32.032
	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 = 295
	AND "2020-06-02" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 05:26:32.032
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-02"
     
         and rptarticlenetworks.networkid = 295 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 05:26:32.032
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 16
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 05:26:32.032
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 295 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 05:26:32.032
SELECT  hiimg
FROM rptarticles
where rptarticleID = 16
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=4ms, Records=3) in /home/www/html/navcontentbox.cfm @ 05:26:32.032
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 295 
	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-06-02"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/navcontentbox.cfm @ 05:26:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 295 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 05:26:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 295 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 05:26:32.032
		Select summary, hiimg 
		FROM answers
         where answerid = 74149
         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=654&tpcid=3436242
REMOTE_ADDR=162.158.78.60
REMOTE_HOST=162.158.78.60
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=28861645
cftoken=23002946
sessionid=IBEXPATEXCHANGE.COM_28861645_23002946
urltoken=CFID=28861645&CFTOKEN=23002946
URL Parameters:
frmid=654
tpcid=3436242
Debug Rendering Time: 11 ms