Articles created by users

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

Articles created by users, limited to 200

SQL

USE ptwiki_p;
SELECT  user_name,
        cOUNT(rev.rev_id) AS edit_count
	FROM ptwiki_p.revision rev
    	INNER JOIN user
             ON user_id = rev.rev_user
        inner join user_groups
        	 on user_id = rev.rev_id
        LEFT OUTER JOIN revision parent
       		ON rev.rev_parent_id = parent.rev_id
        JOIN page
        	ON rev.rev_page = page_id
    WHERE page_namespace = 0
    AND rev.rev_timestamp BETWEEN 20160428000000 AND 20161025000000
    AND page_namespace = 0
    AND user_name NOT REGEXP '[Bb]ot'
GROUP BY user_name, user_groups
ORDER BY edit_count DESC;

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...