|
|
|
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, %South West Saskatchewan%, published)[0][2]
query1->0.010249
Heirarchy0.001352 -->0.061081
|
|
Regions of
South West Saskatchewan | | | | NotSold0.00087699999999996 -->0.061958
| AD #3027 | 35 Acres (more or less) | Cypress Hills, R.M. of Piapot Saskatchewan | $3,000 per Acre |
|
| Unique parcel at the foot of north slope - Cypress Hills
Improvements:
Has power and water well powered with pump. Natural gas line located approximately 25 to 30 ft. outside the south east corner of the property. Skull Creek water way runs full length of the property. Fifteen acres flat hay meadow fenced out. Balance is undulating native... read more |
| Top of Page View Ad Details |
NotSold0.00188 -->0.063838
| AD #3013 | (Business) | Consul, SW Corner of Saskatchewan | $149,000.00 |
|
| Hotel For Sale: Busy Bar(smoking patio),8 Rooms, Restaurant, 3 Bedroom Living Quarters attached, VLTS, ATM. Lots of Oil & Gas activity in area. Cattle & Grain Farms. Friendly small town/ Co-op Grocery Store, with Gas Station, agro&lumber, Credit Union, School(K-12), Post Office, Hair Shop, Agro Supplies, Oil Companies, Weekly Doctor, Churches,... 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, %South West Saskatchewan%, published)[0][2]
query1->0.010249
query3->0.005975 -->0.039118
(17)
query3->0.020611 -->0.059729
(17)+
runtime(0.068735) | | | |
|
| |
