SQL
AخA
SELECT CONCAT('Benutzer:', page_title), rd_namespace, rd_title
FROM page, redirect
WHERE page_namespace = 2
AND page_is_redirect = 1
AND (page_title RLIKE "^[0-9]+\.[0-9]+\.[0-9]+\.[0-9]+$"
OR page_title RLIKE "^([0-9a-fA-F]+\:+)+[0-9a-fA-F]$")
AND rd_from = page_id
AND (rd_namespace != 3 /* Weiterleitung auf die Diskussionsseite der IP ausnehmen */
OR rd_title != page_title)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.