Untitled query #58544

SQL

SELECT * FROM logging JOIN comment ON log_comment_id=comment_id WHERE 
log_timestamp > '20240501000000'
AND log_timestamp < '20240601000000'
AND log_action = 'block'
AND comment_text LIKE '[[WP:Disruptive_editing%'

/*
SELECT SUBSTR(rev_timestamp,1,8) AS datum FROM revision JOIN page on rev_page=page_id JOIN actor ON rev_actor=actor_id WHERE
rev_timestamp LIKE '2024%'
AND actor_name != ''
AND page_namespace = 0
AND SUBSTR(rev_timestamp,1,8) NOT IN (
SELECT SUBSTR(rev_timestamp,1,8) AS datum FROM revision JOIN page on rev_page=page_id JOIN actor ON rev_actor=actor_id WHERE
rev_timestamp LIKE '2024%'
AND actor_name = 'Larske'
AND page_namespace = 0
)
GROUP BY datum 
ORDER BY datum
*/
SQL

Checking query status...
