Untitled query #58544

SQL

SELECT actor_name, SUM(IF(cl_to='Kvinnor',1,0)) AS antal_kvinnor, SUM(IF(cl_to='Män',1,0)) AS antal_män, COUNT(*) AS antal,  SUM(IF(cl_to='Kvinnor',1,0))/COUNT(*) AS andel_kvinnor FROM recentchanges INNER JOIN actor ON rc_actor=actor_id INNER JOIN page ON rc_title=page_title INNER JOIN categorylinks ON page_id=cl_from WHERE
rc_namespace = 0
/*
AND actor_name = 'OJH'
*/
AND (cl_to = 'Kvinnor' OR cl_to = 'Män')
GROUP BY actor_name
HAVING antal>=100
ORDER BY andel_kvinnor DESC, antal DESC
LIMIT 100

/*
AND cl_to = 'Kvinnor'
*/

/* SELECT CONCAT('[[',REPLACE(page_title,'_',' '),']]') AS Artikel, COUNT(*) AS Antal_redigeringar_under_2021, COUNT(DISTINCT rev_actor) AS Antal_redigerare_under_2021 FROM revision INNER JOIN page ON rev_page=page_id INNER JOIN actor on rev_actor=actor_id WHERE 
rev_timestamp > '20210101000000' AND rev_timestamp < '20220101000000'
AND page_namespace=0
GROUP BY page_title, page_namespace
ORDER BY Antal_redigeringar_under_2021 DESC, page_title
LIMIT 1000
*/
SQL

Checking query status...
