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`;