荒らしの可能性があるウィキデートの編集

SQL

use wikidatawiki_p;
select
concat( "[[", rc_title, "|", /*ips_site_page, */"]]") as page_title,
concat( "[[Special:Diff/", rc_this_oldid, "|diff]]") as diff,
rc_user_text as username,
left( concat( date( rc_timestamp ), "T", time( rc_timestamp ) ), 19) as date,
rc_comment
from wb_items_per_site
inner join (
  select rc_timestamp, rc_user_text, rc_comment, rc_this_oldid, rc_title, substring( rc_title, 2, 15) as rc_item_id
  from recentchanges_userindex
  where
    rc_user = 0 and
    rc_namespace = 0 and
    rc_patrolled = 0 and
    rc_source = "mw.edit" and
    (
      rc_comment like "/* wbsetdescription-add:1|ja */%" or #説明の追加
      rc_comment like "/* wbsetaliases-add:1|ja */%" or #別名の追加

      rc_comment like "/* wbsetlabel-set:1|ja */%" or #ラベルの変更
      rc_comment like "/* wbsetdescription-set:1|ja */%" or #説明の変更
      rc_comment like "/* wbsetaliases-set:1|ja */%" #別名の変更
    )
  order by rc_timestamp desc
  limit 10000
) as rc/* on ips_item_id = rc_item_id
where
  ips_site_id = "jawiki"*/
SQL

Checking query status...
