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: swift_current
Look: swift_current in alberta
Look: swift_current in british_columbia
Look: swift_current in saskatchewan
Look: swift_current in manitoba
Look: swift_current in ontario
Look: swift_current in quebec
Look: swift_current in newfoundland
Look: swift_current in nova_scotia
Look: swift_current in prince_edward_island
Look: swift_current in new_brunswick
Look: swift_current in yukon