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 #3022 | 4 quarters of farm land (Land) | South East Saskatchewan |
|
| Land locations for sale are: W 1/2 35 04 13 W2 (2 qtres); NW1/4 05 05 13 W2; SW1/4 08 05 13 W2. Land sold by the quarter or all together. All land is cultivated, no fences. pastures, buildings. It is situated south of Weyburn, SK.
Serious buyers please call.
... [ 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]