CREATE TABLE `wmf_eoy_receipt_donor` (
  `job_id` int(10) unsigned DEFAULT NULL,
  `email` varchar(254) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `preferred_language` varchar(16) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `contributions_rollup` text,
  UNIQUE KEY `wmf_eoy_receipt_donor_job_id_email` (`job_id`,`email`),
  KEY `job_id` (`job_id`),
  KEY `email` (`email`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

SELECT utffail.* FROM wmf_eoy_receipt_donor donor
  INNER JOIN (
  SELECT DISTINCT name, status, eoy.preferred_language, eoy.email, names.first_name
  FROM wmf_eoy_receipt_donor eoy
       LEFT JOIN (
    SELECT first_name, e.email
    FROM wmf_eoy_receipt_donor dd
         LEFT JOIN civicrm.civicrm_email e ON e.email = dd.email
         LEFT JOIN civicrm.civicrm_contact c ON c.id = e.contact_id
      AND first_name = name
  ) AS mails ON mails.email = eoy.email AND first_name = name
       LEFT JOIN (
    SELECT first_name, e.email
    FROM wmf_eoy_receipt_donor dd
         LEFT JOIN civicrm.civicrm_email e ON e.email = dd.email
         LEFT JOIN civicrm.civicrm_contact c ON c.id = e.contact_id
  ) AS names ON names.email = eoy.email

  WHERE mails.first_name IS NULL
    AND names.first_name IS NOT NULL
) as utffail ON utffail.email = donor.email
AND donor.status = 'Sent'
 ;