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
LEFT JOIN wb_changes on wb_changes.wbc_entity_id = recentchanges.rc_cur_id
LEFT JOIN wb_changes_tags on wb_changes.wbc_id = wb_changes_tags.wbct_rc_id
LEFT JOIN tag_summary ON wb_changes_tags.wbct_tag_id = tag_summary.ts_tag_id
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...
