List of articles created (+subsequent edits) in 5 May 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,
        GROUP_CONCAT(rc_type) AS rc_types,
        GROUP_CONCAT(rc_log_type) AS log_types,
        GROUP_CONCAT(rc_log_action) AS log_actions,
        GROUP_CONCAT(rc_timestamp ORDER BY rc_timestamp DESC) AS timestamps, 
        GROUP_CONCAT(rc_user_text ORDER BY rc_timestamp DESC) AS users,
        GROUP_CONCAT(rc_this_oldid ORDER BY rc_timestamp DESC) AS diffs,
        GROUP_CONCAT(rc_last_oldid ORDER BY rc_timestamp DESC) 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
    HAVING COUNT(SELECT * FROM recentchanges AS r2 WHERE rc_type = 1 AND r2.rc_cur_id = r2.cur_id) > 0
    ORDER BY rc_timestamp DESC;
    /*LIMIT 0, 500;*/

SQL

Checking query status...