Ecuador
Resources
City Guides
JoinSign In
Cigna International Health Insurance

International Real Estate Advice

Real Estate Listings Property Advice Local Experts My Properties

Real Estate professionals and expats in Ecuador offer advice about renting and buying homes in cities and towns in Ecuador. Topics covered include the rental and buying process in Ecuador, popular areas, documents needed, budgets, rental and purchase agreements, precautions foreigners should take and more.

Sort Listings By: Newest | City

12 Tips for Living in San Clemente, Ecuador

By huarachon

An expat in Ecuador talks about why expats move to San Clemente - with it's laid back beach lifestyle, low cost of living, hot & dry climate and low crime rate. There are a few things that San Clemente is missing. Continue Reading

12 Tips for Living in Rio Chico, Ecuador

By kfgosl

An expat talks about what life is like in Rio Chico, Ecuador, a small beach town about 10 minutes from Montanita. With 12 hours of sunlight every day, beautiful beaches and terrific local shops, life in Rio Chico sounds wonderful. Continue Reading

Tips for Buying Propery in Ecuador

By zadfrak

An expat in Ecuador offers advice to other expats buying property in Ecuador -- from finding a local lawyer to renting before buying to the best places to buy property in Ecuador. Continue Reading

12 Tips for Living in San Jacinto, Ecuador

By CasaWF

An expat talks about living in the small fishing village of San Jacinto in Ecuador's Manabi province. With its perfect climate and low cost of living, San Jacinto might be the perfect place for those looking for a quiet beach town. Continue Reading

Real Estate Listings in Ecuador

Add a Property Listing

Apartment/Flat for Sale

General Villamil Guayaquil , Ecuador

2 Bedroom / 2 Full Bath / Half Bath

Unfurnished

Price: 158,000usd

Living Space: 130m2

Apartment for Sale in General Villamil Guayaquil, Ecuador

For sale, 2 bedroom 2 bath, 2 parking space oceanfront apartment located in prestigious Ocean Club Playas. Selling at 2012 builders price. Call Kathy if interested 4165609411. Can also come furnished

View Full Listing

House for Sale

San Roque, Imbabura, Ecuador

2 Bedroom / 1 Full Bath / Half Bath

Furnished

Price: 70,000 usd

Living Space: 1350 sq meters of land, house of 90 sq meters

House for Sale in San Roque, Imbabura, Ecuador

Brick and tile country house, built at the end of 2019, with splendid views of the Andes, a quarter of an hour from Atuntaqui and half an hour from Ibarra. Natural garden, fruit trees, enclosed land with a lively hedge of shrubs.

View Full Listing

Estate/Mansion for Sale

El Quinche, Ecuador

4 Bedroom / 4 Full Bath / 1 Half Bath

Unfurnished

Price: U.S.$485,000

Living Space: 2950 sq meters

Estate for Sale in El Quinche, Ecuador

Private, secure estate with historic farmhouse, new 2-storey adobe house (100-year old beams) and self-sufficient organic lifestyle (raised-bed vegetables, many fruit trees, unlimited irrigation water) 1 hour to Quito/20 minutes to new international airport.

View Full Listing

Land for Sale

Quito, Ecuador

Bedroom / Full Bath / Half Bath

Does Not Apply to This Listing

Price: $450,000 US

Living Space: 1160 Sq Meters

Land for Sale in Quito, Ecuador

Build your perfect home on this premium Lot on an exclusive gated community Country Club only 15 minutes from Quito's International Airport.

View Full Listing

Land for Sale

Tonchigue, Ecuador

Does Not Apply to This Listing

Price: US$25,000

Living Space: 2475.7 sq foot

Land for Sale in Tonchigue, Ecuador

Oceanfront property, 230 m2 / 2475.7 sq foot, located in fishermen's village Tonchigue, non touristic spot, lush vegetation in the area, lots of pasture land. Year-round sunshine. 3 km from Same.

View Full Listing

Apartment/Flat for Sale

Quito, Ecuador

2 Bedroom / 2 Full Bath / 1 Half Bath

Unfurnished

Price: US$ 100000

Living Space: 1323 sqf, 125 m2

Apartment for Sale in Quito, Ecuador

Beautiful apartment in a great neighborhood with private patio

View Full Listing

House for Sale

Salinas, Ecuador

2 Bedroom / 1 Full Bath / Half Bath

Unfurnished

Price: 39900

Living Space: 40

House for Sale in Salinas, Ecuador

Your beach house is within reach with this project. This gated community is only 5 minutes from the beach and the mall.

View Full Listing

Cigna Expat Health InsuranceExpatriate Health Insurance

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

17-Tips-from-Expats-about-Moving-to-Ecuador17 Tips from Expats about Moving to Ecuador

We asked expats in Ecuador for advice for newcomers. From cost of living to what to bring to culture shock, their insight is a must read for anyone thinking about moving to Ecuador.
We asked expats in Ecuador for advice for newcomers. From cost of living to what to bring to culture shock, their insight is a must read for anyone thinking about moving to Ecuador. ...

Moving-to-EcuadorMoving to Ecuador: Tips for Newcomers in Ecuador

When it comes to getting an insider's perspective on expat life in Ecuador, our Ecuador network is the place to post! With hundreds of posts each month, members cover current events, moving and relocation advice and much more!

When it comes to getting an insider's perspective on expat life in Ecuador, our Ecuador network is the place to post! With hundreds of posts each month, members cover current events, moving and reloc...

Expat-LifeInternational Schools in Ecuador

From the American School of Quito to Acadamia Cotopaxi, we cover the most popular international schools in Ecuador.

From the American School of Quito to Acadamia Cotopaxi, we cover the most popular international schools in Ecuador. ...

Expat-Advice-Expat Advice about Crime & Safety in Ecuador

Advice from Expats in Ecuador about Safety, Security and Crime in Ecuador.

Advice from Expats in Ecuador about Safety, Security and Crime in Ecuador....

Retirement-In-CuencaAn Expat Shares What it's Like Retiring in Cuenca, Ecuador

An semi-retired American living in Cuenca, Ecuador moved there for its lower cost of living and to avoid Obamacare penalties. He is enjoying working less, the local culture and expat events.

An semi-retired American living in Cuenca, Ecuador moved there for its lower cost of living and to avoid Obamacare penalties. He is enjoying working less, the local culture and expat events. ...

Moving-To-CuencaAn Expat Talks about Moving to Cuenca, Ecuador

An expat in Cuenca, Ecuador advises others to take an exploratory trip before committing to making the move. Then, if you do move to Cuenca, leave your furniture at home since it's very expensive to ship and furniture is very reasonably priced in Ecuador.

An expat in Cuenca, Ecuador advises others to take an exploratory trip before committing to making the move. Then, if you do move to Cuenca, leave your furniture at home since it's very expensive to ...

Ecuador 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 /eetr/tips.cfm
Time Stamp 22-Oct-20 10:16 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.141
Host Name 173.245.54.141


Execution Time

Total Time Avg Time Count Template
980 ms 980 ms 1 /home/www/html/eetr/tips.cfm
474 ms 474 ms 1 /home/www/html/eetr/tipsrentalproperties_include.cfm
415 ms 59 ms 7 /home/www/html/eetr/tipsrentalproperties_includebox.cfm
308 ms 308 ms 1 /home/www/html/eetr/Application.cfm
239 ms 60 ms 4 /home/www/html/eetr/tipsrentalproperty.cfm
94 ms 94 ms 1 /home/www/html/navtop_rdesign5.cfm
87 ms 87 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
59 ms 7 ms 8 /home/www/html/eetr/rewritetipheadingstate.cfm
33 ms 33 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
31 ms 31 ms 1 /home/www/html/navcontentbox.cfm
31 ms 31 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 1 ms 4 /home/www/html/eetr/rewriterealtorlink.cfm
2 ms 2 ms 1 /home/www/html/eetr/tippagingnew.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/eetr/tippaginglinkmaker.cfm
1 ms 1 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 2 /home/www/html/rewritereport.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/eetr/constants.cfm
0 ms 0 ms 1 /home/www/html/eetr/datasources.cfm
0 ms 0 ms 3 /home/www/html/eetr/navconstants.cfm
0 ms 0 ms 1 /home/www/html/eetr/navinjection.cfm
0 ms 0 ms 1 /home/www/html/eetr/qry_GeneralSet.cfm
0 ms 0 ms 4 /home/www/html/eetr/rewritealtimage.cfm
0 ms 0 ms 4 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/eetr/tippagingnewduplicate.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/navinjection.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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1289 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/eetr/qry_GeneralSet.cfm @ 22:16:01.001
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=306ms, Records=1) in /home/www/html/eetr/Application.cfm @ 22:16:02.002
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=2ms, Records=153) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:16:02.002
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=2ms, Records=8) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:16:02.002
	Select *
	From citynetworks
	Where networkID = 39
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:16:02.002
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 39 
getpropertycountries (Datasource=tipripper, Time=45ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:16:02.002
SELECT allreports.networkname, allreports.networkid, shortname, allreports.date
FROM allreports, Networks, sitecategories
WHERE rid = 100
and Networks.networkid = allreports.networkid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3
and allreports.hide <> 'y'

and allreports.tipcategoryid <> 2791

and allreports.tipcategoryid <> 2797
and allreports.networkid <> 159
group by allreports.networkid
order by allreports.networkname ASC
gettipcategories (Datasource=tipripper, Time=32ms, Records=12) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:16:02.002
SELECT * 
FROM sitecategories, qoptions, allreports
WHERE qoptions.qoid = sitecategories.tipcategoryid
and qoptions.parent = 0
and allreports.hide <> 'y'
and sitecategories.siteid = 3
and sitecategories.tipcategoryid <> 2791
and sitecategories.tipcategoryid <> 2797
and sitecategories.tipcategoryid <> ''
and sitecategories.tipcategoryid <> 2793
and sitecategories.tipcategoryid <> 2792
and allreports.tipcategoryid = sitecategories.tipcategoryid
group by sitecategories.tipcategoryid 
getcategoryinfo (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:16:02.002
SELECT * 
FROM sitecategories
WHERE sitecategories.tipcategoryid = 2831 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:16:02.002
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.promophoto600, topics.tipstemplate
FROM topics

WHERE topicid = 9 
getname (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:16:02.002
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 39 
GetClassifieds (Datasource=tipripper, Time=1ms, Records=4) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:16:02.002
SELECT Networks.networkname, allreports.networkid, shortname, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allreports.allowcomments, allreports.citynetworkid, allreports.citynetworkid2, allreports.statenetworkid, allreports.city, sitecategories.categoryslug, sitecategories.headingnav, allreports.topicid, allreports.state, allreports.networkname, allreports.enddate, allreports.networkname as country
FROM allreports, sitecategories, Networks
WHERE allreports.rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and hide <> 'y'
and sitecategories.siteid = 3
and allreports.tipcategoryid <> 2797

and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)

AND Networks.networkid = 39 
AND allreports.networkid = 39 
and allreports.tipcategoryid <> 2791

order by allreports.enddate DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:16:02.002
SELECT *
FROM topics

WHERE topicid = 9
gettopic (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:16:02.002
SELECT *
FROM topics

WHERE topicid = 9 
getcountryphoto (Datasource=expert, Time=1ms, Records=37) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:16:02.002
SELECT *
FROM countryphotos
WHERE networkid = 39 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:16:02.002
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.141'
and logtime > "2020-07-23"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 22:16:02.002
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.141'
and logtime > "2020-10-22 00:00:00.000"
and logtime < "2020-10-22 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:16:02.002
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.141'
and logtime > "2020-10-15"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:16:02.002
	SELECT *
	From contentcountcountry
	Where networkid = 39 
gettopbanner (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 22:16:02.002
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-10-21"
    and fromDate < "2020-10-22"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 22:16:02.002
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getcount (Datasource=tipripper, Time=4ms, Records=368) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT answerid
FROM allreports, sitecategories
WHERE rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
and networkid = 39 
order by city ASC, answerid DESC
getpropertycountries (Datasource=tipripper, Time=4ms, Records=30) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT allreports.networkname, allreports.networkid, shortname, shortnamecap
FROM allreports, Networks
WHERE allreports.topicid = 6
AND "2020-10-22" < allreports.enddate
and Networks.networkid = allreports.networkid
group by allreports.networkid
order by allreports.networkname ASC
getname (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tippaginglinkmaker.cfm @ 22:16:02.002
	Select *
	From Networks
	Where networkid = 39 
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT *
FROM users
WHERE userid = '115667'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '5507'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
	SELECT summary 
	FROM answers
	WHERE answerid = 79614 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 79614 
getheading (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79614'
	and qid = 391
	
getheading (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79614'
	and qid = 391
	
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.promophoto600, topics.tipstemplate, topics.articletitle
FROM topics

WHERE topicid = 11 
gettext402 (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79614'
	and qid = 402
gettext401 (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79614'
	and qid = 401
getheading (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79614'
	and qid = 391
checkexpert (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.startdate <{ts '2020-10-21 22:16:02'}
and expertusers.enddate > {ts '2020-10-22 22:16:02'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 115667
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
checkexpertexpired (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.enddate <{ts '2020-10-22 22:16:02'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 115667
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
getexpatusername (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT username
FROM users
WHERE userid = 115667 
getauthorfirst (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 115667
and answers.reviewed = 'y'
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 115667
and answers.reviewed = 'y'
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 115667
and answers.reviewed = 'y'
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 115667
and answers.reviewed = 'y'
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 115667
and answers.reviewed = 'y'
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
checkstatus (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 22:16:02.002
SELECT *
FROM expertusers
WHERE userid = 115667
and startdate <{ts '2020-10-21 22:16:02'}
and enddate > {ts '2020-10-22 22:16:02'} 
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT *
FROM users
WHERE userid = '128279'
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '8322'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
	SELECT summary 
	FROM answers
	WHERE answerid = 80407 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80407 
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80407'
	and qid = 391
	
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80407'
	and qid = 391
	
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.promophoto600, topics.tipstemplate, topics.articletitle
FROM topics

WHERE topicid = 11 
gettext402 (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80407'
	and qid = 402
gettext401 (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80407'
	and qid = 401
getheading (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80407'
	and qid = 391
checkexpert (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.startdate <{ts '2020-10-21 22:16:02'}
and expertusers.enddate > {ts '2020-10-22 22:16:02'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 128279
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
checkexpertexpired (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.enddate <{ts '2020-10-22 22:16:02'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 128279
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
getexpatusername (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT username
FROM users
WHERE userid = 128279 
getauthorfirst (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 128279
and answers.reviewed = 'y'
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=11ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 128279
and answers.reviewed = 'y'
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 128279
and answers.reviewed = 'y'
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=11ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 128279
and answers.reviewed = 'y'
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 128279
and answers.reviewed = 'y'
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
checkstatus (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 22:16:02.002
SELECT *
FROM expertusers
WHERE userid = 128279
and startdate <{ts '2020-10-21 22:16:02'}
and enddate > {ts '2020-10-22 22:16:02'} 
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT *
FROM users
WHERE userid = '189306'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getlocationtag3 (Datasource=expert, Time=0ms, Records=0) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '8008'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
	SELECT summary 
	FROM answers
	WHERE answerid = 79362 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 79362 
getheading (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79362'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79362'
	and qid = 391
	
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.promophoto600, topics.tipstemplate, topics.articletitle
FROM topics

WHERE topicid = 10 
gettext402 (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79362'
	and qid = 402
gettext401 (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79362'
	and qid = 401
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79362'
	and qid = 391
checkexpert (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.startdate <{ts '2020-10-21 22:16:02'}
and expertusers.enddate > {ts '2020-10-22 22:16:02'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 189306
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
checkexpertexpired (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.enddate <{ts '2020-10-22 22:16:02'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 189306
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
getexpatusername (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT username
FROM users
WHERE userid = 189306 
getauthorfirst (Datasource=tipripper, Time=12ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 189306
and answers.reviewed = 'y'
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=11ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 189306
and answers.reviewed = 'y'
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=10ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 189306
and answers.reviewed = 'y'
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=12ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 189306
and answers.reviewed = 'y'
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 189306
and answers.reviewed = 'y'
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
checkstatus (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 22:16:02.002
SELECT *
FROM expertusers
WHERE userid = 189306
and startdate <{ts '2020-10-21 22:16:02'}
and enddate > {ts '2020-10-22 22:16:02'} 
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT *
FROM users
WHERE userid = '110539'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '6117'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
	SELECT summary 
	FROM answers
	WHERE answerid = 79482 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:16:02.002
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 79482 
getheading (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79482'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79482'
	and qid = 391
	
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.promophoto600, topics.tipstemplate, topics.articletitle
FROM topics

WHERE topicid = 11 
gettext402 (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79482'
	and qid = 402
gettext401 (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79482'
	and qid = 401
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79482'
	and qid = 391
checkexpert (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.startdate <{ts '2020-10-21 22:16:02'}
and expertusers.enddate > {ts '2020-10-22 22:16:02'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 110539
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
checkexpertexpired (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.enddate <{ts '2020-10-22 22:16:02'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 110539
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
getexpatusername (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT username
FROM users
WHERE userid = 110539 
getauthorfirst (Datasource=tipripper, Time=10ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 110539
and answers.reviewed = 'y'
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 110539
and answers.reviewed = 'y'
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 110539
and answers.reviewed = 'y'
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 110539
and answers.reviewed = 'y'
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 22:16:02.002
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 110539
and answers.reviewed = 'y'
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
checkstatus (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 22:16:02.002
SELECT *
FROM expertusers
WHERE userid = 110539
and startdate <{ts '2020-10-21 22:16:02'}
and enddate > {ts '2020-10-22 22:16:02'} 
getclass (Datasource=tipripper, Time=2ms, Records=15) in /home/www/html/eetr/tipsrentalproperties_include.cfm @ 22:16:02.002
SELECT *
FROM allreports, answers
WHERE allreports.topicid = 6
and allreports.networkid = 39
and allreports.hide <> 'y'
and answers.answerid = allreports.answerid
and "2020-10-22" < allreports.enddate
and (answers.paid = 'yes' or answers.paid = 'free')

order by allreports.answerid DESC
getprice (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80893'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80893'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80893'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80893'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80893'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80893'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80893'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80893'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80893'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80893'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80893'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80893'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80893'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80893'
AND answersmc.qoid = qoptions.qoid
getnetworkid (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT *
	FROM allreports
	WHERE answerid = '80893'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getprice (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80887'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80887'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80887'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80887'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80887'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80887'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80887'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80887'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=7ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80887'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80887'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=13ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80887'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80887'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80887'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80887'
AND answersmc.qoid = qoptions.qoid
getnetworkid (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT *
	FROM allreports
	WHERE answerid = '80887'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getprice (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80822'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80822'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80822'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80822'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80822'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80822'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80822'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80822'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80822'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80822'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=15ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80822'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80822'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80822'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80822'
AND answersmc.qoid = qoptions.qoid
getnetworkid (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT *
	FROM allreports
	WHERE answerid = '80822'
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getprice (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:02.002
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80819'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80819'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80819'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80819'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80819'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80819'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80819'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80819'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80819'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80819'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=12ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80819'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80819'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80819'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80819'
AND answersmc.qoid = qoptions.qoid
getnetworkid (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT *
	FROM allreports
	WHERE answerid = '80819'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getprice (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80808'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80808'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80808'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80808'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80808'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80808'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80808'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80808'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80808'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80808'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80808'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80808'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80808'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80808'
AND answersmc.qoid = qoptions.qoid
getnetworkid (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT *
	FROM allreports
	WHERE answerid = '80808'
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getprice (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80792'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80792'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80792'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80792'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80792'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80792'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80792'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80792'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80792'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80792'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=12ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80792'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80792'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80792'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80792'
AND answersmc.qoid = qoptions.qoid
getnetworkid (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT *
	FROM allreports
	WHERE answerid = '80792'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getprice (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80757'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80757'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80757'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=7ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80757'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80757'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80757'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80757'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80757'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80757'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80757'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80757'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80757'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80757'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80757'
AND answersmc.qoid = qoptions.qoid
getnetworkid (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
	SELECT DISTINCT *
	FROM allreports
	WHERE answerid = '80757'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 22:16:03.003
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
checkrptarticles (Datasource=reports, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:16:03.003
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-10-22"
     
         and rptarticlenetworks.networkid = 39 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 22:16:03.003
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 1
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 22:16:03.003
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 39 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:16:03.003
SELECT  hiimg
FROM rptarticles
where rptarticleID = 1
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 22:16:03.003
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 39 
	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-10-22"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=6ms, Records=4) in /home/www/html/navcontentbox.cfm @ 22:16:03.003
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 39 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:16:03.003
		Select summary, hiimg 
		FROM answers
         where answerid = 75003
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=6ms, Records=4) in /home/www/html/navcontentbox.cfm @ 22:16:03.003
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 39 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 22:16:03.003
		Select summary, hiimg 
		FROM answers
         where answerid = 68442
         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/eetr/tips.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/eetr/tips.cfm
QUERY_STRING=topicid=9&tipcategoryid=2831&networkid=39&s=1&sort=r&slug=Expats&slug2=Real-Estate-in-Ecuador
REMOTE_ADDR=173.245.54.141
REMOTE_HOST=173.245.54.141
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/eetr/tips.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Client Variables:
cfid=39045863
cftoken=76881438
hitcount=1
lastvisit={ts '2020-10-22 22:16:01'}
timecreated={ts '2020-10-22 22:16:01'}
urltoken=CFID=39045863&CFTOKEN=76881438
Cookie Variables:
CFID=39045863
CFTOKEN=76881438
Session Variables:
cfid=39045863
cftoken=76881438
sessionid=IBEXPATEXCHANGE_39045863_76881438
urltoken=CFID=39045863&CFTOKEN=76881438
URL Parameters:
networkid=39
s=1
slug=Expats
slug2=Real-Estate-in-Ecuador
sort=r
tipcategoryid=2831
topicid=9
Debug Rendering Time: 23 ms