Untitled query #58544

SQL

SELECT page_title, MIN(rev_timestamp) AS forsta, MAX(rev_timestamp) AS sista, COUNT(*) AS antal FROM revision INNER JOIN page ON rev_page=page_id INNER JOIN actor ON rev_actor=actor_id WHERE 
page_namespace = 0 AND
actor_name = 'Historiker'
GROUP BY page_title
HAVING antal>9
ORDER BY antal DESC

/*
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
HAVING antal>2 AND antal<=9
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...
