SELECT 'MANUAL_SUPPRESSIONS_TOTAL' AS metric, COUNT(*) AS value FROM contact_manual_suppressions
UNION ALL
SELECT 'MANUAL_SUPPRESSIONS_ACTIVE', COUNT(*) FROM contact_manual_suppressions WHERE active=1
UNION ALL
SELECT 'DUPLICATE_EMAILS', COALESCE((SELECT COUNT(*) FROM (SELECT email FROM contact_manual_suppressions GROUP BY email HAVING COUNT(*)>1) d), 0)
UNION ALL
SELECT 'TARGETS_STILL_IN_CONTACTS', COUNT(*) FROM contacts WHERE LOWER(email) IN (SELECT LOWER(email) FROM contact_manual_suppressions)
UNION ALL
SELECT 'TARGETS_STILL_LINDERLAKE', COUNT(*) FROM contacts WHERE LOWER(email) IN (SELECT LOWER(email) FROM contact_manual_suppressions) AND company_name='LINDERLAKE'
UNION ALL
SELECT 'TARGETS_STILL_ACTIVE', COUNT(*) FROM contacts WHERE LOWER(email) IN (SELECT LOWER(email) FROM contact_manual_suppressions) AND status='active' AND (unsubscribed IS NULL OR unsubscribed=0)
UNION ALL
SELECT 'CONTACTS_BASELINE_LINDERLAKE', COUNT(*) FROM contacts WHERE company_name='LINDERLAKE' AND status='active' AND (unsubscribed IS NULL OR unsubscribed=0)
UNION ALL
SELECT 'CONTACTS_BASELINE_ATWORK', COUNT(*) FROM contacts WHERE company_name='ATWORK/CONROE' AND status='active' AND (unsubscribed IS NULL OR unsubscribed=0)
UNION ALL
SELECT 'CONTACTS_BASELINE_BCS', COUNT(*) FROM contacts WHERE company_name='BCS' AND status='active' AND (unsubscribed IS NULL OR unsubscribed=0)
UNION ALL
SELECT 'CONTACTS_BASELINE_TOTAL_ACTIVE', COUNT(*) FROM contacts WHERE status='active' AND (unsubscribed IS NULL OR unsubscribed=0);

SELECT reason, COUNT(*) AS cnt FROM contact_manual_suppressions WHERE active=1 GROUP BY reason ORDER BY reason;