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

    LEFT JOIN tabela2
    on tabela1.editor = tabela2.editor
    
    /* Get first edit */
    (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...
