SELECT c.email, c.company_name, c.status, COALESCE(c.unsubscribed,0) AS unsubscribed, COALESCE(c.suppression_status,'') AS suppression_status, LEFT(COALESCE(c.suppression_reason,''),200) AS suppression_reason, c.id AS contact_id, (SELECT COUNT(*) FROM contact_list_memberships m WHERE m.contact_id=c.id) AS list_count, (SELECT COUNT(*) FROM contact_list_memberships m WHERE m.contact_id=c.id AND m.company_name='LINDERLAKE') AS linderlake_count FROM contacts c WHERE c.email IN ('aabbott@pattieng.com','aandersen@gpcom.com','adam.campos@oncor.com','alawrence@paragones.com','alfredo.arzubiaga@crowncastle.com','ann.gonzalez@nv5.com','aparth@petticoatschmitt.com','ashley.kalika@bellmts.ca','atorrance@paragones.com','austin.fenstermacher@oncor.com','austin.schriver@ironhorsemidstream.com','averaldi@lightower.com','bburgess@florail.us','bkelley@paragones.com','bkrupowicz@waterblast.com','bmitzelfeld@himmels.com','bobarr@barrfab.com','bobby.d.walters@brightspeed.com','brandon@specwater.com','brent.burgard@ackerman-estvold.com','bret.bailey@nv5.com','brian.billigen@crowncastle.com','brian.helstern@crowncastle.com','brian@hugheyservices.com','briana.fontana@crowncastle.com','brthomas@cpja.com','carl@shearbits.com','carlos.cabo@crowncastle.com','ccastillo@calfrac.com','celeste.sweet@tamarackgrove.com','chris.gates@crowncastle.com','chris.taylor@crowncastle.com','chris.ubando@crowncastle.com','chrislarose@npumail.com','cindy.hughes@cox.com','cwatson@komline.com','cwright@vivarailings.com','dan.vining@uscellular.com','david.mcrae@crowncastle.com','dbearce@calfrac.com','declan.ogrady@crowncastle.com','denise.wolting@eweb.org','dennis.boehm@westinghouse.com','deo.yasol@crowncastle.com','dhall@quanta-technology.com','dhutchens@uns.com','dkalish@tug-hillop.com','dmcguinness@kosmosenergy.com','don.ballard@peci.com','doug.hazzard@cogs.us','dsteingrubey@badlandscontracting.com','dwightmiller@ohioec.org','eblakemore@idseg.com','eduardo.alfena@doverfs.com','ehinkel@titusoil.com','elisabeth.skol@manpowergroup.se','ernesto.garza@aivinc.com','ewilliamson@rtsinspection.com','faze.mustafaj@crowncastle.com','fcorbett@moffattnichol.com','george.feng@woodplc.com','george.truong@blackbox.com','gpaz@glenergy.com','grodriguez@reytec.com','gstern@cmeec.org','heather.rock@pge.com','herbert.drake@crowncastle.com','hruggles@hcremc.com','isaac.schultejans@salasobrien.com','iweese@calfrac.com','j.lowery@itm-texas.com','jbale@ardurra.com','jbenham@gftinc.com','jcappon@kosmosenergy.com','jclifford@csmachinemfg.com','jcooper@columbiarea.coop','jeremy.bell@crowncastle.com','jgage@rtsinspection.com','jglaser@nextaff.com','jhinson@bpu.com','jhutchinson@powersolutionsgroup.com','jim.robinson@crowncastle.com','jnarvaez@aagroup.com','joel.hettinger@kpff.com','joel.shaw@silverwellenergy.com','johanna.gamez@crowncastle.com','johnnie.weaver@midamerican.com','jschidlmeier@mbakerintl.com','jsuchand@cardinalmp.com','judyjamison@clearchannel.com','justin.orrick@oneok.com','justinhayden@basindesign.onmicrosoft.com','katedemitrus@imperativechemicals.com','katherine.varto@ovintiv.com','kcoombe@roku.com','keith.franz@crowncastle.com','kelliott@caboolmo.org','kelly.zelinski@calpine.com','kellyb@odayequipment.com','kevin_logeais@hortondoors.com','kguessfeld@mjwomack.com','kim.mitchell-williams@westwoodps.com','klantz@thethrashergroup.com','kmcelroy@fischerhomes.com','kristina.nagy@crowncastle.com','kristoffer.kutch@oncor.com','legacyemail-ross@bec-inc.com','lkoehler@sableoffshore.com','mark.stabolepszy@ssmgroup.com','mark.vaccari@oneok.com','matt.brown@duke-energy.com','matthew.argabright@oncor.com','matthew.lozich@uscellular.com','matthew.turpin@oneok.com','mbrodar@lightower.com','md4145@exo.att.com','melody.tyda@uscellular.com','michael.corley@experis.com','michael.fusco@optimum.com','mike.foster@crowncastle.com','mlocicero@htxforklifts.com','mmiller@wga-llp.com','mspringer@mtvernon-cityhall.org','mstapp@geus.org','nagy.mahfouz@petrolift.com','nbrown@garlandtx.gov','nicholas.rulli@crowncastle.com','no-reply@cgaus.com','nspeerschneider@badgermeter.com','om@howardgreeleyppd.com','owen.deneny@crowncastle.com','paulnewman1@clearchannel.com','priyanka.kadam@oneok.com','rachel.campbell@manpower.co.uk','raymond.feliciano@ipc.com','rbarnett@horizontaltech.com','rbhimireddy@basindesign.onmicrosoft.com','ro_bonetti@cityofalachua.org','robert.didier@uscellular.com','robert.mahoney@denverwater.org','roy.garcia@custombiltmetals.com','roym@moffittservices.com','rpena@victoriaelectric.coop','ruben.caceres@oceanedgeservices.com','russell.lofquist@uscellular.com','russells@sealtex.com','ryan.mccarroll@crowncastle.com','savannah.speich@cobbfendley.com','schurchill@inservusa.com','scott.comisar@npisorters.com','sfrank@dlz.com','sgorlachev@demoyahighway.com','sgorton@libertyglobal.com','sgreen@bpu.com','shani.naor@hot.net.il','sheeter@usanova.com','shelly.lemay@uscellular.com','smartelli@vaengineering.com','stephanie.wing@enverus.com','stuart.kasiske@oneok.com','swhite@paragones.com','tangelawalton@clearchannel.com','tcrawford@paragones.com','tdanz@nextaff.com','thompson@tcemc.org','tim.johnson@streamlineinnovations.com','tmorris@cbmfok.com','tohmart@adamsresources.com','troy@conexon.us','tsmith@baseline-enserv.com','william_milligan@oxy.com','zachary.shappell@oneok.com');