Untitled query #58544

SQL

SELECT * FROM iwlinks 
WHERE iwl_prefix = 'en'
LIMIT 10000
/*
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 > '20231119000000' 
AND rev_timestamp < '20241119000000'
/*
actor_name IN ('Larske','Lakonisk')
*/
/*
GROUP BY actor_name
HAVING antal_redigeringar>99 AND antal_disk>0
ORDER BY andel_diskussion DESC
*/
SQL

Checking query status...
