Untitled query #87941

SQL

-- Define the editor name, start date, and end date
SET @editor_name = "Zero0000"; -- Replace with the actual editor's username
SET @start_date = '2023-01-01 00:00:00'; -- Replace with the desired start date
SET @end_date = '2023-12-31 23:59:59'; -- Replace with the desired end date;

-- Step 1: Count the total edits made by the editor in the given time period
SELECT 
    COUNT(*) AS total_edits
FROM 
    revision
JOIN 
    actor ON revision.rev_actor = actor.actor_id
WHERE 
    actor.actor_name = @editor_name
    AND revision.rev_timestamp BETWEEN @start_date AND @end_date;

-- Step 2: Count the edits by the editor that were reverted
SELECT 
    COUNT(DISTINCT reverted.rev_id) AS reverted_edits
FROM 
    revision AS reverted
JOIN 
    comment ON reverted.rev_comment_id = comment.comment_id
JOIN 
    revision AS reverting ON reverting.rev_comment_id = comment.comment_id
JOIN 
    actor ON reverted.rev_actor = actor.actor_id
WHERE 
    actor.actor_name = @editor_name
    AND reverted.rev_timestamp BETWEEN @start_date AND @end_date
    AND comment.comment_text LIKE '%revert%';
SQL

Checking query status...
