Untitled query #42367

SQL

USE commonswiki_p;
SET @app_tag_id = (
  SELECT ctd_id
  FROM change_tag_def
  WHERE ctd_name = "Android app edit"
);
SET @se_tag_id = (
  SELECT ctd_id
  FROM change_tag_def
  WHERE ctd_name = "apps-suggested-edits"
);
SET @uw_tag_id = (
  SELECT ctd_id
  FROM change_tag_def
  WHERE ctd_name = "uploadwizard"
);

SELECT /* SLOW_OK */ rev_timestamp, actor_name, page_title, rev_parent_id
FROM revision_userindex
  JOIN comment ON rev_comment_id = comment_id
  JOIN actor_revision ON rev_actor = actor_id
  JOIN page ON rev_page = page_id
WHERE NOT EXISTS(SELECT * FROM user LEFT JOIN user_groups ON user_id = ug_user WHERE actor_user = user_id AND ug_group = "bot")
  AND @uw_edits_tag_id NOT IN (SELECT ct_tag_id FROM change_tag WHERE ct_rev_id = rev_id)
  AND ((@app_tag_id IN              (SELECT ct_tag_id FROM change_tag WHERE ct_rev_id = rev_id)
        AND @se_edits_tag_id NOT IN (SELECT ct_tag_id FROM change_tag WHERE ct_rev_id = rev_id))
    OR comment_text LIKE "%%Via Commons Mobile App%%"
    OR comment_text LIKE "%%using Android Commons%%"
    OR comment_text LIKE "%%COM:MOA%%")
  AND rev_timestamp >= "20161028" AND rev_timestamp < "2016102801"
ORDER BY rev_timestamp DESC;
SQL

Checking query status...
