Fork of Blank by Viswaprabha
This query is marked as a draft This query has been published by Viswaprabha.

SQL

x
 
############################################  en: English  ##################################
USE enwiki_p;
SELECT 
t.cnt AS 'Edits', 
t.page_title AS 'Title', 
t.page_id AS 'Page ID', 
r2.rev_user_text AS 'Creator', 
r2.rev_id AS 'Creation Rev ID', 
r2.rev_timestamp AS 'Creation time',
r1.rev_len AS 'Last size',
r1.rev_user_text AS 'Last editor',
r1.rev_timestamp AS 'Last edit time'
FROM (  
    SELECT COUNT(*) AS cnt, r.rev_timestamp, p.page_id, p.page_title, p.page_latest, p.page_namespace
    FROM revision r
    LEFT JOIN page p ON p.page_id = r.rev_page
    WHERE r.rev_page IN ( 
        SELECT page_id FROM page p2
        WHERE p2.page_namespace = 0 AND p2.page_title IN (
            SELECT page_title FROM page
            WHERE page_id IN ( 
                SELECT cl_from FROM categorylinks
                WHERE cl_to = "Articles_created_as_part_of_Punjab_Editathon_-_2016"
            ) 
        )
    )
    AND p.page_namespace = 0
    GROUP BY page_namespace, page_title
) AS t
LEFT JOIN revision r2 ON r2.rev_page = t.page_id AND r2.rev_parent_id = 0
LEFT JOIN revision r1 ON r1.rev_id = t.page_latest
GROUP BY t.page_namespace, t.page_title
;
UNION
USE enwiki_p;
SELECT 
t.cnt AS 'Edits', 
t.page_title AS 'Title', 
t.page_id AS 'Page ID', 
r2.rev_user_text AS 'Creator', 
r2.rev_id AS 'Creation Rev ID', 
r2.rev_timestamp AS 'Creation time',
r1.rev_len AS 'Last size',
r1.rev_user_text AS 'Last editor',
r1.rev_timestamp AS 'Last edit time'
FROM (  
    SELECT COUNT(*) AS cnt, r.rev_timestamp, p.page_id, p.page_title, p.page_latest, p.page_namespace
    FROM revision r
    LEFT JOIN page p ON p.page_id = r.rev_page
    WHERE r.rev_page IN ( 
        SELECT page_id FROM page p2
        WHERE p2.page_namespace = 0 AND p2.page_title IN (
            SELECT page_title FROM page
            WHERE page_id IN ( 
                SELECT cl_from FROM categorylinks
                WHERE cl_to = "Articles_created_as_part_of_Punjab_Editathon_-_2016"
            ) 
        )
    )
    AND p.page_namespace = 0
    GROUP BY page_namespace, page_title
) AS t
LEFT JOIN revision r2 ON r2.rev_page = t.page_id AND r2.rev_parent_id = 0
LEFT JOIN revision r1 ON r1.rev_id = t.page_latest
GROUP BY t.page_namespace, t.page_title
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...