Skip to content

Instantly share code, notes, and snippets.

@jrbeeman

jrbeeman/gist:1118052

Created August 1, 2011 12:42
Show Gist options
  • Save jrbeeman/1118052 to your computer and use it in GitHub Desktop.
Save jrbeeman/1118052 to your computer and use it in GitHub Desktop.
Download ZIP
Find duplicate URL aliases in Drupal
Raw
gistfile1.sql
SELECT alias, COUNT(pid) AS total FROM url_alias GROUP BY alias HAVING COUNT(pid) > 1 ORDER BY total ASC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment