Wikiskrybowie z największą liczbą edycji (do 2024 roku)

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 >= '00000000000000' AND
          rev_timestamp < '20240101000000' AND
          page_namespace IN (0,100,102,104,124) 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...