Usator:Pathoschild/Sandbox

De Wikipedia, le encyclopedia libere

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

Issues[modificar | modificar fonte]

User subpages for users that don't exist (9)[modificar | modificar fonte]

As of 2016-04-06.

All user subpages[modificar | modificar fonte]

As of 2016-04-05.

CSS (47)[modificar | modificar fonte]

JavaScript (120)[modificar | modificar fonte]

Wikitext subpages (329)[modificar | modificar fonte]

Wikitext talk pages (20)[modificar | modificar fonte]

SQL query[modificar | modificar fonte]

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”