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
  	FROM
        revision
    JOIN page
  	ON 
  		rev_page = page_id
    WHERE
        page_namespace = 0
    GROUP BY editor
    HAVING
    	revisions >=300) as tabela1
    inner join tabela2
    on tabela1.editor = tabela2.editor
(SELECT
        rev_user_text as editor,
        min(rev_timestamp) AS primeira
    FROM
        revision
    WHERE
        rev_timestamp<= 20160729000000) as tabela2)
GROUP BY
    editor
SQL

Checking query status...
