Untitled query #58544

SQL

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


SELECT actor_name AS Märke, COUNT(*) AS antal_redigeringar_i_artikelnamnrymden FROM recentchanges FULL OUTER JOIN change_tag ON rc_id = ct_rc_id INNER JOIN change_tag_def ON ct_tag_id=ctd_id INNER JOIN actor on rc_actor=actor_id WHERE
rc_timestamp > '20220512000000'
AND rc_timestamp < '20220612000000'
AND rc_namespace = 0
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...
