Comment search

SQL

SET STATEMENT max_statement_time = 10 FOR
SELECT COUNT(*)
FROM page
LEFT JOIN revision ON page.page_id = revision.rev_page
LEFT JOIN change_tag ON revision.rev_id = change_tag.ct_rev_id
LEFT JOIN change_tag_def ON change_tag.ct_tag_id = change_tag_def.ctd_id
LEFT JOIN actor ON revision.rev_actor = actor.actor_id
LEFT JOIN comment ON revision.rev_comment_id = comment.comment_id
WHERE
	page_namespace = 0
    AND page_is_redirect = 0
    AND revision.rev_timestamp >= 20200101010101
    AND actor.actor_user IS NOT NULL
    AND change_tag_def.ctd_name = 'visualeditor'
LIMIT 1;
SQL

Checking query status...
