Untitled query #23158

SQL

/*
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;
SQL

Checking query status...
