List of articles edited in 23 April 2016 at id.wikipedia.org

Fork of List of articles edited in 23 April 2016 at id.wikipedia.org by Kenrick95

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

SQL

USE idwiki_p;
SELECT
        rc_namespace,
        rc_title,
        GROUP_CONCAT(rc_source) AS sources,
        GROUP_CONCAT(rc_log_type) AS log_types,
        GROUP_CONCAT(rc_log_action) AS log_actions,
        GROUP_CONCAT(rc_timestamp) AS timestamps
    FROM recentchanges
    WHERE
        rc_bot = 0 AND /* exclude bots */
        0 <= rc_type AND rc_type <= 4 AND 
		rc_timestamp >= 20160423000000 AND rc_timestamp < 20160424000000
    GROUP BY rc_namespace, rc_title
    ORDER BY rc_timestamp DESC
    LIMIT 0, 500;

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