Untitled query #58544

SQL

SELECT actor_name, COUNT(*) AS antal FROM revision INNER JOIN page ON rev_page=page_id INNER JOIN actor ON rev_actor=actor_id WHERE 
page_title LIKE 'Opinionsundersökningar_inför_riksdagsvalet_i_Sverige_2022' AND
page_namespace = 0
GROUP BY actor_name
ORDER BY antal DESC


/*
SELECT  page_title, MAX(rc_timestamp) AS senast, COUNT(*) AS antal FROM recentchanges INNER JOIN page ON rc_title=page_title INNER JOIN categorylinks ON page_id=cl_from WHERE
rc_timestamp > '20221101000000' AND
rc_type < 5 AND
(cl_to = 'Kvinnor' OR cl_to = 'Män')
GROUP BY page_title
*/
SQL

Checking query status...
