``` SELECT * FROM (SELECT common_name, COUNT(*) cn...
# general
z
Copy code
SELECT * FROM (SELECT common_name, COUNT(*) cnt FROM certificates WHERE issuer LIKE '%Company%' AND not_valid_after >= (select unix_time from time) AND path LIKE '%login%') WHERE cnt > 1;