SQL. MySQL Выборка дубликатов.

// Doctrine
$emails = Doctrine_Query::create()->select('email')->from('User')
            ->groupBy('email')->having('COUNT(email) > 1')
            ->setHydrationMode(Doctrine::HYDRATE_ARRAY)->execute()

// SQL
SELECT email FROM user GROUP BY email HAVING COUNT(email) > 1