Untitled query #73950

SQL

use arwiki_p;
    SELECT page_id, comment_text,externallinks.el_to
    FROM revision_userindex
    INNER JOIN page ON rev_page = page_id
    INNER JOIN actor ON rev_actor = actor.actor_id
    INNER JOIN comment ON comment_id = rev_comment_id
    INNER JOIN externallinks ON rev_page = externallinks.el_from
    WHERE rev_timestamp between 20220217000000 and 20220218000000
	AND page_namespace = 0
    AND page.page_is_redirect = 0
    AND actor_name = 'Hasanisawi'
    AND el_to not like "https://web.archive.org/web/%"
    AND el_to like "%blogspot.com/%";
SQL

Checking query status...
