SELECT
*
FROM
wp_posts table1
WHERE
EXISTS (
SELECT
*
FROM
wp_posts table2
WHERE
table1.post_name = table2.post_name
GROUP BY
table2.post_name
HAVING
COUNT(table2.post_name) > 1
)
ORDER BY
table1.post_name