---

Debug:
REGION:00028Cats
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, %Edmonton And Area%, published)[0][13]
query1->0.028952
query3->0.07054 -->0.113905
(28)
query3->0.009674 -->0.123579
(28)
query3->0.044363 -->0.167942
(28)
query3->0.023221 -->0.191163
(28)
query3->0.021872 -->0.213035
(28)
query3->0.179758 -->0.392793
(28)
query3->0.022533 -->0.415326
(28)
query3->0.021623 -->0.436949
(28)
query3->0.020914 -->0.457863
(28)
query3->0.008445 -->0.466308
(28)
query3->0.01095 -->0.477258
(28)
query3->0.010768 -->0.488026
(28)
query3->0.016275 -->0.504301
(28)+
runtime(0.740081)