WikiProject India - Tag & Assess 2021 - Results

Fork of Rater.js count of a particular user during Tag-and-Assess by Titodutta

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

SQL

SELECT actor_name, count(DISTINCT page_id)     
FROM revision_userindex r1
JOIN actor_revision ON actor_id = r1.rev_actor
LEFT JOIN page ON page_id = r1.rev_page
LEFT JOIN comment_revision ON comment_id = r1.rev_comment_id
LEFT JOIN revision r2 ON r1.rev_parent_id = r2.rev_id
WHERE actor_name IN ('AshLin', 'DaxServer', 'DEFCON5', 'MPGuy2824', 'Soumitrahazra', 'Titodutta', 'Vis M', 'Rickyurs', 'Arunram', 'Sadenar40000', 'Anupamdutta73', 'Venkat TL')
AND r1.rev_timestamp > '20210901000000' AND r1.rev_timestamp < '20211101000000'
AND comment_text LIKE '%India% %Rater%'
group by actor_name

SQL

Checking query status...