Untitled query #58544

SQL

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


(SELECT rc_type, rc_timestamp, rc_actor, rc_cur_id, page_title, rc_id, ct_id FROM recentchanges INNER JOIN page ON rc_cur_id=page_id LEFT JOIN change_tag ON rc_id=ct_rc_id WHERE rc_timestamp>'20220610000000' AND rc_type=1 AND rc_namespace=0 AND ct_id IS NULL) 
UNION ALL 
(SELECT rc_type, rc_timestamp, rc_actor, rc_cur_id, page_title, rc_id, ct_id FROM recentchanges INNER JOIN page ON rc_cur_id=page_id RIGHT JOIN change_tag ON rc_id=ct_rc_id WHERE rc_timestamp>'20220610000000' AND rc_type=1 AND rc_namespace=0 AND ct_id IS NULL) 

/*
AND ctd_name = "visualeditor"
GROUP BY actor_name HAVING antal_redigeringar_i_artikelnamnrymden > 9
ORDER BY antal_redigeringar_i_artikelnamnrymden DESC, ctd_name
*/
SQL

Checking query status...
