SELECT LOWER(TRIM(c.email)) AS email, m.list_name, m.company_name, m.sendgrid_list_id FROM contact_list_memberships m JOIN contacts c ON c.id=m.contact_id WHERE LOWER(c.email) IN ('ahadzovic@lspower.com','andrei.petrescu@orange.com','aplasch@clallampud.net','ashley.wunrow@tdstelecom.com','bcampbell@calfrac.com','beth.duke@aes.com','bhodgson@kwh.com','blake_pipke@transalta.com','bobby.niland@peoriaresources.com','cscheinert@crssurveypllc.com','dan.vining@uscellular.com','daniel.vining2@t-mobile.com','dante.cavallucci@kapower.us','dbearce@calfrac.com','denise.schwarz16@t-mobile.com','dennis.boehm@westinghouse.com','erin.barabas@jfpetrogroup.com','gabrielle.hatley@nv5.com','hr_connect@transalta.com','human.resources@kmmcorp.net','ian.pennebaker@comed.com','j.carson@kmmcorp.net','jana.davis439@t-mobile.com','jhamilton@entrustsol.com','jmetzger@clallampud.net','joshua.ward@oncor.com','julie.ford@cox.com','julie.seering@aes.com','katherine.vilardo@nv5.com','kelly.cromwell@tdstelecom.com','kmaloney@targaresources.com','kyle.stuckly@oncor.com','m.derosia@holtec.com','mackenzie.swanson@jfpetrogroup.com','matt.wolf@nv5.com','meagan.mowles@oncor.com','melody.tyda1@t-mobile.com','melody.tyda@uscellular.com','nhudson@verdadresources.com','nschafer@entrustsol.com','payroll@orange.com','peoplecare@nokia.com','raymond.cumpton@oncor.com','russell.lofquist1@t-mobile.com','russell.lofquist@uscellular.com','rutul.patel@oncor.com','sally.okeefe@comed.com','sean.boston@cox.com','sgreene@lspower.com','spencer.oquinn@nv5.com','steven.boockholdt@nv5.com','tgmsupportengineers@oncor.com','thomas.nguyen@oncor.com','tmccray@targaresources.com','twadeson@kwh.com','unnikrishnan.oppath@nokia.com','upendra.bhattarai@kapower.us','zagros.shahooei@oncor.com') ORDER BY c.email, m.list_name;