Replace `SummariseCountPackageAdvisoriesLike` with SQL-only lookup + Fix: use correct advisory type for `UNMAINTAINED`

Jamie Tannarequested to merge
chore/advisory-count into main

With thanks to Roy and gRegor for the help!

Edited by Jamie Tanna

Merge request reports