/*

SELECT hu.img_name, hu.img_sha1, c.img_sha1

    FROM huwiki_p.image AS hu, commonswiki_p.image AS c

    WHERE hu.img_sha1 = c.img_sha1;

​

USE huwiki_p;

SELECT COUNT(rd_from) FROM redirect;

​

SELECT COUNT(rd_from) FROM redirect WHERE rd_namespace = 0;

​

USE metawiki_p;

SHOW TABLES;

-- select * from translate_sections where trs_key like '%/%' or trs_key like '%\_%';*/

​

USE wikidatawiki_p;

DESCRIBE revision;

DESCRIBE `comment`;

-- SELECT rev_actor FROM `comment` JOIN revision ON comment_id = rev_comment_id WHERE comment_text LIKE '%P2002%' LIMIT 100;

SELECT rev_actor, COUNT(rev_comment_id) AS comments FROM revision WHERE rev_comment_id IN (SELECT comment_id FROM `comment` WHERE comment_text LIKE '%P2002%') GROUP BY rev_actor;