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

*/

#select count(*) from comment_revision

#where comment_text like "%http%"

select * from comment_revision

limit 10