|
|
|
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, %Sudbury Area%, published)[0][5]
query1->0.009907
Heirarchy0.003796 -->0.112112 | | | NotSold0.001042 -->0.113154 NotSold0.006381 -->0.119535
| AD #5039 | Convenience Store | 6160 - 1 Hwy 69 North, Hanmer, ON, P3P 1K6 | BEST OFFER |
|
| Convenience Store For Sale
* Excellent location and ample parking
* Next to restaurant
* Approx. 1500 sq. ft.
* Lotto machine, scratch tickets, movie rentals
* 15 km from Sudbury
* Approx. 26,000 population and growing
* 4 employees
If you enjoy outdoor sports, this is the location for you
Be your own... read more |
| Top of Page View Ad Details |
NotSold0.003286 -->0.122821
| AD #5020 | 41 acres of land on Lake Lauzon northshore of Lake Huron | Lake Lauzon area | open to offers |
|
| Lakeshore Estate - 41 acres Lake Lauzon, northshore of Lake Huron in Algoma Mills, Ontario, Hwy 17.
Main house and guest houses and storage buildings. Own water supply.
Four minutes off Hwy 17.
satellite view at http://www.maps.google.com
46 12' 21.69" N 82 43' 42.63" W
Phone 705-849-1100.... read more |
| Top of Page View Ad Details |
NotSold0.002284 -->0.125105
| AD #5109 | Motel with 10 units | Corner Queensway st/Hwy 6, Espanola South, Ontario | 1,220,000.00 |
|
| Recently Renovated
Small Motel with living quarters, 10 rooms on 18 acres of prime commercial property
on main highway in Espanola south, the new downtown.
Gateway to Manitoulin Island.... read more |
| Top of Page View Ad Details |
Sold0.001795 -->0.1269
| AD #5049 | Bungalow | Warren, Ontario | $169,900.00 |
|
| SOLD Immaculately kept bungalow located 40 minutes beween Sudbury and North Bay, 20 minutes from Sturgeon Falls located in Warren. Features 3 + one bedroms, 2 baths, ( 1- 4PC and 1- 3PC) Open concept living room, kitchen, dining room with patio doors onto deck over looking large backyard. Large lot (98x150) with trees and vegetable garden,... read more |
| Top of Page View Ad Details |
| | | 1 |
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, %Sudbury Area%, published)[0][5]
query1->0.009907
query3->0.0247 -->0.05407
(48)
query3->0.010768 -->0.064838
(48)
query3->0.023041 -->0.087879
(48)
query3->0.009078 -->0.096957
(48)
query3->0.011359 -->0.108316
(48)+
runtime(0.134242) | | | |
|
| |
