edited pages - Quarry

SQL

use fiwiki_p;

select rc_title, linktext, el_to from (
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,
    max(rc_this_oldid) as max_rev_id,
    r1.rev_actor,
    rc_cur_id
from 
	recentchanges LEFT JOIN  externallinks ON el_from=rc_cur_id, 
    actor, 
    comment,
    page,
    revision AS r1 LEFT JOIN revision AS r2 ON r1.rev_page=r2.rev_page AND r1.rev_sha1=r2.rev_sha1 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 page_namespace=0
    and rc_cur_id=page_id
    and page_latest=r1.rev_id    
    and r2.rev_id IS NULL
group by rc_title
) as t, revision as r3, comment
WHERE 
  NOT (t.rc_cur_id=r3.rev_page
  AND t.max_rev_id < r3.rev_id
  AND t.rev_actor!=r3.rev_actor
  AND r3.rev_comment_id=comment_id
  AND comment_text NOT LIKE "%rv%")
order by rc_title
SQL

Checking query status...
