Untitled query #42367

SQL

USE commonswiki_p;
SELECT /* SLOW_OK */ rev_timestamp, actor_name, page_title, rev_parent_id
FROM revision
   JOIN comment ON rev_comment_id = comment_id
   JOIN actor ON rev_actor = actor_id
   JOIN page ON rev_page = page_id
   JOIN user ON actor_user = user_id
   LEFT OUTER JOIN user_groups ON user_id = ug_user
WHERE ug_group != "bot"
    AND ((22 IN (SELECT ct_tag_id FROM change_tag WHERE ct_rev_id = rev_id)  /* ="Android app edit" */
        AND 434 NOT IN (SELECT ct_tag_id FROM change_tag WHERE ct_rev_id = rev_id)) /* ="Suggested Edits edit */
    OR comment_text LIKE "%%Via Commons Mobile App%%"
    OR comment_text LIKE "%%using Android Commons%%"
    OR comment_text LIKE "%%COM:MOA%%")
 AND rev_timestamp >= "20200210" AND rev_timestamp < "2020021012"
ORDER BY rev_timestamp DESC;
SQL

Checking query status...
