Statements added/updated by a User

SQL

SELECT current_date;
SELECT actor_name as Username, COUNT(*) as Number_of_labels_added, comment_text
FROM (
SELECT 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
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_namespace = 0) as derivedtable
GROUP BY actor_name ORDER BY Number_of_labels_added desc;

SQL

Checking query status...