Venkat TL's assessments during Tag&Assess2021

SQL

SELECT actor_name, comment_text, 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 ('Venkat TL')
AND r1.rev_timestamp > '20210901000000' AND r1.rev_timestamp < '20211101000000'
AND comment_text NOT LIKE '%India% %Rater%'
group by actor_name

AخA
 
SELECT actor_name, comment_text, page_idFROM revision_userindex r1JOIN actor_revision ON actor_id = r1.rev_actorLEFT JOIN page ON page_id = r1.rev_pageLEFT JOIN comment_revision ON comment_id = r1.rev_comment_idLEFT JOIN revision r2 ON r1.rev_parent_id = r2.rev_idWHERE actor_name IN ('Venkat TL')AND r1.rev_timestamp > '20210901000000' AND r1.rev_timestamp < '20211101000000'AND comment_text NOT LIKE '%India% %Rater%'group by actor_name

SQL

Checking query status...