Temporary sandbox 2

Fork of Ruwiki IWRM.js usage → wikitable by A particle for world to form

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

SQL

USE ruwiki_p;
SELECT
	rev_actor,
    (
        SELECT
            actor_name
        FROM actor
        WHERE actor_id = rev_actor
    ) as actor_name,
    COUNT(rev_actor),
    -- rev_comment, -- если правка одна, видно, что
    page_title, -- и где,
    rev_timestamp -- и когда,
    -- если много - отображается случайная
FROM revision
JOIN page ON page_id = rev_page
WHERE 
    rev_timestamp >= "20170701" AND
    page_namespace = 8 AND
    (page_title LIKE '%.css' OR
    page_title LIKE '%.js')
GROUP BY rev_actor
ORDER BY COUNT(*) DESC
;

SQL

Checking query status...