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,
        rc_cur_id,
        rc_timestamp,
        GROUP_CONCAT(rc_log_type) AS log_types,
        GROUP_CONCAT(rc_log_action) AS log_actions,
        GROUP_CONCAT(rc_timestamp) AS timestamps, 
        GROUP_CONCAT(rc_user_text) AS users,
        GROUP_CONCAT(rc_this_oldid) AS diffs,
        GROUP_CONCAT(rc_last_oldid) AS prev_diffs
    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;

SQL

Checking query status...