---

Debug:
REGION:00055Cats
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, %Southwestern Ontario%, published)[0][17]
query1->0.019804
query3->0.027653 -->0.060333
(55)
query3->0.008565 -->0.068898
(55)
query3->0.023066 -->0.091964
(55)
query3->0.017065 -->0.109029
(55)
query3->0.018699 -->0.127728
(55)
query3->0.015136 -->0.142864
(55)
query3->0.013109 -->0.155973
(55)
query3->0.018784 -->0.174757
(55)
query3->0.011005 -->0.185762
(55)
query3->0.032484 -->0.218246
(55)
query3->0.011606 -->0.229852
(55)
query3->0.018786 -->0.248638
(55)
query3->0.0093259999999999 -->0.257964
(55)
query3->0.011793 -->0.269757
(55)
query3->0.017639 -->0.287396
(55)
query3->0.021555 -->0.308951
(55)
query3->0.012837 -->0.321788
(55)+
runtime(0.488958)