Untitled query #42185

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
 WHERE (EXISTS (SELECT * FROM change_tag WHERE ct_rev_id = rev_id AND ct_tag_id = 22) /* ="Android app 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 >= "20200209" AND rev_timestamp < "20200210"
ORDER BY rev_timestamp DESC;
SQL

Checking query status...
