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

Jamaica Expat Forum

FOR RENT

Post New Topic
blessingsdevine
1/5/2019 13:46 EST

Still looking for some one to share a huge rental property overlooking the sea and midway Montego Bay and Negril.

Only 350USA per month.

Post a Reply

00abuse

edmon59
1/5/2019 13:57 EST

PM sent

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

newnative72
2/8/2019 18:21 EST

Post some pics please? Or message me.

Post a Reply

00abuse

Sade123
2/15/2019 15:42 EST

Good day. How can I help.

Post a Reply

00abuse

Jajaja
3/26/2019 13:29 EST

Try https://www.jacars.net/ - they have a good category for various kind of rents.

Maybe you could also try to find sites that specify on rent only? But on such sites, usually third-party is involved, so you may end up paying high fees.

Let me know if I was any help!

Post a Reply

00abuse

edmon59
3/27/2019 16:00 EST

I am looking to rent, I have responded to blessingsdevine, but no response.
I need to rent until my house is built.

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

edmon59
3/27/2019 16:00 EST

I am looking to rent, I have responded to blessingsdevine, but no response.
I need to rent until my house is built.

Post a Reply

00abuse

gogreen2020
1/31/2020 16:31 EST

I am looking for a rental to share with someone or something I can rent by myself on or close to the beach.

Post a Reply

00abuse

Expatriate Health Insurance

Get a quote for expat health insurance in Jamaica.

International Moving Companies

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. ...

Expat-Jamaica10 Tips for Living in Jamaica

Jamaica is a well-known island getaway, but living there is not an extended vacation. Expensive schools, safety issues and high cost of living are all challenges for expats. Members share their advice about deciding where to live, finding a home, choosing a school and cost-saving shopping strategies.

Jamaica is a well-known island getaway, but living there is not an extended vacation. Expensive schools, safety issues and high cost of living are all challenges for expats. Members share their advi...

Expats-in-JamaicaExpat Jamaica: An Interview with Mike Miville

An Expat Interview with Mike Miville, an expat helping to find long-term sources of water in Jamaica.

An Expat Interview with Mike Miville, an expat helping to find long-term sources of water in Jamaica....

Expats-in-JamaicaInternational Schools in Jamaica

Expats in Jamaica discuss the best schools for expat children - from very expat-oriented schools like AISK and Hillel to more local private schools like St. Andrews and Montego Bay Christian Academy.

Expats in Jamaica discuss the best schools for expat children - from very expat-oriented schools like AISK and Hillel to more local private schools like St. Andrews and Montego Bay Christian Academy. ...

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 14-Jul-20 11:58 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.68.65.192
Host Name 172.68.65.192


Execution Time

Total Time Avg Time Count Template
145 ms 145 ms 1 /home/www/html/expat/Application.cfm
67 ms 67 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
66 ms 66 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
65 ms 65 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
32 ms 32 ms 1 /home/www/html/navcontentbox.cfm
27 ms 27 ms 1 /home/www/html/expat/messages_rdesign5.cfm
26 ms 26 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
16 ms 16 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
15 ms 15 ms 1 /home/www/html/expat/message_rdesign5.cfm
8 ms 8 ms 1 /home/www/html/navtop_rdesign5.cfm
6 ms 1 ms 8 /home/www/html/navvote_rdesign5.cfm
5 ms 3 ms 2 /home/www/html/nativerotationtop_tester13.cfm
5 ms 5 ms 1 /home/www/html/navleader_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/rewritearticlefirsttitle.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 8 /home/www/html/expat/common/formatmsg.cfm
0 ms 0 ms 1 /home/www/html/expat/constants.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 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
145 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 @ 11:58:52.052
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=20ms, Records=1) in /home/www/html/expat/Application.cfm @ 11:58:52.052
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 11:58:52.052
	Select *
	From Networks
	Where frmid = 233 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 11:58:52.052
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 11:58:52.052
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 60 
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 11:58:52.052
	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 @ 11:58:52.052
	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 @ 11:58:52.052
  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 @ 11:58:52.052
	Select *
	From Networks
	Where networkID = 60 
GetTopicTitle (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 11:58:52.052
  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 = 3434951 
  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 @ 11:58:52.052
  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 = 3434951
  and  t.tpcid = 3434951
  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 @ 11:58:52.052
	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 @ 11:58:52.052
  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 = 3434951
  and  t.tpcid = 3434951
  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 @ 11:58:52.052
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 60
	order by lastsent ASC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 11:58:52.052
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
and logtime > "2020-04-14"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 11:58:52.052
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
and logtime > "2020-07-14 00:00:00.000"
and logtime < "2020-07-14 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 @ 11:58:52.052
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
and logtime > "2020-07-07"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 11:58:52.052
	SELECT *
	From contentcountcountry
	Where networkid = 60 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 11:58:52.052
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-13"
    and fromDate < "2020-07-14"
UpdatePageViews (Datasource=expert, Time=4ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 11:58:52.052
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
GetNavigator (Datasource=forum, Time=0ms, Records=1) in /home/www/html/expat/Application.cfm @ 11:58:52.052
  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 = 3434951 
  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 @ 11:58:52.052
  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, Cached Query) in /home/www/html/expat/queries/qry_GetCategory.cfm @ 11:58:52.052
  SELECT *
  FROM categories
  WHERE catid = "2"
DesignSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 11:58:52.052
  SELECT * FROM designset
  WHERE designsetid = 11 
GetFirstMessage (Datasource=forum, Time=6ms, Records=1) in /home/www/html/expat/messages_rdesign5.cfm @ 11:58:52.052
  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 = 3434951
  AND m.userid = u.userid
  AND topics.tpcid = 3434951
  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=7) in /home/www/html/expat/messages_rdesign5.cfm @ 11:58:52.052
  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 = 3434951
  AND m.userid = u.userid
  AND topics.tpcid = 3434951
    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 @ 11:58:52.052
SELECT vote
FROM votes
WHERE voteid = 508659
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 11:58:52.052
SELECT vote
FROM votes
WHERE voteid = 508659
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 11:58:52.052
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:58:52.052
	Select *
	From Networks
	Where networkid = 60 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:58:52.052
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:58:52.052
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 60
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-07-13"
and natforumstart < "2020-07-14"
and natforumstatus = 'live'

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

and (natforumweight = 'medium' or natforumweight = 'high')
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 11:58:52.052
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 @ 11:58:52.052
SELECT vote
FROM votes
WHERE voteid = 520838
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 11:58:52.052
SELECT vote
FROM votes
WHERE voteid = 520838
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 11:58:52.052
SELECT vote
FROM votes
WHERE voteid = 558212
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 11:58:52.052
SELECT vote
FROM votes
WHERE voteid = 558212
and vote = 'bad'
and liketype = 6 
getclasscheck (Datasource=tipripper, Time=31ms, Records=0) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 11:58:52.052
	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-14" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkrptarticles (Datasource=reports, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 11:58:52.052
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-14"
     
         and rptarticlenetworks.networkid = 60 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 11:58:52.052
	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 @ 11:58:52.052
	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 @ 11:58:52.052
SELECT  hiimg
FROM rptarticles
where rptarticleID = 31
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 11:58:52.052
	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-14"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 11:58:52.052
		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=5ms, Records=2) in /home/www/html/navcontentbox.cfm @ 11:58:52.052
		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 @ 11:58:52.052
		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=3434951
REMOTE_ADDR=172.68.65.192
REMOTE_HOST=172.68.65.192
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=31880731
cftoken=52451225
sessionid=IBEXPATEXCHANGE.COM_31880731_52451225
urltoken=CFID=31880731&CFTOKEN=52451225
URL Parameters:
frmid=233
tpcid=3434951
Debug Rendering Time: 15 ms