No Listings Found.

Build HierarchyQUERY[SELECT DISTINCT c.*, h.name as h_name FROM cms_module_listings c INNER JOIN cms_module_listings_prodtohier ph ON ph.listing_id = c.id INNER JOIN cms_module_listings_hierarchy h ON ph.hierarchy_id = h.id WHERE c.status = 'published' and (c.listing_date < now() or c.listing_date is null) AND upper(h.long_name) LIKE upper(?) ORDER BY listing_date desc]

---

Debug:

Build HierarchyQUERY[SELECT DISTINCT c.*, h.name as h_name FROM cms_module_listings c INNER JOIN cms_module_listings_prodtohier ph ON ph.listing_id = c.id INNER JOIN cms_module_listings_hierarchy h ON ph.hierarchy_id = h.id WHERE c.status = 'published' and (c.listing_date < now() or c.listing_date is null) AND upper(h.long_name) LIKE upper(?) ORDER BY listing_date desc]
Poke: northern_manitoba
Look: northern_manitoba in alberta
Look: northern_manitoba in british_columbia
Look: northern_manitoba in saskatchewan
Look: northern_manitoba in manitoba
Look: northern_manitoba in ontario
Look: northern_manitoba in quebec
Look: northern_manitoba in newfoundland
Look: northern_manitoba in nova_scotia
Look: northern_manitoba in prince_edward_island
Look: northern_manitoba in new_brunswick
Look: northern_manitoba in yukon