Untitled query #58544

SQL

(SELECT SUBSTR(rev_timestamp,1,8) AS datum, COUNT(*) AS antal FROM revision JOIN page on rev_page=page_id JOIN actor ON rev_actor=actor_id WHERE
rev_timestamp > '20240101000000'
AND actor_name != 'LittleGun'
AND page_namespace = 0
 GROUP BY datum)
MINUS 
SELECT SUBSTR(rev_timestamp,1,8) AS datum, COUNT(*) AS antal FROM revision JOIN page on rev_page=page_id JOIN actor ON rev_actor=actor_id WHERE
rev_timestamp > '20240101000000'
AND actor_name = 'LittleGun'
AND page_namespace = 0
GROUP BY datum
SQL

Checking query status...
