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

SQL

SELECT concat('# [[',replace(page_title,'_',' '),']] (',COUNT(DISTINCT rev_actor),')'), COUNT(DISTINCT rev_actor) AS edits FROM revision JOIN page ON rev_page = page_id JOIN comment ON rev_comment_id = comment_id WHERE rev_timestamp BETWEEN 20171231230000 AND 20181231225959 AND page_namespace = 0 AND rev_actor IN (SELECT actor_id FROM actor WHERE actor_user IS NOT NULL) AND comment_text NOT REGEXP 'Verze [0-9][0-9]* uživatele' AND comment_text NOT LIKE '%do předchozího stavu%' AND comment_text NOT LIKE 'rv%' AND comment_text NOT LIKE '%revert%' AND comment_text NOT LIKE '%vandal%' GROUP BY rev_page ORDER BY edits DESC, page_title ASC LIMIT 1000;

SQL

Checking query status...