SELECT  (ROW_NUMBER() OVER (PARTITION BY 'Total' ORDER BY COUNT(*) DESC)) AS '#',

    concat('[[Username:',actor_name,'|',actor_name,']]') as 'Username/a', COUNT(*) as 'Total'

FROM

    logging, actor

    WHERE

        log_type= 'thanks'

    AND

        actor_id = log_actor

    AND

        SUBSTR(log_timestamp,1,4) = '2022'

    AND

        log_namespace = '2'

    GROUP BY actor_name

    ORDER BY COUNT(*) DESC

LIMIT 100