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 NOT LIKE NULL) AND rev_comment_id NOT IN (select comment_id from comment where comment_text REGEXP 'Verze [0-9][0-9]* uživatele' OR comment_text LIKE '%do předchozího stavu%' OR comment_text LIKE 'rv%' OR comment_text LIKE '%revert%' OR comment_text LIKE '%vandal%') GROUP BY rev_page ORDER BY edits DESC, page_title ASC LIMIT 1000;

SQL

Checking query status...