with inactive_nodes AS (SELECT certname FROM certnames WHERE (deactivated IS NOT NULL OR expired IS NOT NULL))
 SELECT pi.name AS package_name, pi.version AS version, count(*) count
 FROM package_inventory pi LEFT JOIN certnames ON pi.certname_id = certnames.id
 WHERE ((pi.name ~ 'vim' AND pi.name IS NOT NULL)
   AND NOT ((certnames.certname) in  (SELECT inactive_nodes.certname AS certname FROM inactive_nodes)))
 GROUP BY pi.name, pi.version ORDER BY pi.name, pi.version limit 100;