Untitled query #58544

SQL

SELECT * FROM revision JOIN comment ON rev_comment_id=comment_id JOIN page on rev_page=page_id WHERE
rev_page = 30033845 
AND rev_timestamp > '20240629000000'
AND comment_text LIKE '%Jordstuga%'

/*
SELECT rc_timestamp, rc_title, actor_name, comment_text FROM recentchanges JOIN comment ON rc_comment_id=comment_id JOIN actor ON rc_actor=actor_id WHERE
rc_timestamp > '20240601000000'
AND comment_text LIKE '%ILL%'
*/
/*
SELECT log_timestamp, log_title, actor_name, log_params, 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 > '20230101000000'
AND log_timestamp < '20240601000000'
AND log_action = 'block'
AND (log_params LIKE '%week%' OR log_params LIKE '%month%' OR log_params LIKE '%year%')
AND NOT log_title LIKE '%.%'
AND NOT log_title LIKE '%:%'
ORDER BY log_timestamp DESC
*/
/*
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...
