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 >= '20230101000000' 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;