fix spec to use HAVING in connecting_routes