nlwiki Pages with the same content

SQL

USE nlwiki_p;
SELECT p2.page_namespace,p2.page_title,r2.rev_len,r2.rev_timestamp,s2.rev_sha1
FROM `page` p2, `revision` r2, (
	SELECT rev_sha1, COUNT(rev_sha1) 
	FROM (
		SELECT rev_sha1
		FROM `page` p1,`revision` r1
		WHERE 
			page_latest=rev_id AND 
			rev_len>0 AND
			page_is_redirect=0 AND
			(page_namespace MOD 2)=0 AND
			(page_namespace!=2 OR rev_content_format NOT IN ('text/css','text/javascript')) AND
			page_namespace!=14) s1
	GROUP BY rev_sha1
	HAVING COUNT(rev_sha1) > 1) s2
WHERE 
	p2.page_latest=r2.rev_id AND
	r2.rev_sha1=s2.rev_sha1
ORDER BY r2.rev_len DESC, s2.rev_sha1, r2.rev_timestamp
LIMIT 1000
SQL

Checking query status...
