Untitled query #78262

SQL

USE ukwiki_p;

SELECT  
    @rownum := @rownum + 1 AS rank,
    actor_name,
    created,
    percents
FROM (
    SELECT
        CONCAT('[[Користувач:', actor_name, '|]]') AS actor_name,
        COUNT(1) AS created,
        CONCAT(
            ROUND(
                COUNT(1) / (
                    SELECT COUNT(1)
                    FROM page
                    JOIN (SELECT DISTINCT pl_from FROM pagelinks) pl
                        ON pl_from = page_id
                    WHERE page_namespace = 0 AND page_is_redirect = 0
                ) * 100,
                2
            ),
            '%'
        ) AS percents
    FROM page
    JOIN revision
        ON rev_page = page_id AND rev_parent_id = 0
    JOIN (SELECT DISTINCT pl_from FROM pagelinks) pl
        ON pl_from = page_id
    JOIN actor ON actor_id = rev_actor
    WHERE
        page_namespace = 0 AND
        page_is_redirect = 0
    GROUP BY rev_actor
    HAVING 
        created >= 30 AND
        NOT EXISTS (
            SELECT 1 FROM user_groups
            WHERE ug_user = rev_actor AND (ug_group = 'bot' OR ug_group = 'бот')
        )
    ORDER BY created DESC
) t, (SELECT @rownum := 0) r
ORDER BY created DESC;
SQL

Checking query status...
