select count(*) as unmounted_application_count from portal_datasources pd where not exists (select 1 from portal_datasource_map pdm where pdm.package_id = :package_id and pdm.datasource_id = pd.datasource_id) and pd.application is not null ad_return_template