City of Edmonton

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 <> 810 ORDER BY p.post_title ASC

Other partners

At the heart of the City of Edmonton is a community of 14,000 staff. We are a corporation serving nearly one million residents, with more than 300 programs and services. We are city builders, problem solvers, listeners and doers. Our work connects us to almost every aspect of our citizens’ daily lives. We are citizens too, proudly serving our neighbours in the most open and responsive way we can.