Untitled query #71861

SQL

SELECT
  rc_timestamp,
  rc_namespace AS ns,
  rc_title,
  rc_this_oldid AS rev_id,
  rc_patrolled AS p,
  actor_name,
  comment_text
FROM
  recentchanges
    JOIN actor_recentchanges ON rc_actor=actor_id
    JOIN comment_recentchanges ON rc_comment_id=comment_id
WHERE
  actor_user IS NULL
  AND rc_source='mw.edit'
  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|beeswax|achim55|ohnoitsjamie|ted masters|vandalism|index\.php|archive\.[ipv]|encyclopedia|conservapedia|dramatica|assass|genocide|katyn|stalin|payback|blatant|bitch|fuck|buddy|shit|fag|vomit|victim|sick|tyrant|bloody|convict|prison|stalker|psychopath|Сталин|Катын)'
  AND rc_timestamp>20230101000000
ORDER BY
  rc_timestamp ASC;
SQL

Checking query status...
