SELECT 'contacts_present' AS metric, COUNT(*) AS value FROM contacts WHERE LOWER(email) IN ('payroll@orange.com','twadeson@kwh.com','hr_connect@transalta.com','gabrielle.hatley@nv5.com','daniel.vining2@t-mobile.com','upendra.bhattarai@kapower.us','bcampbell@calfrac.com','jana.davis439@t-mobile.com','m.derosia@holtec.com','mackenzie.swanson@jfpetrogroup.com','sally.okeefe@comed.com','human.resources@kmmcorp.net','nschafer@entrustsol.com','aplasch@clallampud.net','meagan.mowles@oncor.com','beth.duke@aes.com','steven.boockholdt@nv5.com','spencer.oquinn@nv5.com','melody.tyda1@t-mobile.com','bobby.niland@peoriaresources.com','kyle.stuckly@oncor.com','russell.lofquist1@t-mobile.com','tgmsupportengineers@oncor.com','ahadzovic@lspower.com','peoplecare@nokia.com') UNION ALL SELECT 'sg_suppressed', COUNT(DISTINCT email) FROM sendgrid_suppressions WHERE email IN ('payroll@orange.com','twadeson@kwh.com','hr_connect@transalta.com','gabrielle.hatley@nv5.com','daniel.vining2@t-mobile.com','upendra.bhattarai@kapower.us','bcampbell@calfrac.com','jana.davis439@t-mobile.com','m.derosia@holtec.com','mackenzie.swanson@jfpetrogroup.com','sally.okeefe@comed.com','human.resources@kmmcorp.net','nschafer@entrustsol.com','aplasch@clallampud.net','meagan.mowles@oncor.com','beth.duke@aes.com','steven.boockholdt@nv5.com','spencer.oquinn@nv5.com','melody.tyda1@t-mobile.com','bobby.niland@peoriaresources.com','kyle.stuckly@oncor.com','russell.lofquist1@t-mobile.com','tgmsupportengineers@oncor.com','ahadzovic@lspower.com','peoplecare@nokia.com') AND suppression_type IN ('asm_unsubscribe','bounce','block','spam_report','invalid_email') UNION ALL SELECT 'manual_suppressed', COUNT(*) FROM contact_manual_suppressions WHERE active=1 AND LOWER(TRIM(email)) IN ('payroll@orange.com','twadeson@kwh.com','hr_connect@transalta.com','gabrielle.hatley@nv5.com','daniel.vining2@t-mobile.com','upendra.bhattarai@kapower.us','bcampbell@calfrac.com','jana.davis439@t-mobile.com','m.derosia@holtec.com','mackenzie.swanson@jfpetrogroup.com','sally.okeefe@comed.com','human.resources@kmmcorp.net','nschafer@entrustsol.com','aplasch@clallampud.net','meagan.mowles@oncor.com','beth.duke@aes.com','steven.boockholdt@nv5.com','spencer.oquinn@nv5.com','melody.tyda1@t-mobile.com','bobby.niland@peoriaresources.com','kyle.stuckly@oncor.com','russell.lofquist1@t-mobile.com','tgmsupportengineers@oncor.com','ahadzovic@lspower.com','peoplecare@nokia.com');