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

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Sat, 26 Mar 2011 16:39:42
-------------------------------------------------------------------------------

SQL:  


    SELECT DISTINCT page_title, 'A' FROM (SELECT page_title as cat FROM page
INNER JOIN categorylinks ON page_id = cl_from INNER JOIN category ON cat_title
= page_title WHERE page_namespace = 14 AND categorylinks.cl_to =
'A-Class_articles' AND cat_pages - cat_subcats > 0 ORDER BY RAND() LIMIT 125)
as categories INNER JOIN categorylinks ON categories.cat = categorylinks.cl_to
INNER JOIN page ON categorylinks.cl_from = page.page_id WHERE page_title NOT
LIKE "%-class%" ORDER BY RAND() LIMIT 100;

(Query for A-class articles, same for every category, except of FA)  
Result:  
http://toolserver.org/~hoo/dbq/dbq-131.txt

-- 
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