Venkat TL's assessments during Tag&Assess2021

SQL

SELECT actor_name, page.page_title
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 LIKE '%#Tag&Assess2021%'

​x
 
SELECT actor_name, page.page_titleFROM 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 LIKE '%#Tag&Assess2021%'​

SQL

Checking query status...