CREATE TEMPORARY TABLE _removed (email VARCHAR(255) NOT NULL PRIMARY KEY)
  ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOAD DATA LOCAL INFILE 'work/004c_removed.txt' INTO TABLE _removed
  CHARACTER SET utf8mb4 FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' (email);

SELECT 'REMOVED_TOTAL' AS metric, COUNT(*) AS value FROM _removed
UNION ALL
SELECT 'REMOVED_ATWORK',
       (SELECT COUNT(*) FROM _removed r JOIN contacts c ON LOWER(TRIM(c.email))=r.email WHERE c.company_name='ATWORK/CONROE')
UNION ALL
SELECT 'REMOVED_LINDERLAKE',
       (SELECT COUNT(*) FROM _removed r JOIN contacts c ON LOWER(TRIM(c.email))=r.email WHERE c.company_name='LINDERLAKE')
UNION ALL
SELECT 'REMOVED_BCS',
       (SELECT COUNT(*) FROM _removed r JOIN contacts c ON LOWER(TRIM(c.email))=r.email WHERE c.company_name='BCS')
UNION ALL
SELECT 'REMOVED_UNMATCHED',
       (SELECT COUNT(*) FROM _removed r WHERE NOT EXISTS
          (SELECT 1 FROM contacts c WHERE LOWER(TRIM(c.email))=r.email));