Untitled query #58544

SQL

SELECT log_timestamp, actor_name, REPLACE(comment_text,',','§') AS commenttext FROM logging JOIN comment ON log_comment_id=comment_id JOIN actor on log_actor=actor_id WHERE 
log_timestamp > '20230601000000'
AND log_timestamp < '20240601000000'
AND log_action = 'block'

/*
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...
