Fork of
Get mainspace revisions to arwiki
by Mr. Ibrahem
This query is marked as a draft
This query has been published
by Mr. Ibrahem.
SQL
x
use arwiki_p;
SELECT #rc_timestamp, rc_actor, rc_title, rc_this_oldid, rc_old_len, rc_new_len, actor_name
rc_title, count(rc_old_len-rc_new_len) as dc
FROM recentchanges
LEFT JOIN actor ON rc_actor = actor_id
WHERE rc_type = 0
AND rc_namespace = 0
AND rc_timestamp BETWEEN 20201201000000 AND 20210101000000
AND actor_name in ('Mr. Ibrahem')
group by rc_title
LIMIT 100
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.