|
|
|
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, %Red Deer And Area%, published)[0][3]
query1->0.008386
Heirarchy0.035844 -->0.107636
|
|
Regions of
Red Deer And Area | | | | NotSold0.001567 -->0.109203
| AD #2099 | Country Tavern and Liquor Store | Penhold, Alberta | $800,000 plus inventory |
|
| Country Tavern and Liquor Store
Turnkey operation, Tavern was fully renovated in 2010, all new
Located in Penhold, Alberta on Highway 2A, just 10 KM from Red Deer. Two story building with owners accommodation on second floor. Some kitchen equipment included, a 25 seat restaurant could be opened. An owner... read more |
| Top of Page View Ad Details |
NotSold0.002252 -->0.111455 NotSold0.003667 -->0.115122
| AD #2100 | 4-plex (1 unit) | 5029 48st. Unit B, Olds AB, Canada | $205,000.00 |
|
| Up-graded condo unit, Teak hard-wood floors in living-room and dining area, Faux wood blinds, 5 appliances including stacked W/D and dishwasher. Bedrooms downstairs, quiet area close to down-town and Olds College. Condo fees 75.00 a month Rented at present, please phone owner for showings Beautiful tile in kitchen and entry and upstairs bathroom,... 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, %Red Deer And Area%, published)[0][3]
query1->0.008386
query3->0.008833 -->0.039107
(29)
query3->0.008669 -->0.047776
(29)
query3->0.024016 -->0.071792
(29)+
runtime(0.120264) | | | |
|
| |
