Jmk talk page edits

data  for discussion comment on https://fi.wikipedia.org/w/index.php?title=Wikipedia:Ylläpitäjien_ilmoitustaulu&oldid=22385829#Miksi_Jmk:n_käytökseen_ei_puututa?

SQL

select 
    sum(1) as c,
	rev_timestamp,
	page_title,
    user_editcount,
    comment_text
from 
	revision_userindex, 
    actor_revision, 
    comment,
    page,
    user
where rev_page=page_id 
and page_namespace=3 
and rev_actor = actor_id 
and rev_comment_id = comment_id
and actor_name="Jmk"
and rev_timestamp > 20220000000000
and page_title NOT REGEXP "[0-9][.][0-9]{1,3}[.][0-9]{1,3}[.][0-9]"
and page_title NOT REGEXP "[0-9A-F]:[0-9A-F]{1,4}:[0-9A-F]{1,4}:[0-9A-F]"
and page_title NOT LIKE "%/%"
and page_title != "Jmk"
and replace(page_title, "_", " ") = user_name
group by rev_id
order by page_title, rev_timestamp

SQL

Checking query status...