Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Zache
.
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?
Toggle Highlighting
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 > 20230000000000 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
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...