Untitled query #58544

SQL

SELECT page_title, COUNT(*) AS antal FROM page JOIN revision ON page_id=rev_page JOIN actor ON rev_actor=actor_id WHERE
rev_timestamp > '20230101000000'
AND page_namespace = 10
AND actor_name = 'Larske'
GROUP BY page_title
ORDER BY page_title


/*SELECT actor_name, COUNT(*) AS antal, MIN(rc_timestamp), MAX(rc_timestamp) FROM recentchanges JOIN actor ON rc_actor=actor_id JOIN page ON rc_title=page_title JOIN categorylinks ON page_id=cl_from  WHERE
rc_type = 1
AND page_namespace = 0
AND (cl_to = 'Kvinnor' OR cl_to = 'Män')
GROUP BY actor_name
ORDER BY antal DESC
*/
SQL

Checking query status...
