SELECT newsitem0_.id
FROM   newsitem newsitem0_
       LEFT OUTER JOIN schedulednotification scheduledn1_
                    ON newsitem0_.id = scheduledn1_.newsitemid
WHERE  newsitem0_.deletedat IS NULL
       AND ( newsitem0_.resend = 1
              OR scheduledn1_.senddate IS NOT NULL )
       AND ( newsitem0_.createdby IN ( 'sarah.kilcoyne@yahoo.com', 'aaliyahdavis2017@yahoo.com', 'joshuaealy20@gmail.com', 'skilcoyne584132@nsula.edu', 'Jesus4Kenny@gmail.com')
              OR newsitem0_.contactid IN (353025,353024,353023,353022,353021,353020 ) )