4) Největším počtem registrovaných uživatelů editované články, bez revertů

SQL

use cswiki_p;
SELECT concat('# [[',replace(page_title,'_',' '),']] (',COUNT(DISTINCT rev_actor),')'), COUNT(DISTINCT rev_actor) AS edits FROM revision JOIN page ON rev_page = page_id WHERE rev_timestamp BETWEEN 20181231230000 AND 20191231225959 AND page_namespace = 0 AND rev_actor IN (select actor_id from actor where actor_user <> NULL) AND rev_comment NOT REGEXP 'Verze [0-9][0-9]* uživatele' AND rev_comment NOT LIKE '%do předchozího stavu%' AND rev_comment NOT LIKE 'rv%' AND rev_comment NOT LIKE '%revert%' AND rev_comment NOT LIKE '%vandal%' GROUP BY rev_page ORDER BY edits DESC, page_title ASC LIMIT 1000;

SQL

Checking query status...