SQL
x
/*
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.