Users with right to vote at ptwiki

SQL

use ptwiki_p;

SELECT
    editor, revisions, primeira
FROM (
    /* Get 300 revisions to content pages that are still visible */
    SELECT
        rev_user_text as editor,
        SUM(rev_id IS NOT NULL) AS revisions
  	JOIN page
  	ON rev_page = page_id
    FROM
        revision
    WHERE
        rev_user != 0
    AND
  		page_namespace = 0
    GROUP BY user
  	HAVING
    SUM(revisions) >= 300

    LEFT JOIN
    /* Get first edit */
    SELECT
        rev_user_text as user,
        min(rev_timestamp) AS primeira
    FROM
        revision
    WHERE
        rev_timestamp<= 20160729000000

    ) AS user_content_revision_count

GROUP BY
    editor
SQL

Checking query status...
