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',1,0))  AS antal_disk, SUM(IF(page_namespace % 2=1,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 > '20241028000000' 
AND rev_timestamp < '20241128000000'
GROUP BY actor_name
HAVING antal_redigeringar>99 AND antal_disk>0
ORDER BY andel_diskussion DESC
SQL

Checking query status...
