Wikipedia

Usator:Pathoschild/Sandbox

< Usator:Pathoschild

As requested by 91.9.127.213, this page lists data about user subpages on iawiki.

Issues

modificar

User subpages for users that don't exist (9)

modificar

As of 2016-04-06.

All user subpages

modificar

As of 2016-04-05.

CSS (47)

modificar

JavaScript (120)

modificar

Wikitext subpages (329)

modificar

Wikitext talk pages (20)

modificar

SQL query

modificar 
SELECT
    userpage.title,
    userpage.content_model,
    userpage.namespace,
    userpage.username,
    userpage.is_subpage
FROM
    (
        SELECT
           REPLACE(page_title, '_', ' ') AS title,
           page_content_model AS content_model,
           CASE page_namespace WHEN 2 THEN 'User' ELSE 'User talk' END AS namespace,
           REPLACE(SUBSTRING_INDEX(page_title, '/', 1), '_', ' ') AS username,
           CASE WHEN INSTR(page_title, '/') > 0 THEN 1 ELSE 0 END AS is_subpage,
           page_is_redirect AS is_redirect
        FROM page
        WHERE
           page_namespace IN (2,3)
    ) AS userpage
    LEFT JOIN user ON userpage.username = user.user_name
WHERE
    userpage.is_subpage = 1
    AND user.user_id IS NULL -- user doesn't exist
ORDER BY
    userpage.namespace,
    userpage.title
Obtenite de “https://ia.wikipedia.org/w/index.php?title=Usator:Pathoschild/Sandbox&oldid=549252”