Statements added/updated by a User

SQL

SELECT rev_id, rc_timestamp, actor_name, rc_title, comment_text
FROM recentchanges
LEFT JOIN comment ON comment.comment_id = recentchanges.rc_comment_id
LEFT JOIN actor on actor.actor_id = recentchanges.rc_actor
LEFT JOIN revision on revision.rev_id = recentchanges.rc_this_oldid
WHERE actor_name IN ('Gnoeee')
AND rc_timestamp >= '2024-03-31 18:30:00'
AND rc_timestamp < '2024-04-02 18:30:00'
AND rc_type IN (0, 1)
AND (tag_summary.ts_name = 'wbsetclaim-create' OR tag_summary.ts_name = 'wbsetclaim-update')
AND wb_changes.wbc_prop = 'P625'
ORDER BY rc_id DESC;

SQL

Checking query status...