edited pages - Quarry

SQL

use fiwiki_p;
select
    concat("# [[", replace(rc_title, '_', ' '), "]] ") as rc_title,
    concat('<small><span class=plainlinks>([https://fi.wikipedia.org/w/index.php?diff=cur&oldid=', min(rc_last_oldid), ' diff])</span></small>') as linktext,
    group_concat(distinct(IF (el_to LIKE '%calculusfennicus%', 'calculusfennicus', ''))) as el_to
from 
	recentchanges LEFT JOIN  externallinks ON el_from=rc_cur_id, 
    actor, 
    comment,
    revision AS r1 LEFT JOIN revision AS r2 ON r1.rev_sha1=r2.rev_sha2 AND r1.rev_actor!=r2.rev_actor
where 
	rc_comment_id=comment_id 
    and actor_name="Putsari" 
    and actor_id=rc_actor 
    and rc_source="mw.edit" 
    and rc_namespace=0 
    and comment_text REGEXP '^(läpikäyntiä|päivitys)$'
    and rc_timestamp > 20190703200000
    and (rc_new_len-rc_old_len)>50
    and rc_cur_id=r1.rev_id
    and r2.rev_id IS NULL
group by rc_title
order by rc_title
SQL

Checking query status...
