--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<> ---
From: Hoo man <>
Date: Sat, 26 Mar 2011 16:39:42


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

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

Reply via email to