--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<> ---
From: DaB. <>
Date: Sun, 06 Jan 2008 01:52:10

SELECT page_namespace,page_title,page_len   
FROM revision,page   
LEFT JOIN templatelinks   
ON tl_from = page_id   
WHERE page_len<50   
AND page_is_redirect = 0   
AND page_namespace NOT IN (2, 3)   
AND rev_page=page_id   
AND tl_from IS NULL   
GROUP BY rev_user  
HAVING count(DISTINCT rev_user)<2  
ORDER BY page_len   

seems to do what you want (the join with toolserver.namespace is missing,
that's trivial ![][1]). But perhaps Duesentrieb knows a better way ![][2]


P.S: on dewp the query needs 8 min 5.23 sec and 0.31 sec on cswp.


You are receiving this mail because:
You are on the CC list for the bug.
Wikibugs-l mailing list

Reply via email to