use enwiki_p;

/*

select count(*) from revision join page join comment_revision

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%"

*/

select comment_id from comment_revision

where comment_text like "%http%"

​