Skip to content

Instantly share code, notes, and snippets.

@beneverard

beneverard/query.sql

Created May 24, 2016 10:20
Show Gist options
  • Save beneverard/0b0a8923cd5dcb8ea506f9663ca7b548 to your computer and use it in GitHub Desktop.
Save beneverard/0b0a8923cd5dcb8ea506f9663ca7b548 to your computer and use it in GitHub Desktop.
Download ZIP
A query to list the 404 URLs captured by Redirection (WordPress plugin), ordered by most hits first. Very handy for finding common 404s and handling them with a manual redirect.
Raw
query.sql
SELECT count(id) as count, url
FROM wp_redirection_404
GROUP BY url
ORDER BY count DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment