This query is marked as a draft This query has been published by Tacsipacsi.

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.

Checking query status...