SELECT m.id, m.contact_id, c.email, m.sendgrid_list_id, m.list_name, m.company_name, m.created_at FROM contact_list_memberships m JOIN contacts c ON c.id=m.contact_id WHERE LOWER(c.email) IN ('adam.campos@oncor.com','alfredo.arzubiaga@crowncastle.com','ann.gonzalez@nv5.com','austin.fenstermacher@oncor.com','averaldi@lightower.com','bburgess@florail.us','bret.bailey@nv5.com','briana.fontana@crowncastle.com','carlos.cabo@crowncastle.com','ccastillo@calfrac.com','chris.gates@crowncastle.com','chris.taylor@crowncastle.com','chris.ubando@crowncastle.com','cindy.hughes@cox.com','dan.vining@uscellular.com','david.mcrae@crowncastle.com','dbearce@calfrac.com','denise.wolting@eweb.org','dennis.boehm@westinghouse.com','deo.yasol@crowncastle.com','dhall@quanta-technology.com','elisabeth.skol@manpowergroup.se','faze.mustafaj@crowncastle.com','gpaz@glenergy.com','herbert.drake@crowncastle.com','iweese@calfrac.com','jclifford@csmachinemfg.com','jeremy.bell@crowncastle.com','jglaser@nextaff.com','johanna.gamez@crowncastle.com','johnnie.weaver@midamerican.com','judyjamison@clearchannel.com','justin.orrick@oneok.com','kcoombe@roku.com','keith.franz@crowncastle.com','kelly.zelinski@calpine.com','kristina.nagy@crowncastle.com','kristoffer.kutch@oncor.com','mark.stabolepszy@ssmgroup.com','mark.vaccari@oneok.com','matthew.argabright@oncor.com','matthew.lozich@uscellular.com','matthew.turpin@oneok.com','mbrodar@lightower.com','melody.tyda@uscellular.com','mike.foster@crowncastle.com','mmiller@wga-llp.com','mstapp@geus.org','nbrown@garlandtx.gov','nicholas.rulli@crowncastle.com','nspeerschneider@badgermeter.com','owen.deneny@crowncastle.com','priyanka.kadam@oneok.com','robert.didier@uscellular.com','rpena@victoriaelectric.coop','russell.lofquist@uscellular.com','ryan.mccarroll@crowncastle.com','sgreen@bpu.com','shelly.lemay@uscellular.com','stephanie.wing@enverus.com','stuart.kasiske@oneok.com','tangelawalton@clearchannel.com','tdanz@nextaff.com','troy@conexon.us','william_milligan@oxy.com') ORDER BY c.email, m.list_name;