User:Pathoschild/2015 invalid user pages

These user pages were created for users that don't exist on Meta (excluding redirects).

Main pages edit

User: edit

Status:    Done

User talk: edit

Status:    Done

Subpages edit

User: edit

User talk: edit

Queries edit

SQL edit

These queries fetch the data for the tables above (change page_namespace accordingly).

  • main pages:
    SELECT
       REPLACE(page_title, '_', ' ')
    FROM
       page
       LEFT JOIN `user` ON REPLACE(page_title, '_', ' ') = user_name
    WHERE
       page_namespace = 2
       AND page_is_redirect = 0
       AND page_title NOT LIKE '%/%'
       AND user_name IS NULL
       AND INET_ATON(page_title) IS NULL
       AND INET6_ATON(page_title) IS NULL
    ORDER BY page_title
    
  • user subpages:
    SELECT
       REPLACE(LEFT(page_title, LOCATE('/', page_title) - 1), '_', ' ') AS user_name,
       REPLACE(page_title, '_', ' ') AS page_title
    FROM
       page
       LEFT JOIN `user` ON REPLACE(LEFT(page_title, LOCATE('/', page_title) - 1), '_', ' ') = user_name
    WHERE
       page_namespace = 2
       AND page_title LIKE '%/%'
       AND user_name IS NULL
       AND page_is_redirect = 0
    ORDER BY page_title
    

Regex edit

These regex patterns convert the SQL result table into the wikitext tables shown above (change "user talk" accordingly).

  • For main pages:
    ^\| (.+?) \s*\|

    |-style="background:#;"| | [[user talk:$1]] | <small>[[Special:CentralAuth/$1|account]], [[Special:ListUsers/$1|search]], [{{fullurl:Special:Log/renameuser|page={{urlencode:User:$1}}}} rename log]</small> | <small>[{{fullurl:User talk:$1|action=history}} history], [[Special:WhatLinksHere/User talk:$1|links]]</small> |

  • For subpages:
    ^\| (.+?) \s*\| (.+?)\s*\|

    |-style="background:#;"| | [[user talk:$2]] | <small>[[Special:CentralAuth/$1|account]], [[Special:ListUsers/$1|search]], [{{fullurl:Special:Log/renameuser|page={{urlencode:User:$1}}}} rename log]</small> | <small>[{{fullurl:User talk:$2|action=history}} history], [[Special:WhatLinksHere/User talk:$2|links]]</small> |