DELETE FROM loan_recoveries
 WHERE id IN (
    SELECT id
      FROM loan_recoveries
     WHERE loan_id IN (
        SELECT loan_id
          FROM (
            SELECT loan_id, count(*) as c FROM loan_recoveries a
             WHERE reachout_state in ('FIRST_TEXT_SENT', 'FIRST_EMAIL_AND_TEXT_SENT')
               AND EXISTS (SELECT loan_id FROM loan_recoveries b WHERE b.loan_id = a.loan_id AND reachout_state = 'FIRST_TEXT_SENT')
             GROUP BY loan_id) x
         WHERE c >= 2)
      AND reachout_state IN ('FIRST_TEXT_SENT', 'SECOND_TEXT_SENT', 'THIRD_EMAIL_SENT', 'FIRST_EMAIL_SENT', 'SECOND_EMAIL_SENT'));