Uzbekistan
Resources
City Guides
JoinSign In
AGS Worldwide Movers

Houses for Sale and Rent in Uzbekistan

Real Estate Listings Property Advice Local Experts My Properties

Find Houses for Sale in Uzbekistan, Houses for Rent in Uzbekistan, Home Exchange Uzbekistan, Roomates, Office Space, Retail Space, B&Bs for Sale in Uzbekistan, Hotels for Sale

Sort Listings By: Newest | City

Add a Property Listing

House for Rent

Tashkent, Uzbekistan

7 Bedroom / 8 Full Bath / 2 Half Bath

Furnished

Price: 8000

Living Space: 400

View Full Listing

House for Rent in Tashkent, Uzbekistan

New Superior Townhouse for rent in Tashkent. Sprawling three floors, this seven-bedroom house is a rarity of palatial proportions nestled in one of the richest district of the Tashkent city near Tashkent State Agrarian University. Encircled by beautifully manicured gardens, complete with heated swimming pool, the ground floor comprises a crittal-fronted reception, kitchen, guest room and a formal dining room.

House for Rent

Tashkent, Uzbekistan

3 Bedroom / 3 Full Bath / 1 Half Bath

Furnished

Price: 2500

Living Space: 250 sq meters

View Full Listing

House for Rent in Tashkent, Uzbekistan

Beautiful duplex classic house for rent in central Tashkent! Welcome to this beautiful duplex classic house which features 3 bedrooms, 3 baths with a total of 450 sq m of living space plus private outdoor space in the heart of Tashkent city near Kosmonavtov tube station. Open concept living room and custom dining area with high ceilings and huge windows offering plenty of natural light. Huge open space living room with a marble fireplace making it a great place for entertaining.

Apartment/Flat for Rent

Tashkent, Uzbekistan

2 Bedroom / 2 Full Bath / 1 Half Bath

Furnished

Price: 800

Living Space: 90

View Full Listing

Apartment for Rent in Tashkent, Uzbekistan

Great price for a duplex! New flat for rent in Tashkent. Great price for a new stunningly beautiful two bedroom duplex apartment on the new building (new development) with lift. The property is the perfect combination of modern and classic features, offering a generous living space.

Apartment/Flat for Rent

Tashkent, Uzbekistan

3 Bedroom / 2 Full Bath / 1 Half Bath

Furnished

Price: 2000

Living Space: 110

View Full Listing

Apartment for Rent in Tashkent, Uzbekistan

A truly spectacular 3 bedrooms flat for rent in central Tashkent! A truly spectacular first floor apartment recently refurbished to a high specification, benefiting from bespoke furniture throughout and all top of the range appliances. First time lease 3 bedrooms apartments on new development with security guards and private parking.

House for Rent

Tashkent, Uzbekistan

3 Bedroom / 4 Full Bath / 1 Half Bath

Furnished

Price: 1500

Living Space: 250 sq meters

View Full Listing

House for Rent in Tashkent, Uzbekistan

Wonderful family house for rent in Tashkent. Near Tashkent International School.

House for Rent

Tashkent, Uzbekistan

4 Bedroom / 5 Full Bath / 1 Half Bath

Furnished

Price: 4000

Living Space: 300 sq meters

View Full Listing

House for Rent in Tashkent, Uzbekistan

Immaculately designed house for rent in Tashkent!

House for Rent

Tashkent, Uzbekistan

7 Bedroom / 8 Full Bath / 1 Half Bath

Furnished

Price: 8000

Living Space: 400 sq meters

View Full Listing

House for Rent in Tashkent, Uzbekistan

Gorgeous new built 3 storey house for rent in Tashkent!

House for Rent

Tashkent, Uzbekistan

4 Bedroom / 5 Full Bath / 1 Half Bath

Furnished

Price: 2500

Living Space: 350 sq meters

View Full Listing

House for Rent in Tashkent, Uzbekistan

Beautiful Classic summer house for rent in central Tashkent!

House for Rent

Tashkent, Uzbekistan

4 Bedroom / 3 Full Bath / 1 Half Bath

Furnished

Price: 2000

Living Space: 300 sq meters

View Full Listing

House for Rent in Tashkent, Uzbekistan

A truly beautiful family house for rent in the heart of Tashkent!

House for Rent

Tashkent, Uzbekistan

9 Bedroom / 8 Full Bath / 2 Half Bath

Furnished

Price: 3000

Living Space: 320 sq meters

View Full Listing

House for Rent in Tashkent, Uzbekistan

A stylish three storey 9 bedrooms classic house for rent in Tashkent! Located on Hirmontepa (ex- Nikitina) street, that combines contemporary and traditional features with practical family living. The property benefits from exceptionally high ceilings throughout the principle floors, providing for the most spacious feeling kitchen breakfast room leading out onto the charming south facing garden beyond.

Apartment/Flat for Rent

Tashkent, Uzbekistan

3 Bedroom / 1 Full Bath / 0 Half Bath

Furnished

Price: 800

Living Space: 80

View Full Listing

Apartment for Rent in Tashkent, Uzbekistan

An amazing price for a new 3 bedrooms flat for rent in central Tashkent!

Cigna Expat Health InsuranceExpatriate Health Insurance

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

10-Tips-for-Living-in-Estonia10 Tips for Living in Estonia

Estonia has a lower cost of living, welcoming locals and rich traditions. As of August 1, 2020, they're also making it easier for global nomads to spend up to a year working remotely from Estonia. What to pack? Bring your warm, reflective clothing to prepare for the long winter.

Estonia has a lower cost of living, welcoming locals and rich traditions. As of August 1, 2020, they're also making it easier for global nomads to spend up to a year working remotely from Estonia. W...

Healthcare-in-EstoniaHealthcare in Estonia

Medical care in Estonia is no up to Western standards, but is best in Tallinn, Tartu and Parnu. Our Estonia Healthcare Guide covers health insurance, finding an English-speaking doctor, best hospitals and more.

Medical care in Estonia is no up to Western standards, but is best in Tallinn, Tartu and Parnu. Our Estonia Healthcare Guide covers health insurance, finding an English-speaking doctor, best hospitals...

Uzbekistan 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 14-Aug-20 12:17 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.62.244
Host Name 172.69.62.244


Execution Time

Total Time Avg Time Count Template
886 ms 886 ms 1 /home/www/html/eetr/tips.cfm
574 ms 52 ms 11 /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm
293 ms 293 ms 1 /home/www/html/eetr/Application.cfm
104 ms 5 ms 22 /home/www/html/eetr/rewritetipheadingstate.cfm
94 ms 94 ms 1 /home/www/html/navtop_rdesign5.cfm
88 ms 88 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
23 ms 23 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
22 ms 22 ms 1 /home/www/html/navcontentbox.cfm
22 ms 22 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/bottomnav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/eetr/constants.cfm
1 ms 1 ms 1 /home/www/html/eetr/qry_GeneralSet.cfm
1 ms 1 ms 1 /home/www/html/eetr/tippaginglinkmaker.cfm
1 ms 1 ms 1 /home/www/html/eetr/tippagingnew.cfm
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.cfm
1 ms 1 ms 2 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.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 11 /home/www/html/eetr/rewritealtimage.cfm
0 ms 0 ms 11 /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/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign5.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1179 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 @ 12:17:36.036
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=292ms, Records=1) in /home/www/html/eetr/Application.cfm @ 12:17:37.037
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=2ms, Records=153) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:17:37.037
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:17:37.037
	Select *
	From citynetworks
	Where networkID = 116
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:17:37.037
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 116 
getpropertycountries (Datasource=tipripper, Time=46ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:17:37.037
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=34ms, Records=12) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:17:37.037
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 @ 12:17:37.037
SELECT * 
FROM sitecategories
WHERE sitecategories.tipcategoryid = 2831 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:17:37.037
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 = 6 
getname (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:17:37.037
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 116 
GetClassifieds (Datasource=tipripper, Time=0ms, Records=11) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:17:37.037
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, allreports.topicid, allreports.state, allreports.networkname, allreports.enddate, allreports.networkname as country
FROM allreports, answers, Networks
WHERE allreports.topicid = 6
and hide <> 'y'
and answers.answerid = allreports.answerid
and "2020-08-14" < allreports.enddate
and (answers.paid = 'yes' or answers.paid = 'free')
AND Networks.networkid = 116 
AND allreports.networkid = 116 
order by allreports.enddate DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:17:37.037
SELECT *
FROM topics

WHERE topicid = 6
gettopic (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:17:37.037
SELECT *
FROM topics

WHERE topicid = 6 
getcountryphoto (Datasource=expert, Time=0ms, Records=0) in /home/www/html/eetr/eetr_navmeta.cfm @ 12:17:37.037
SELECT *
FROM countryphotos
WHERE networkid = 116 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:17:37.037
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.244'
and logtime > "2020-05-15"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 12:17:37.037
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.244'
and logtime > "2020-08-14 00:00:00.000"
and logtime < "2020-08-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 @ 12:17:37.037
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.244'
and logtime > "2020-08-07"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:17:37.037
	SELECT *
	From contentcountcountry
	Where networkid = 116 
gettopbanner (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 12:17:37.037
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-08-13"
    and fromDate < "2020-08-14"
    and bannerPlacement.networkid = '116'
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 12:17:37.037
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
getcount (Datasource=tipripper, Time=0ms, Records=24) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT answerid
FROM allreports, sitecategories
WHERE rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
and networkid = 116 
order by city ASC, answerid DESC
getpropertycountries (Datasource=tipripper, Time=3ms, Records=25) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT allreports.networkname, allreports.networkid, shortname, shortnamecap
FROM allreports, Networks
WHERE topicid = 6
AND "2020-08-14" < allreports.enddate
and Networks.networkid = allreports.networkid
group by allreports.networkid
order by allreports.networkname ASC
getcountryphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 116 
getname (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tippaginglinkmaker.cfm @ 12:17:37.037
	Select *
	From Networks
	Where networkid = 116 
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT *
FROM users
WHERE userid = '227212'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '5048'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT summary 
	FROM answers
	WHERE answerid = 80730 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80730 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80730 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80730'
	and qid = 391
	
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80730'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=2ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80730'
	and allreports.answerid = '80730'
getprice (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80730'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80730'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80730'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80730'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80730'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80730'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80730'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80730'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80730'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80730'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80730'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80730'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80730'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80730'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT *
FROM users
WHERE userid = '227212'
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '5048'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT summary 
	FROM answers
	WHERE answerid = 80729 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80729 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80729 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80729'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80729'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80729'
	and allreports.answerid = '80729'
getprice (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80729'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80729'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80729'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80729'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80729'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80729'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80729'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80729'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80729'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80729'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80729'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80729'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80729'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80729'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT *
FROM users
WHERE userid = '227212'
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '5048'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT summary 
	FROM answers
	WHERE answerid = 80727 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80727 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80727 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80727'
	and qid = 391
	
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80727'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80727'
	and allreports.answerid = '80727'
getprice (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80727'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80727'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80727'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80727'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80727'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80727'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80727'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80727'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=12ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80727'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80727'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80727'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80727'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80727'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80727'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT *
FROM users
WHERE userid = '227212'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtag3 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '5048'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT summary 
	FROM answers
	WHERE answerid = 80726 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80726 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80726 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80726'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80726'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80726'
	and allreports.answerid = '80726'
getprice (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80726'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80726'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80726'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80726'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80726'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80726'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80726'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80726'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80726'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80726'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80726'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80726'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80726'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80726'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT *
FROM users
WHERE userid = '227352'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtag3 (Datasource=expert, Time=0ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = ''
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT summary 
	FROM answers
	WHERE answerid = 80739 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80739 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80739 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80739'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80739'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80739'
	and allreports.answerid = '80739'
getprice (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80739'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80739'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80739'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80739'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80739'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80739'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80739'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80739'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80739'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80739'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80739'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80739'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80739'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80739'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT *
FROM users
WHERE userid = '227352'
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtag3 (Datasource=expert, Time=1ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = ''
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT summary 
	FROM answers
	WHERE answerid = 80743 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80743 
getphoto (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80743 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80743'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80743'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80743'
	and allreports.answerid = '80743'
getprice (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80743'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80743'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80743'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80743'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80743'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80743'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80743'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80743'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80743'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80743'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80743'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80743'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80743'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80743'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT *
FROM users
WHERE userid = '227352'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtag3 (Datasource=expert, Time=0ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = ''
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT summary 
	FROM answers
	WHERE answerid = 80742 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80742 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80742 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80742'
	and qid = 391
	
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80742'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80742'
	and allreports.answerid = '80742'
getprice (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80742'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80742'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80742'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80742'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80742'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80742'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80742'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80742'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80742'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80742'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80742'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80742'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80742'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80742'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT *
FROM users
WHERE userid = '227352'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtag3 (Datasource=expert, Time=0ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = ''
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT summary 
	FROM answers
	WHERE answerid = 80741 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80741 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80741 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80741'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80741'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80741'
	and allreports.answerid = '80741'
getprice (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80741'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80741'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80741'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80741'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80741'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80741'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80741'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80741'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80741'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80741'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80741'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80741'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80741'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80741'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT *
FROM users
WHERE userid = '227352'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtag3 (Datasource=expert, Time=0ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = ''
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT summary 
	FROM answers
	WHERE answerid = 80740 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80740 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80740 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80740'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80740'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80740'
	and allreports.answerid = '80740'
getprice (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80740'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80740'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80740'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80740'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80740'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80740'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80740'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80740'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80740'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80740'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80740'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80740'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80740'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80740'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT *
FROM users
WHERE userid = '227212'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '5048'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT summary 
	FROM answers
	WHERE answerid = 80728 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80728 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80728 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80728'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80728'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80728'
	and allreports.answerid = '80728'
getprice (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80728'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80728'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80728'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80728'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80728'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80728'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80728'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80728'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80728'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80728'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=11ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80728'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80728'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80728'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80728'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT *
FROM users
WHERE userid = '227212'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '5048'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT summary 
	FROM answers
	WHERE answerid = 80725 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80725 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 12:17:37.037
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80725 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80725'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80725'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80725'
	and allreports.answerid = '80725'
getprice (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80725'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80725'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80725'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80725'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80725'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80725'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80725'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80725'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80725'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:37.037
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80725'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:38.038
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80725'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:38.038
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80725'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:38.038
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80725'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 12:17:38.038
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80725'
AND answersmc.qoid = qoptions.qoid
checkrptarticles (Datasource=reports, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 12:17:38.038
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-08-14"
     
         and rptarticlenetworks.networkid = 116 
    ORDER by rptarticles.rptarticleID desc
    
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 12:17:38.038
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 116 
	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-08-14"

    ORDER by articles.articleID desc
    
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 12:17:38.038
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 116 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/navcontentbox.cfm @ 12:17:38.038
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 116 
          and date > '2013-04-01'
		order by date DESC
gettaxgeneral2 (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navcontentbox.cfm @ 12:17:38.038
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles 
	Where hitopic <> ''
	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-08-14"  
    ORDER by articles.articleID desc  


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=6&tipcategoryid=2831&networkid=116&s=1&sort=r&slug=Real-Estate-&slug2=Houses-for-Sale-in-Uzbekistan
REMOTE_ADDR=172.69.62.244
REMOTE_HOST=172.69.62.244
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=33852368
cftoken=75031275
hitcount=1
lastvisit={ts '2020-08-14 12:17:36'}
timecreated={ts '2020-08-14 12:17:36'}
urltoken=CFID=33852368&CFTOKEN=75031275
Cookie Variables:
CFID=33852368
CFTOKEN=75031275
Session Variables:
cfid=33852368
cftoken=75031275
sessionid=IBEXPATEXCHANGE_33852368_75031275
urltoken=CFID=33852368&CFTOKEN=75031275
URL Parameters:
networkid=116
s=1
slug=Real-Estate-
slug2=Houses-for-Sale-in-Uzbekistan
sort=r
tipcategoryid=2831
topicid=6
Debug Rendering Time: 18 ms