-- Sun, 02 Oct 2022 00:20:04 +0200

select distinct p.source, p.source_version, p.priority, coalesce(ps.insts, 0) as insts, p.maintainer
from lintian l
join packages p on p.package = l.package and p.version = l.package_version
left join popcon_src ps on p.source = ps.source
where l.tag = 'missing-systemd-service-for-init.d-script'
  and l.tag_type <> 'overridden'
and p.distribution = 'debian'
and p.release = 'sid'
order by p.priority, coalesce(ps.insts, 0) desc, p.source;

