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('[[',REPLACE(page_title,'_',' '),']]') 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, MAX(rev_timestamp) AS senaste_redigering 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 > '20231130000000'
AND rev_timestamp < '20241130000000'
GROUP BY page_title 
ORDER BY totalt DESC, artikelredigeringar DESC, artikeldisk DESC, användardisk DESC, titel
SQL

Checking query status...
