SQL
AخA
select rc_id, rc_timestamp, -- rc_user, rc_user_text
, rc_namespace, rc_title
, abs(rc_old_len - rc_new_len) size, c.comment_text
from eswiki_p.recentchanges rc
inner join comment c on rc.rc_comment_id = c.comment_id
inner join actor a on rc.rc_actor_id = a.actor_id
where rc_id > 0 and
rc_namespace in (0, 104) and
lower(comment_text) like '%#WikimediaParaLaMemoria%' and
/*rc_timestamp between 20170601000000 and 20170631000000 and*/
-- rc_user > 5 and
rc_new = 0;
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.