Articles edited in specific date (idwiki)

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

SQL

USE idwiki_p;
SELECT
	rc_namespace,
	rc_title,
	rc_cur_id,
	MAX(rc_timestamp),
    GROUP_CONCAT(rc_timestamp ORDER BY rc_timestamp) AS timestamps, 
	GROUP_CONCAT(DISTINCT rc_user_text ORDER BY rc_timestamp) AS users,
    GROUP_CONCAT(rc_this_oldid),
    GROUP_CONCAT(rc_last_oldid)
FROM recentchanges
WHERE
	rc_bot = 0 AND /* exclude bots */
	rc_timestamp >= 20210608000000 AND rc_timestamp < 20210609000000
GROUP BY rc_namespace, rc_title
ORDER BY rc_timestamp 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...