use enwiki_p;

select count(*) from revision join page join comment_revision

# page_title, rev_timestamp, rev_actor, comment_text

on page_id = rev_page

and comment_id = rev_comment_id

where page_namespace = 0

and not page_is_redirect

and comment_text like "%http%"

limit 10