Untitled query #58544

SQL

/*
SELECT iwl_prefix, COUNT(*) AS antal FROM iwlinks JOIN page ON iwl_from=page_id WHERE 
*/
/*SELECT * FROM iwlinks JOIN page ON iwl_from=page_id WHERE
page_namespace = 0
AND iwl_prefix LIKE 'bibcode'
*/
/*
GROUP BY iwl_prefix
ORDER BY antal DESC
*/

/*
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 > '20240829000000' 
AND rev_timestamp < '20241129000000'
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...
