Untitled query #58544

SQL

SELECT actor_name AS användare, COUNT(*) AS antal_biografiredigeringar, SUM(IF(cl_to='Kvinnor',1,0)) AS därav_antal_kvinnor, SUM(IF(cl_to='Män',1,0)) AS därav_antal_män,  SUM(IF(cl_to='Kvinnor',1,0))/COUNT(*) AS andel_kvinnor, MIN(rc_timestamp) AS från, MAX(rc_timestamp) AS till 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 rc_bot = 0
AND NOT rc_source = 'wb'
AND (cl_to = 'Kvinnor' OR cl_to = 'Män')
GROUP BY actor_name
HAVING antal_biografiredigeringar>=15
ORDER BY antal_biografiredigeringar DESC, andel_kvinnor DESC
LIMIT 100

/* 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...
