Venkat TL's assessments during Tag&Assess2021

SQL

SELECT actor_name, r1.rev_timestamp, comment_text, 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%' OR comment_text like '%Assessment%India%')

​x
 
SELECT actor_name, r1.rev_timestamp, comment_text, 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%' OR comment_text like '%Assessment%India%')​

SQL

Checking query status...