SELECT COUNT(rc_id) FROM recentchanges
JOIN change_tag ON rc_id = ct_rc_id
WHERE rc_namespace = 0
  AND rc_bot = 0
  AND ct_tag_id = 612 /* disambiguator-link-added */
  /* Only query against a finite sample of edits */
  AND rc_id BETWEEN 1413974685 AND 1415351713

SELECT COUNT(DISTINCT rc_id) FROM (
  SELECT rc_id FROM recentchanges
  JOIN change_tag ON rc_id = ct_rc_id
  WHERE rc_namespace = 0
  AND rc_bot = 0
  AND ct_tag_id = 612 /* disambiguator-link-added */
  AND rc_id BETWEEN 1413974685 AND 1415351713
) a
JOIN change_tag ON rc_id = ct_rc_id
WHERE ct_tag_id = (
  SELECT ctd_id FROM change_tag_def
  WHERE ctd_name = 'visualeditor'
)

SELECT COUNT(DISTINCT rc_id) FROM (
  SELECT rc_id, rc_actor FROM (
    SELECT rc_id, rc_actor FROM recentchanges
    JOIN change_tag ON rc_id = ct_rc_id
    WHERE rc_namespace = 0
    AND rc_bot = 0
    AND ct_tag_id = 612 /* disambiguator-link-added */
    AND rc_id BETWEEN 1413974685 AND 1415351713
  ) a
  JOIN actor_recentchanges ON actor_id = rc_actor
  JOIN change_tag ON rc_id = ct_rc_id
  WHERE actor_user IS NULL
    AND ct_tag_id = (
      SELECT ctd_id FROM change_tag_def
      WHERE ctd_name = 'visualeditor'
    )
) b
JOIN change_tag ON ct_rc_id = rc_id
WHERE ct_tag_id = (
  SELECT ctd_id FROM change_tag_def
  WHERE ctd_name = 'mobile web edit'
)

SELECT COUNT(DISTINCT rc_id) FROM (
  SELECT rc_id, rc_actor FROM recentchanges
  JOIN change_tag ON rc_id = ct_rc_id
  WHERE rc_namespace = 0
  AND rc_bot = 0
  AND ct_tag_id = 612 /* disambiguator-link-added */
  AND rc_id BETWEEN 1413974685 AND 1415351713
) a
JOIN actor_recentchanges ON actor_id = rc_actor
JOIN user ON actor_user = user_id AND actor_user IS NOT NULL
WHERE user_editcount < 1000