Saltar al contento

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”