Untitled query #58544

SQL

/*
SELECT COUNT(*) FROM recentchanges WHERE
rc_timestamp > '20220512000000'
AND rc_timestamp < '202206000000'
AND rc_namespace = 0
*/

/*
(SELECT actor_name, rc_type, rc_timestamp, page_title, rc_id, ct_id, ct_tag_id FROM recentchanges INNER JOIN page ON rc_cur_id=page_id INNER JOIN actor on rc_actor=actor_id LEFT JOIN change_tag ON rc_id=ct_rc_id WHERE rc_timestamp>'20220612180000' AND rc_timestamp<'20220613000000' AND rc_bot=0 AND rc_type<2 AND rc_namespace=0 ) 
UNION ALL 
(SELECT actor_name, rc_type, rc_timestamp, page_title, rc_id, ct_id, ct_tag_id FROM recentchanges INNER JOIN page ON rc_cur_id=page_id INNER JOIN actor on rc_actor=actor_id RIGHT JOIN change_tag ON rc_id=ct_rc_id WHERE rc_timestamp>'20220612180000' AND rc_timestamp<'20220613000000' AND rc_bot=0 AND rc_type<2 AND rc_namespace=0 ) 
*/

SELECT actor_name, COUNT(*) AS antal FROM recentchanges INNER JOIN actor ON rc_actor=actor_id 
WHERE rc_new = 1
AND rc_namespace = 6
AND rc_timestamp > '20220612000000'
GROUP BY actor_name
ORDER BY antal DESC, actor_name

/*
SELECT * FROM change_tag_def  
*/
SQL

Checking query status...
