SELECT LOWER(TRIM(email)) AS email, reason, active, effective_date FROM contact_manual_suppressions WHERE LOWER(TRIM(email)) IN ('ahadzovic@lspower.com','aplasch@clallampud.net','ashley.wunrow@tdstelecom.com','bcampbell@calfrac.com','beth.duke@aes.com','bobby.niland@peoriaresources.com','daniel.vining2@t-mobile.com','gabrielle.hatley@nv5.com','hr_connect@transalta.com','human.resources@kmmcorp.net','jana.davis439@t-mobile.com','kmaloney@targaresources.com','kyle.stuckly@oncor.com','m.derosia@holtec.com','mackenzie.swanson@jfpetrogroup.com','meagan.mowles@oncor.com','melody.tyda1@t-mobile.com','nschafer@entrustsol.com','payroll@orange.com','peoplecare@nokia.com','russell.lofquist1@t-mobile.com','sally.okeefe@comed.com','sean.boston@cox.com','spencer.oquinn@nv5.com','steven.boockholdt@nv5.com','tgmsupportengineers@oncor.com','thomas.nguyen@oncor.com','twadeson@kwh.com','upendra.bhattarai@kapower.us') ORDER BY email;