Liczba edycji w przestrzeni Strona plwikisource w latach 2013-2022

Fork of Liczba edycji w przestrzeni Strona plwikisource w 2022 roku by Ankry

This query is marked as a draft This query has been published by Ankry.

SQL

USE plwikisource_p;
SET @w:=0;
SELECT @w:=@w+1 AS 'Lp',/*`Użytkownik`,*/`Link`,`Liczba edycji`
FROM (SELECT user_name AS 'Użytkownik', CONCAT('[[Wikiskryba:',user_name,'|',user_name,']]') AS 'Link', COUNT(*) AS 'Liczba edycji'
	FROM actor JOIN revision ON rev_actor=actor_id JOIN user ON actor_user=user_id JOIN page ON rev_page=page_id
    WHERE rev_timestamp >= '20130101000000' AND
          rev_timestamp < '20230101000000' AND
          page_namespace = 100 AND
          NOT UCASE(CONVERT(user_name USING utf8)) RLIKE 'BOT'
    GROUP BY user_name
    HAVING `liczba edycji`>100
    ORDER BY 3 DESC
    LIMIT 100) AS A;

SQL

Checking query status...