|
|
|
The For Sale By Owner Canada Network 
For Sale By Owner Canada is a FSBO classified ads website.
Dedicated to people who want to advertise their Real Estate properties
for sale and save thousands of dollars in commissions upon selling!
List your Home, Business, Land or other Real Estate properties
and be assured that you have a leader, in FSBO Internet Advertising,
working to make your private sale a very rewarding experience!
|
| | | |
Build HierarchyQUERY
SELECT l.*, t2.*
FROM cms_module_listings l
JOIN cms_module_listings_prodtohier h ON l.id = h.listing_id
JOIN (
SELECT tmp.hierarchy_id, h.name, max( listing_date ) AS max FROM ( SELECT h.hierarchy_id, l.id, l.listing_date from cms_module_listings l
JOIN cms_module_listings_prodtohier h ON l.id = h.listing_id WHERE status = ? AND l.listing_date < now() GROUP BY l.id ) tmp JOIN cms_module_listings_hierarchy h on tmp.hierarchy_id = h.id where upper(h.long_name) LIKE upper(?) group by tmp.hierarchy_id) t2 ON t2.hierarchy_id = h.hierarchy_id WHERE status = ? AND l.listing_date < now() group by l.id order by t2.max desc, t2.name asc, l.listing_date desc
SELECT tmp.hierarchy_id, h.name, max( listing_date ) AS max, h.extra1 as link, count(tmp.id) as count FROM ( SELECT h.hierarchy_id, l.id, l.listing_date from cms_module_listings l
JOIN cms_module_listings_prodtohier h ON l.id = h.listing_id WHERE status = ? AND l.listing_date < now() GROUP BY l.id ) tmp JOIN cms_module_listings_hierarchy h on tmp.hierarchy_id = h.id where upper(h.long_name) LIKE upper(?) group by tmp.hierarchy_id order by max desc, h.name asc
(published, %Northern Saskatchewan%, published)[0][2]
query1->0.0090939999999999
Heirarchy0.001638 -->0.066386
|
|
Regions of
Northern Saskatchewan | | | | NotSold0.000539 -->0.066925
| AD #3058 | 40 meter x 50 meter average | 59 Lots in Blocks 70, 80 and 90, Green Lake, SK | $1600-$3300/Year |
|
| 59 Lakeside Lots are available in Green lake. Lots are large and well treed. The area is picturesque and not over developed. Our lake offers great fishing and many recreational activities like: Hunting, fishing, snowmobiling, and quading. The lots will have roads, approaches, power and phone to property line. The lots are available for 99 year... read more |
| Top of Page View Ad Details |
NotSold0.003053 -->0.069978
| AD #3039 | GROCERY, GAS, FISHING, AUTO, HARDW, CONF, | #1 MAIN ST., CANDLE LAKE SK. | $1,500,000.00 |
|
| CANDLE LAKE FINE FOODS HAS BEEN HERE IN CANDLE LAKE FOR 20 YEARS. WE ARE OPEN YEAR ROUND. THE BUILDING IS WOODEN STRUCTURE WITH METEL SIDEING AND ROOF, AND IS IN EXELLENT CONDITION. IT IS HEATED WITH NATURAL GAS AND IS AIR CONDITIONED. IT IS APROX. 6000 SQ. FEET.
WE ARE AN INDEPENDANT ESSO GAS OUTLET WITH REGULAR,SUPREME, DIESEL, AND PROPANE... read more |
| Top of Page View Ad Details |
| | | |
Debug:
Build HierarchyQUERY
SELECT l.*, t2.*
FROM cms_module_listings l
JOIN cms_module_listings_prodtohier h ON l.id = h.listing_id
JOIN (
SELECT tmp.hierarchy_id, h.name, max( listing_date ) AS max FROM ( SELECT h.hierarchy_id, l.id, l.listing_date from cms_module_listings l
JOIN cms_module_listings_prodtohier h ON l.id = h.listing_id WHERE status = ? AND l.listing_date < now() GROUP BY l.id ) tmp JOIN cms_module_listings_hierarchy h on tmp.hierarchy_id = h.id where upper(h.long_name) LIKE upper(?) group by tmp.hierarchy_id) t2 ON t2.hierarchy_id = h.hierarchy_id WHERE status = ? AND l.listing_date < now() group by l.id order by t2.max desc, t2.name asc, l.listing_date desc
SELECT tmp.hierarchy_id, h.name, max( listing_date ) AS max, h.extra1 as link, count(tmp.id) as count FROM ( SELECT h.hierarchy_id, l.id, l.listing_date from cms_module_listings l
JOIN cms_module_listings_prodtohier h ON l.id = h.listing_id WHERE status = ? AND l.listing_date < now() GROUP BY l.id ) tmp JOIN cms_module_listings_hierarchy h on tmp.hierarchy_id = h.id where upper(h.long_name) LIKE upper(?) group by tmp.hierarchy_id order by max desc, h.name asc
(published, %Northern Saskatchewan%, published)[0][2]
query1->0.0090939999999999
query3->0.009649 -->0.041652
(14)
query3->0.023096 -->0.064748
(14)+
runtime(0.074572) | | | |
|
| |
