Home Mexico Forum Mexico Guide Moving to Mexico Real Estate Healthcare in Mexico
Mexico
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 Mexico offer advice about renting and buying homes in cities and towns in Mexico. Topics covered include the rental and buying process in Mexico, 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 Puerto Penasco, Mexico

By mexicanbeachbum

Puerto Penasco, Mexico (also knows as Rocky Point), is an increasingly popular expat enclave on the Sea of Cortez. 20 years ago, Puerto Penasco as a sleepy, fishing village. Today, the coastline is dotted with condos and resorts and the downtown bustling with tourists. Continue Reading

12 Tips for Living in Playa Del Carmen, Mexico

By Jamais

An expat talks about what it's like living in Playa del Carmen, Mexico. Did you know that there's a large Italian expat community in Playa del Carmen with a Little Italy and lots of Italian restaurants? Continue Reading

12 Tips for Living in Playa Del Carmen, Mexico

By Jamais

An expat talks about living in Playa del Carmen, Mexico. Although the cost of living in Playa del Carmen is high for Mexico, an expat couple can dine out for $20 and have their laundry done for $5 per week. Continue Reading

12 Tips for Living in Merida, Mexico

By Dlee1154

An expat talks about what it's like living in beautiful Merida, Mexico where the expat community is thriving -- there's even an expat bowling league. The Merida English Library holds wine tastings, plays, concerts and more. Real estate prices are low compared to the US, but that may not be for long. Continue Reading

12 Tips for Living in Playa del Carmen, Mexico

By bpeay

An expat who moved to Playa del Carmen several months ago talks about meeting other expats in Playa, the lower cost of living, area hospitals, shopping, restaurants in Playa, nightlife and much more. Continue Reading

Real Estate Listings in Mexico

Add a Property Listing

House for Sale

Chelem, Mexico

3 Bedroom / 2 Full Bath / 0 Half Bath

Furnished

Price: $253,999 USD

Living Space: 1600 sq. feet

House for Sale in Chelem, Mexico

Two story home w/apt just steps from the beach and walking distance to the quaint expat beach town of Chelem, Mexico. Only 30 minutes from the beautiful city of Merida with shopping, dining and great affordable medical services. Cost of living here makes this the perfect retirement option.

View Full Listing

House for Sale

Lomas de Tecamachalco, México City, Mexico

4 Bedroom / 5 Full Bath / 1 Half Bath

Unfurnished

Price: $830,000

Living Space: 5382

House for Sale in Lomas de Tecamachalco, México City, Mexico

Modern home with hardwood floors, sauna, central air and heat, intercom throughout and video doorbell. Yard and terrace with grill. Quiet street with park for kids and pets, walking distance to bus stop, Starbucks, restaurants, pharmacy and grocery stores.

View Full Listing

Cigna Expat Health InsuranceExpatriate Health Insurance

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

15-Expats-Talk-About-Life-in-Mexico15 Expats Talk About Life in Mexico

Expats share some insight into what it's like to live in Mexico on a day-to-day basis once you actually make the move and get there.
Expats share some insight into what it's like to live in Mexico on a day-to-day basis once you actually make the move and get there....

Latin-AmericaExpats Talk About The Biggest Challenges They Face Living in Latin America

Expats talk about some of the biggest challenges they've faced living in Latin America. Whether you're moving to Panama City or Punta del Este, this article is a must read to help you prepare (hint: you'll be much happier if you learn the language) and adjust your expectations (realities: the roads are rough, the pace of life is slower and bureaucracy is unavoidable). Despite all of the challenges, the list of what expats like about life in Latin America far exceeds the challenges.

Expats talk about some of the biggest challenges they've faced living in Latin America. Whether you're moving to Panama City or Punta del Este, this article is a must read to help you prepare (hint:...

Expats-in-Mexico-CityLiving in Mexico City

Expats talk about the best places to live in Mexico City, living near work to avoid hours of traffic every day, crime in Mexico City, international schools and much more.

Expats talk about the best places to live in Mexico City, living near work to avoid hours of traffic every day, crime in Mexico City, international schools and much more. ...

Retirement-In-ApizacoAn Expat Shares What it's Like Retiring in Apizaco, Mexico

A retiree in Apizaco, Mexico talks about retiring in Mexico. He and his wife decided to move to Mexico for the lower cost of living and climate.

A retiree in Apizaco, Mexico talks about retiring in Mexico. He and his wife decided to move to Mexico for the lower cost of living and climate. ...

Moving-To-Puerto-PenascoAn Expat Talks about Moving to Puerto Penasco, Mexico

An expat talks about living in the Mirador section on Puerto Penasco, Mexico - the close proximity to Tuscon, the lower cost of living finding a rental and more.

An expat talks about living in the Mirador section on Puerto Penasco, Mexico - the close proximity to Tuscon, the lower cost of living finding a rental and more....

Mexico 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 29-May-20 08:01 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.62.46
Host Name 172.69.62.46


Execution Time

Total Time Avg Time Count Template
547 ms 547 ms 1 /home/www/html/eetr/tips.cfm
288 ms 288 ms 1 /home/www/html/eetr/Application.cfm
213 ms 43 ms 5 /home/www/html/eetr/tipsrentalproperty.cfm
147 ms 147 ms 1 /home/www/html/eetr/tipsrentalproperties_include.cfm
96 ms 96 ms 1 /home/www/html/navtop_rdesign5.cfm
94 ms 47 ms 2 /home/www/html/eetr/tipsrentalproperties_includebox.cfm
89 ms 89 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
43 ms 4 ms 10 /home/www/html/eetr/rewritetipheadingstate.cfm
28 ms 28 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/navcontentbox.cfm
27 ms 27 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
4 ms 1 ms 5 /home/www/html/eetr/rewriterealtorlink.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 0 ms 5 /home/www/html/eetr/rewritetipheading.cfm
1 ms 1 ms 1 /home/www/html/eetr/tippaginglinkmaker.cfm
1 ms 1 ms 1 /home/www/html/eetr/tippagingnew.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 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 5 /home/www/html/eetr/rewritealtimage.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 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 2 /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
0 ms 0 ms 2 /home/www/html/rewritereport.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
835 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 @ 20:01:42.042
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=286ms, Records=1) in /home/www/html/eetr/Application.cfm @ 20:01:42.042
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=2ms, Records=153) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:01:42.042
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=2ms, Records=21) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:01:42.042
	Select *
	From citynetworks
	Where networkID = 77
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:01:42.042
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 77 
getpropertycountries (Datasource=tipripper, Time=46ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:01:43.043
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=33ms, Records=12) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:01:43.043
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 @ 20:01:43.043
SELECT * 
FROM sitecategories
WHERE sitecategories.tipcategoryid = 2831 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:01:43.043
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 @ 20:01:43.043
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 77 
GetClassifieds (Datasource=tipripper, Time=1ms, Records=5) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:01:43.043
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 = 77 
AND allreports.networkid = 77 
and allreports.tipcategoryid <> 2791

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

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

WHERE topicid = 9 
getcountryphoto (Datasource=expert, Time=1ms, Records=62) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:01:43.043
SELECT *
FROM countryphotos
WHERE networkid = 77 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 20:01:43.043
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
and logtime > "2020-02-28"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 20:01:43.043
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
and logtime > "2020-05-29 00:00:00.000"
and logtime < "2020-05-29 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 @ 20:01:43.043
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
and logtime > "2020-05-22"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 20:01:43.043
	SELECT *
	From contentcountcountry
	Where networkid = 77 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 20:01:43.043
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-05-28"
    and fromDate < "2020-05-29"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 20:01:43.043
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getcount (Datasource=tipripper, Time=1ms, Records=157) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT answerid
FROM allreports, sitecategories
WHERE rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
and networkid = 77 
order by city ASC, answerid DESC
getpropertycountries (Datasource=tipripper, Time=2ms, Records=20) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT allreports.networkname, allreports.networkid, shortname, shortnamecap
FROM allreports, Networks
WHERE allreports.topicid = 6
AND "2020-05-29" < allreports.enddate
and Networks.networkid = allreports.networkid
group by allreports.networkid
order by allreports.networkname ASC
getname (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tippaginglinkmaker.cfm @ 20:01:43.043
	Select *
	From Networks
	Where networkid = 77 
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT *
FROM users
WHERE userid = '213464'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '7038'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
	SELECT summary 
	FROM answers
	WHERE answerid = 79937 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 79937 
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79937'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79937'
	and qid = 391
	
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
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=3ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79937'
	and qid = 402
gettext401 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79937'
	and qid = 401
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79937'
	and qid = 391
checkexpert (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
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-05-28 20:01:43'}
and expertusers.enddate > {ts '2020-05-29 20:01:43'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 213464
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 @ 20:01:43.043
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-05-29 20:01:43'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 213464
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 @ 20:01:43.043
SELECT username
FROM users
WHERE userid = 213464 
getauthorfirst (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 213464
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 @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 213464
and answers.reviewed = 'y'
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 213464
and answers.reviewed = 'y'
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 213464
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 @ 20:01:43.043
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 213464
and answers.reviewed = 'y'
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
checkstatus (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 20:01:43.043
SELECT *
FROM expertusers
WHERE userid = 213464
and startdate <{ts '2020-05-28 20:01:43'}
and enddate > {ts '2020-05-29 20:01:43'} 
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT *
FROM users
WHERE userid = '215485'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '5209'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
	SELECT summary 
	FROM answers
	WHERE answerid = 80177 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80177 
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80177'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80177'
	and qid = 391
	
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
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=3ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80177'
	and qid = 402
gettext401 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80177'
	and qid = 401
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80177'
	and qid = 391
checkexpert (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
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-05-28 20:01:43'}
and expertusers.enddate > {ts '2020-05-29 20:01:43'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 215485
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 @ 20:01:43.043
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-05-29 20:01:43'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 215485
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 @ 20:01:43.043
SELECT username
FROM users
WHERE userid = 215485 
getauthorfirst (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 215485
and answers.reviewed = 'y'
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 215485
and answers.reviewed = 'y'
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 215485
and answers.reviewed = 'y'
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 215485
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 @ 20:01:43.043
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 215485
and answers.reviewed = 'y'
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
checkstatus (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 20:01:43.043
SELECT *
FROM expertusers
WHERE userid = 215485
and startdate <{ts '2020-05-28 20:01:43'}
and enddate > {ts '2020-05-29 20:01:43'} 
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT *
FROM users
WHERE userid = '215485'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getlocationtag3 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '5209'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
	SELECT summary 
	FROM answers
	WHERE answerid = 80250 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80250 
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80250'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80250'
	and qid = 391
	
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
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=3ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80250'
	and qid = 402
gettext401 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80250'
	and qid = 401
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80250'
	and qid = 391
checkexpert (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
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-05-28 20:01:43'}
and expertusers.enddate > {ts '2020-05-29 20:01:43'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 215485
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 @ 20:01:43.043
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-05-29 20:01:43'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 215485
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 @ 20:01:43.043
SELECT username
FROM users
WHERE userid = 215485 
getauthorfirst (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 215485
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 @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 215485
and answers.reviewed = 'y'
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 215485
and answers.reviewed = 'y'
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 215485
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 @ 20:01:43.043
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 215485
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 @ 20:01:43.043
SELECT *
FROM expertusers
WHERE userid = 215485
and startdate <{ts '2020-05-28 20:01:43'}
and enddate > {ts '2020-05-29 20:01:43'} 
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT *
FROM users
WHERE userid = '160554'
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '4177'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
	SELECT summary 
	FROM answers
	WHERE answerid = 80408 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80408 
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80408'
	and qid = 391
	
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80408'
	and qid = 391
	
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
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 @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80408'
	and qid = 402
gettext401 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80408'
	and qid = 401
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80408'
	and qid = 391
checkexpert (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
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-05-28 20:01:43'}
and expertusers.enddate > {ts '2020-05-29 20:01:43'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 160554
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 @ 20:01:43.043
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-05-29 20:01:43'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 160554
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 @ 20:01:43.043
SELECT username
FROM users
WHERE userid = 160554 
getauthorfirst (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 160554
and answers.reviewed = 'y'
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 160554
and answers.reviewed = 'y'
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 160554
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 @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 160554
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 @ 20:01:43.043
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 160554
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 @ 20:01:43.043
SELECT *
FROM expertusers
WHERE userid = 160554
and startdate <{ts '2020-05-28 20:01:43'}
and enddate > {ts '2020-05-29 20:01:43'} 
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT *
FROM users
WHERE userid = '119784'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getlocationtag3 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '5209'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
	SELECT summary 
	FROM answers
	WHERE answerid = 79542 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:01:43.043
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 79542 
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79542'
	and qid = 391
	
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79542'
	and qid = 391
	
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
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=3ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79542'
	and qid = 402
gettext401 (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79542'
	and qid = 401
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79542'
	and qid = 391
checkexpert (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
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-05-28 20:01:43'}
and expertusers.enddate > {ts '2020-05-29 20:01:43'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 119784
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=1ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
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-05-29 20:01:43'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 119784
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 @ 20:01:43.043
SELECT username
FROM users
WHERE userid = 119784 
getauthorfirst (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 119784
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 @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 119784
and answers.reviewed = 'y'
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 119784
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 @ 20:01:43.043
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 119784
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 @ 20:01:43.043
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 119784
and answers.reviewed = 'y'
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
checkstatus (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 20:01:43.043
SELECT *
FROM expertusers
WHERE userid = 119784
and startdate <{ts '2020-05-28 20:01:43'}
and enddate > {ts '2020-05-29 20:01:43'} 
getclass (Datasource=tipripper, Time=1ms, Records=2) in /home/www/html/eetr/tipsrentalproperties_include.cfm @ 20:01:43.043
SELECT *
FROM allreports, answers
WHERE allreports.topicid = 6
and allreports.networkid = 77
and allreports.hide <> 'y'
and answers.answerid = allreports.answerid
and "2020-05-29" < allreports.enddate
and (answers.paid = 'yes' or answers.paid = 'free')

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

    ORDER by articles.articleID desc
    
checkretirefeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 20:01:43.043
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 77 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 20:01:43.043
		Select summary, hiimg 
		FROM answers
         where answerid = 74253
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=6ms, Records=4) in /home/www/html/navcontentbox.cfm @ 20:01:43.043
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 77 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 20:01:43.043
		Select summary, hiimg 
		FROM answers
         where answerid = 75685
         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=77&s=1&sort=r&slug=Expats&slug2=Real-Estate-in-Mexico
REMOTE_ADDR=172.69.62.46
REMOTE_HOST=172.69.62.46
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=28659780
cftoken=19046353
hitcount=1
lastvisit={ts '2020-05-29 20:01:42'}
timecreated={ts '2020-05-29 20:01:42'}
urltoken=CFID=28659780&CFTOKEN=19046353
Cookie Variables:
CFID=28659780
CFTOKEN=19046353
Session Variables:
cfid=28659780
cftoken=19046353
sessionid=IBEXPATEXCHANGE_28659780_19046353
urltoken=CFID=28659780&CFTOKEN=19046353
URL Parameters:
networkid=77
s=1
slug=Expats
slug2=Real-Estate-in-Mexico
sort=r
tipcategoryid=2831
topicid=9
Debug Rendering Time: 12 ms