---

Debug:
REGION:00030Cats
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, %Calgary And Area%, published)[0][20]
query1->0.032088
query3->0.265658 -->0.331888
(110)
query3->0.028573 -->0.360461
(110)
query3->0.033155 -->0.393616
(110)
query3->0.016694 -->0.41031
(110)
query3->0.010212 -->0.420522
(110)
query3->0.028953 -->0.449475
(109)
query3->0.025072 -->0.474547
(108)
query3->0.0094959999999999 -->0.484043
(108)
query3->0.024537 -->0.50858
(104)
query3->0.354364 -->0.862944
(104)
query3->0.043779 -->0.906723
(104)
query3->0.119359 -->1.026082
(104)
query3->0.017229 -->1.043311
(104)
query3->0.04214 -->1.085451
(106)
query3->0.017892 -->1.103343
(106)
query3->0.033088 -->1.136431
(106)
query3->0.270792 -->1.407223
(106)
query3->0.070648 -->1.477871
(106)
query3->0.034841 -->1.512712
(107)
query3->0.031778 -->1.54449
(105)+
runtime(1.748963)