SELECT `emails`.`email` AS `email`, COUNT(*) AS `email_num` FROM `users` LEFT JOIN `emails` ON (`emails`.`users_id` = `users`.`id` AND `emails`.`id` = (SELECT MAX(`id`) FROM `emails` WHERE `emails_types_id` = 2 AND `users_id` = `users`.`id`)) GROUP BY `email` HAVING `email_num` > 1 ORDER BY `email`;