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]
| AD #3012 | tudor style 2 storey (Home) | 918 Spencer Cres, saskatoon, sk | 397,000 |
|
| Attractive custom built 2 storey in popular Silverwood w/ quality workmanship Recent renos main- bathrm, hardwd & flrg, garden door,deck basement -rumpus room, bath & den/bdrm. Dbl garage ins.& drywalled w/ nat gas heat, sink & 220 plug. Cen.vac/air.Also features undergrnd sprinklers, large backyard w/ street access and rv parking. Walking... [ read more] |
| [Top] |
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]
