wikidata: search in editsummaries

SQL

SELECT
  rev_timestamp,
  page_namespace,
  page_title,
  rev_id,
  actor_name,
  comment_text
FROM
  revision
    JOIN page ON rev_page=page_id
    JOIN actor_revision ON rev_actor=actor_id
    JOIN comment_revision ON rev_comment_id=comment_id
WHERE
  actor_user IS NULL
  AND comment_text REGEXP '(?i)(antandrus|koavf|grp|ferien|kamenicek|javahurricane|shb2000|stryn|1234qwer|tuvalkin|jeff g|lemonaka|synergy|madamebiblio|firefangled|nascarfan|darkmatter|airtransat|mtarch|xover|xania|fehufanga|kittycata|vandalism|index\.php|archive\.[ipv]|encyclopedia|conservapedia|dramatica|assass|genocide|katyn|stalin|payback|blatant|bitch|fuck|buddy|shit|fag|vomit|sick|tyrant|bloody|convict|prison|stalker|psychopath|Сталин|Катын)'
  AND rev_timestamp>20200000000000
ORDER BY rev_timestamp ASC;
SQL

Checking query status...
