Content search

This query is marked as a draft This query has been published by MarioGom.

SQL

SELECT rc_cur_id, MAX(rc_this_oldid) AS oldid
FROM (SELECT *
FROM
  recentchanges
  INNER JOIN change_tag ON recentchanges.rc_id = change_tag.ct_rc_id
  INNER JOIN change_tag_def ON change_tag.ct_tag_id = change_tag_def.ctd_id
  INNER JOIN actor ON recentchanges.rc_actor = actor.actor_id
WHERE
	rc_namespace = 0
    AND rc_ip IS NULL
  	AND rc_bot = 0
   AND actor_user IS NOT NULL
   AND change_tag_def.ctd_name = 'visualeditor'
LIMIT 100
) AS q
GROUP BY rc_cur_id

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.

SQL

Checking query status...