nlwiki Lijst Torval/PeterKeijsers/Paolingstein (TPP)

SQL

SELECT page_title, ae.actor_name, COUNT(re.rev_timestamp) AS 'count'
FROM revision re, actor ae, (SELECT page_id, page_title
                FROM actor a0, revision rp, page
                WHERE actor_user IS NOT NULL AND actor_name IN ('PeterKeijsers', 'Paolingstein') AND rev_actor=actor_id AND rev_parent_id=0 AND
                rev_page=page_id AND page_namespace=0 AND page_is_redirect=0) t1
WHERE re.rev_page=page_id AND re.rev_actor=ae.actor_id AND re.rev_minor_edit=0
GROUP BY page_title, ae.actor_name
ORDER BY page_title, ae.actor_name

SQL

Checking query status...