Article creation by Jack User

Fork of All female editors on German Wikipedia by registration date, general by DerHexer

This query is marked as a draft This query has been published by DerHexer.

SQL

USE dewiki_p;
SELECT 
 page_title as Seite,
 page_is_redirect AS Redirect,
 first_user as Erster_User
FROM page
INNER JOIN (SELECT
             rev_user AS first_user
            FROM revision_compat
            WHERE rev_timestamp > "20010101000000"
            LIMIT 1
           ) AS first_user
           ON page_id = first_user
WHERE page.page_namespace = 0
LIMIT 100;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...