I suggest doing the opposite, adding a list of only trusted email addresses to get rid of the temporary ones.
The following query will count the most used domains:
SELECT substring_index(email, '@', -1) domain, COUNT(*) email_count
FROM core_members
GROUP BY substring_index(email, '@', -1)
ORDER BY email_count DESC, domain;