Untitled query #58544

SQL

/*
SELECT * FROM revision JOIN actor ON rev_actor=actor_id JOIN page on rev_page=page_id WHERE
rev_timestamp > '20200512000000'
AND rev_timestamp < '20200713000000'
AND page_namespace IN (1,3,5,7,9,11,13,15)
AND actor_name LIKE '%-%'
*/

SELECT actor_name, COUNT(*) AS antal_redigeringar, SUM(IF(page_namespace%2=1 OR page_title='Bybrunnen' OR page_title='Kommentarer_om_administrationen_av_Wikipedia',1,0))  AS antal_disk, SUM(IF(page_namespace % 2=1 OR page_title='Bybrunnen' OR page_title='Kommentarer_om_administrationen_av_Wikipedia',1,0))/COUNT(*) AS andel_diskussion FROM revision JOIN page ON rev_page=page_id JOIN actor ON rev_actor=actor_id WHERE
rev_timestamp > '20240915000000' 
AND rev_timestamp < '20241215000000'
AND actor_name != 'MediaWiki message delivery'
AND actor_name != 'EnBotEn'
AND actor_name NOT LIKE '%Bot'
AND actor_name NOT LIKE '%bot'
AND actor_name != 'Perfect'
GROUP BY actor_name
HAVING antal_redigeringar>99 AND antal_disk>0
ORDER BY andel_diskussion DESC

/*
SELECT CONCAT(IF(page_namespace IN (0,1),'[[',''),REPLACE(page_title,'_',' '),IF(page_namespace IN (0,1),']]','')) AS titel,
SUM(IF(page_namespace=0,1,0)) AS artikelredigeringar, 
SUM(IF(page_namespace=1,1,0)) AS artikeldisk, 
SUM(IF(page_namespace=3,1,0)) AS användardisk, 
COUNT(*) AS totalt, 
MIN(rev_timestamp) AS tidigaste, 
MAX(rev_timestamp) AS senaste, 
DATEDIFF(MAX(rev_timestamp),MIN(rev_timestamp)) AS dagar_mellan_tidigaste_och_senaste 
FROM revision JOIN page ON rev_page=page_id JOIN actor ON rev_actor=actor_id WHERE 
actor_name = 'FWIlkens'
/*
AND page_namespace IN (0,1,3)
*/
/*
AND rev_timestamp > '20231201000000'
AND rev_timestamp < '20241201000000'
GROUP BY page_title
ORDER BY totalt DESC, artikelredigeringar DESC, artikeldisk DESC, användardisk DESC, titel
*/
SQL

Checking query status...
