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 ('nhoneycutt@kcaeng.com','jennifer.bullard@cox.com','mdu-pmo@metronet.com','joe@elitestaffinginc.com','jhaws@paragones.com','meagan.mowles@oncor.com','lenka.shahinian@eec-tx.com','rgalaviz@jacksonemc.com','yeejuin_tay@rgei.com','payroll@orange.com','bcarter@petticoatschmitt.com','marcy.mealy@brightspeed.com','mark.baker@txdot.gov','nicholas.armstrong@sunbeltsupply.com','jnguyen@paragones.com','twadeson@kwh.com','llara@paragones.com','hr_connect@transalta.com','rmadere@himmels.com','rburton@walshgroup.com','randall.wood@wsp.com','leann.reichert@dot.state.fl.us','jmalary@blcompanies.com','alan.erickson@wsp.com','taryn.fetherolf@kimley-horn.com','gabrielle.hatley@nv5.com','loftson8th@livesq.com','jknight@vivarailings.com','daniel.vining2@t-mobile.com','upendra.bhattarai@kapower.us','bcampbell@calfrac.com','nkhorsand@jhainc.com','sdahlem@avecc.com','jana.davis439@t-mobile.com','m.derosia@holtec.com','mfck@pge.com','dhutchens@fortisinc.com','cuzoh@kosmosenergy.com','kimberly.delgado@cogs.us','divya.sharma@optimum.com','mackenzie.swanson@jfpetrogroup.com','ereaves@moffattnichol.com','melissa.washington@comed.com','george.feng@qualuscorp.com','kprevil@sgh.com','jchase@glenergy.com','dmarotta@reytec.net','sirs@pge.com','sally.okeefe@comed.com','jeff.vanparys@salasobrien.com','lmulholland@bpu.com','human.resources@kmmcorp.net','afarooqi@quiggengineering.com','davidkahn@clearchannel.com','admin@clc-engineering.com','sklewis@ardurra.com','jbarragan@hunterbuildings.com','wtuttle@kosmosenergy.com','mahern@columbiarea.coop','cciatl-emc-atlantateam@cox.com','samr@demco.org','rina.rivera@secoenergy.com','fbanks@milhouseinc.com','tzaragoza@rtsinspection.com','nschafer@entrustsol.com','wwager@inservusa.com','mike.riley@sunbeltsolomon.com','aplasch@clallampud.net','alkallinger@aagroup.com','lloyd.wind@kpff.com','david.folmsbee@uinet.com','ccicon-teamlestini@cox.com','meagan.mowles@oncor.com','jmrodriguez@mcm-us.com','christina.bendston@mbakerintl.com','info@cardinalmp.com','sean.boston@cox.com','beth.duke@aes.com','brcsouthwest@usi.com','steven.boockholdt@nv5.com','ashley.wunrow@tdstelecom.com','brittany.shadix@carrollemc.com','robert.morgan@wsp.com','rob.brougher@valtir.com','ruben_azner@hortondoors.com','kgreen@mjwomack.com','bryana.grovender@westwoodps.com','ksimone@fischerhomes.com','jerry.chen@wsp.com','rwbowman@bec-inc.com','smitchell@hometowntitleinc.com','paul.legg@vdot.virginia.gov','andrew.shambach@ssmgroup.com','matt.brown@spireenergy.com','spencer.oquinn@nv5.com','lhenson@valmerland.com','susie.laurin@ae2s.com','daniel.braatz@wsp.com','kristina.breeding@contractlandstaff.com','melody.tyda1@t-mobile.com','shaun.brady@optimum.com','henry.rosen@wsp.com','mruiz@wga-llc.com','kwknudso@up.com','bpool@floidaasphalt.com','mathew.koenig@cox.com','bobby.niland@peoriaresources.com','kjordan@cgaus.com','ep.dkhr@totalenergies.com','jeremy.hung@wsp.com','kyle.stuckly@oncor.com','carol.ketchian@ipc.com','aman@iconma.com','lryerson@cec.coop','richard@aaa-fabrication.com','anordmeyer@fischerhomes.com','jeremy.ross@denverwater.org','emontgomery@halff.com','russell.lofquist1@t-mobile.com','tgmsupportengineers@oncor.com','scotc@demco.org','brian.breissinger@wsp.com','hr@summitde.com','dslaughter@moorebass.com','mhobbs@inservusa.com','jeremyw@demco.org','ahadzovic@lspower.com','jpeshel@usanova.com','albert@iconma.com','patty.harvey@vdot.virginia.gov','hr@vaengineering.com','abhish@iconma.com','satavanan.jeyaratnam@td.com','wnorman@paragones.com','robert_perkins@rge.com','sredman@paragones.com','ethan.rice@nextaff.com','john.reinhardt@tylin.com','kmaloney@targaresources.com','leslieh@adamsresources.com','aaron.stacy@brightspeed.com','james.mclelland@wsp.com','cblaich@chelco.com','peoplecare@nokia.com','cci-westfeometroip@cox.com','kris.lin@innovex-inc.com','thomas.nguyen@oncor.com');