SELECT id, name, alias
    FROM drupal_it_cat_country
    WHERE name IN (SELECT name FROM
            (SELECT id, name, COUNT(id) AS COUNT
                FROM `drupal_it_cat_country`
                GROUP BY name) A
            WHERE A.COUNT > 1
) ORDER BY name