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
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_timestamp < 20190707200000
group by rc_title
order by rc_title
SQL

Checking query status...
