City of Ottawa

SELECT DISTINCT (p.post_title), p.post_name FROM im3_posts AS p LEFT JOIN im3_term_relationships AS r on p.ID = r.object_id LEFT JOIN im3_icl_translations AS t on t.element_id = p.ID WHERE r.term_taxonomy_id = 405 AND t.language_code like "en" AND p.post_status like "publish" AND p.ID <> 608 ORDER BY p.post_title ASC

Other partners

Ottawa is home to almost 1 million residents, and is blessed with great urban neighbourhoods, quaint rural villages and dynamic suburban communities. Canada’s capital city sits on the banks of the Ottawa River, and is home to the scenic Rideau Canal, the Parliament buildings, and one of Canada's largest concentrations of hi-tech firms. The City of Ottawa is a complex service delivery organization. We deliver our services with care so that we can plow roads in a timely manner, provide safe drinking water, run animated recreation programs, inspect new homes, and deliver more than a hundred other City services. We employ approximately 17,000 employees, manage a $3.2 billion budget, and have responsibility for managing over $26 billion in public assets.