Untitled query #6881

SQL

use ptwiki_p;

#desc revision;

SELECT r.rev_user_text AS REVERSOR, rp.rev_user_text AS REVERTIDO, 
p.page_title AS ARTIGO, p.page_namespace AS NAMESPACE,
count(*) AS TOTAL,
concat(r.rev_user_text,rp.rev_user_text) AS REV_ID_1,
concat(rp.rev_user_text,r.rev_user_text) AS REV_ID_2
FROM revision r
INNER JOIN revision rp ON  r.rev_parent_id = rp.rev_id  
INNER JOIN revision rpp ON rp.rev_parent_id = rpp.rev_id 
INNER JOIN page p ON r.rev_page = p.page_id
WHERE r.rev_timestamp > 20160000000000 
and r.rev_sha1  = rpp.rev_sha1 
and r.rev_user != 0
and rp.rev_user != 0
and p.page_title = "Eça_de_Queirós"
GROUP BY 1,2,3
ORDER BY ARTIGO
;
SQL

Checking query status...
