https://bugzilla.wikimedia.org/show_bug.cgi?id=59260

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: DaB. <d...@ts.wikimedia.org>
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   
LIMIT 20;

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]

Sincerly,  
DaB.

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

   [1]: https://jira.toolserver.org/images/icons/emoticons/wink.gif
   [2]: https://jira.toolserver.org/images/icons/emoticons/smile.gif

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to