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_user),')') AS edits FROM revision JOIN page ON rev_page = page_id WHERE rev_timestamp BETWEEN 20160101000000 AND 20161231235959 AND page_namespace = 0 AND rev_user <> 0 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...