SELECT c.email, c.company_name, c.status, c.unsubscribed, c.id FROM contacts c WHERE LOWER(c.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') ORDER BY c.email;