Home Jamaica Forum Jamaica Guide Moving to Jamaica Real Estate Healthcare in Jamaica
Jamaica
Resources
City Guides
JoinSign In
AGS Worldwide Movers

Jamaica Expat Forum

crime in Negril Jamaica

Post New Topic
yogananda
3/8/2019 07:45 EST

I just came back from Negril Jamaica. When I was there two people were shot dead on the street on Norman Manley Blvd. (main street for tourist traffic) across from many hotels and tourist resturants.

When I read the news, I found out the 8 killings had taken place in Westmoreland between mid January 2019 and February 2019.

These seem to be targeted killings but at this point innocent people can get hurt. If this violence is not cleaned up in Jamaica, now in a main tourist spot. I do not think this is a safe place to vacation. I have been coming to Jamaica, Negril for 25 years. I have heard about crime in this country but it has been well known that the tourist areas get extra attention because of the impact on the economy.

These brazen acts show me that something has broken down.

Post a Reply

00abuse

Iriestar68
3/8/2019 07:55 EST

Crime happens everywhere, not just Jamaica.

How many killings took place in Chicago on that day?

As long you’re not doing something you shouldn’t be doing , you’ll be fine. Keep your nose clean and your mouth shut. Too many expats come here and are very loud and make themselves targets. Returning residents do the same.

Crime is is crime and you just be sensible

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

Iriestar68
3/8/2019 07:55 EST

Crime happens everywhere, not just Jamaica.

How many killings took place in Chicago on that day?

As long you’re not doing something you shouldn’t be doing , you’ll be fine. Keep your nose clean and your mouth shut. Too many expats come here and are very loud and make themselves targets. Returning residents do the same.

Crime is is crime and you just be sensible

Post a Reply

00abuse

yogananda
3/8/2019 08:03 EST

Lousy excuse. This is unusual in the tourist spot in Jamaica. I understand the government and tourist board does not want to advertise this. People are not going to Chicago for a sunny vacation. and I am talking about killings right on the main downtown street. Please forum people stop making these excuses to hide the facts. I just came back. No tourist wants to come to a place that has the stats of Chicago ghettos. Listen. I am talking about the main streets in the tourist section of Negril. Please read carefully or google...this is not an everyday occurrence. Don't try to brush this activitiy off. This has nothing to do with being sensible. One person was shot in broad daylight next to a tourist restaurant! You cannot be sensible...unless this is cleaned up or you don't go.

Post a Reply

00abuse

Iriestar68
3/8/2019 12:55 EST

Then stay scared and stay home.

Crime happens everywhere in this world.

Post a Reply

00abuse

yogananda
3/8/2019 13:04 EST

Awareness is the key NOT being scared. Ignorance is not bliss

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

Gardis
3/8/2019 20:28 EST

I lived in Jamaica in the 1990's for 10 years - ran a factory in the Free Zones. I had about 100 people working for me. I loved it - but I was very sensible about going around - I wore no jewelry, drove an older car, and didn't attract attention (I am white). I tried to blend in as much as possible, but I didn't go "native". What Iriestar is saying is not all wrong. You do have to be sensible and take precautions. However, there is no comparison in any way to events in the USA. We are a country of 320 million people, we have allowed gangs from Central america to infiltrate our country through our southern border. But if you go to the UN statistics, Jamaica is right up there on a per capita basis with some of the most violent countries in the world. It has always been this way in Jamaica, and I fear it will stay that way. The GOJ is utterly unable to deal with it. It's a shame because it's a beautiful country with a lot to offer.

Post a Reply

00abuse

Expatriate Health Insurance

Get a quote for expat health insurance in Jamaica.

International Moving Quotes

Moving to Jamaica? Get a moving quote.


Mail Forwarding to Jamaica

Mail Forwarding to Jamaica.


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

Best-Advice-From-Expats-on-Moving-to-JamaicaBest Advice From Expats on Moving to Jamaica

Expats in Jamaica offer advice for newcomers about deciding where to live in Jamaica, what to bring with you and more.
Expats in Jamaica offer advice for newcomers about deciding where to live in Jamaica, what to bring with you and more. ...

Expats-in-JamaicaExpats in Jamaica: Pros and Cons of Living in Jamaica

People from all over the globe have found their way to Jamaica to live as an expat in the Caribbean Sea. Expats already there are quick to point out that it's not a vacation every day on the island!

People from all over the globe have found their way to Jamaica to live as an expat in the Caribbean Sea. Expats already there are quick to point out that it's not a vacation every day on the island!...

Expats-in-Jamaica9 Healthcare & Health Insurance Tips for Expats in Jamaica

Expats in Jamaica share tips and advice about healthcare and health insurance in Jamaica. Advice about private hospitals, leaving the country for surgery, the Zika virus, the availability and cost of prescription medicines and more.

Expats in Jamaica share tips and advice about healthcare and health insurance in Jamaica. Advice about private hospitals, leaving the country for surgery, the Zika virus, the availability and cost of...

Moving-To-FalmouthAn Expat Talks about Moving to Falmouth, Jamaica

An expat in Falmouth, Jamaica offers some insight into moving there. It includes cost of living information, what to bring and what you might want to leave at home.

An expat in Falmouth, Jamaica offers some insight into moving there. It includes cost of living information, what to bring and what you might want to leave at home....

Jamaica 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 09-Jul-20 12:33 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
101 ms 101 ms 1 /home/www/html/expat/Application.cfm
51 ms 51 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
51 ms 51 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
50 ms 50 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
25 ms 25 ms 1 /home/www/html/navcontentbox.cfm
22 ms 22 ms 1 /home/www/html/expat/messages_rdesign5.cfm
21 ms 21 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
13 ms 13 ms 1 /home/www/html/expat/message_rdesign5.cfm
13 ms 13 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/navtop_rdesign5.cfm
6 ms 1 ms 7 /home/www/html/navvote_rdesign5.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
2 ms 2 ms 1 /home/www/html/navleader_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
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/rewritearticlefirsttitle.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 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 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign4.cfm
0 ms 0 ms 2 /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
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
101 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 @ 12:33:47.047
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/expat/Application.cfm @ 12:33:47.047
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 12:33:47.047
	Select *
	From Networks
	Where frmid = 233 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:33:47.047
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:33:47.047
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 60 
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:33:47.047
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 233 
getcities (Datasource=expert, Time=1ms, Records=5) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:33:47.047
	Select *
	From citynetworks
	Where networkID = 60
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:33:47.047
  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 @ 12:33:47.047
	Select *
	From Networks
	Where networkID = 60 
GetTopicTitle (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:33:47.047
  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 = 233 
  AND t.tpcid = 3436177 
  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 @ 12:33:47.047
  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 = 3436177
  and  t.tpcid = 3436177
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=1ms, Records=11) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:33:47.047
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 60
	order by lastsent ASC
GetTopicInformation (Datasource=forum, Time=4ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:33:47.047
  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 = 3436177
  and  t.tpcid = 3436177
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=0ms, Records=11, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 12:33:47.047
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 60
	order by lastsent ASC
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:33:47.047
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-04-09"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 12:33:47.047
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-07-09 00:00:00.000"
and logtime < "2020-07-09 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 @ 12:33:47.047
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-07-02"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:33:47.047
	SELECT *
	From contentcountcountry
	Where networkid = 60 
gettopbanner (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 12:33:47.047
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-08"
    and fromDate < "2020-07-09"
    and bannerPlacement.networkid = '60'
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 12:33:47.047
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
GetNavigator (Datasource=forum, Time=0ms, Records=1) in /home/www/html/expat/Application.cfm @ 12:33:47.047
  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 = 233 
  AND tpcid = 3436177 
  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 @ 12:33:47.047
  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 233
  AND u.userdbname = "ee"
  ORDER BY u.username
GetCategory (Datasource=forum, Time=0ms, Records=1) in /home/www/html/expat/queries/qry_GetCategory.cfm @ 12:33:47.047
  SELECT *
  FROM categories
  WHERE catid = "2"
DesignSet (Datasource=forum, Time=0ms, Records=1) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 12:33:47.047
  SELECT * FROM designset
  WHERE designsetid = 11 
GetFirstMessage (Datasource=forum, Time=4ms, Records=1) in /home/www/html/expat/messages_rdesign5.cfm @ 12:33:47.047
  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 = 3436177
  AND m.userid = u.userid
  AND topics.tpcid = 3436177
  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=6) in /home/www/html/expat/messages_rdesign5.cfm @ 12:33:47.047
  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 = 3436177
  AND m.userid = u.userid
  AND topics.tpcid = 3436177
    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 @ 12:33:47.047
SELECT vote
FROM votes
WHERE voteid = 517699
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:33:47.047
SELECT vote
FROM votes
WHERE voteid = 517699
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 12:33:47.047
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:33:47.047
	Select *
	From Networks
	Where networkid = 60 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:33:47.047
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:33:47.047
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 60
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-07-08"
and natforumstart < "2020-07-09"
and natforumstatus = 'live'

and natforumweight = 'high'
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:33:47.047
SELECT vote
FROM votes
WHERE voteid = 517700
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:33:47.047
SELECT vote
FROM votes
WHERE voteid = 517700
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:33:47.047
SELECT vote
FROM votes
WHERE voteid = 517703
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:33:47.047
SELECT vote
FROM votes
WHERE voteid = 517703
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:33:47.047
SELECT vote
FROM votes
WHERE voteid = 517747
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:33:47.047
SELECT vote
FROM votes
WHERE voteid = 517747
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:33:47.047
SELECT vote
FROM votes
WHERE voteid = 517750
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:33:47.047
SELECT vote
FROM votes
WHERE voteid = 517750
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 12:33:47.047
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:33:47.047
	Select *
	From Networks
	Where networkid = 60 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:33:47.047
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:33:47.047
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 60
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-07-08"
and natforumstart < "2020-07-09"
and natforumstatus = 'live'

and (natforumweight = 'medium' or natforumweight = 'high')
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:33:47.047
SELECT resourceid, natforum as adcode, natforumweight, natadid
FROM natads 
WHERE natadid = 46 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:33:47.047
SELECT vote
FROM votes
WHERE voteid = 517801
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 12:33:47.047
SELECT vote
FROM votes
WHERE voteid = 517801
and vote = 'bad'
and liketype = 6 
getclasscheck (Datasource=tipripper, Time=25ms, Records=0) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 12:33:47.047
	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 = 60
	AND "2020-07-09" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 12:33:47.047
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-09"
     
         and rptarticlenetworks.networkid = 60 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 12:33:47.047
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 31
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 12:33:47.047
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 60 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 12:33:47.047
SELECT  hiimg
FROM rptarticles
where rptarticleID = 31
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=4ms, Records=2) in /home/www/html/navcontentbox.cfm @ 12:33:47.047
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 60 
	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-09"

    ORDER by articles.articleID desc
    
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 12:33:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 60 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentbox.cfm @ 12:33:47.047
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 60 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 12:33:47.047
		Select summary, hiimg 
		FROM answers
         where answerid = 73835
         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=233&tpcid=3436177
REMOTE_ADDR=162.158.79.9
REMOTE_HOST=162.158.79.9
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=31574792
cftoken=30928737
sessionid=IBEXPATEXCHANGE.COM_31574792_30928737
urltoken=CFID=31574792&CFTOKEN=30928737
URL Parameters:
frmid=233
tpcid=3436177
Debug Rendering Time: 11 ms