select portal_id, name from portals where package_id = :package_id and template_id is not null