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

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Fri, 22 Apr 2011 22:25:36
-------------------------------------------------------------------------------

I did it that way: I got all pages (namespace 0) from the categories
'Popular_Science_Monthly_Volume_1-25' and saved them in a temporary table.
Afterwards I got all categories for these pages. I hope that's what you wanted
![][1]  
SQL:

    SELECT page.page_title FROM categorylinks INNER JOIN page ON page.page_id =
categorylinks.cl_from WHERE cl_to IN (
    'Popular_Science_Monthly_Volume_1',
    'Popular_Science_Monthly_Volume_2',
    /* ... */
    'Popular_Science_Monthly_Volume_25') AND page.page_namespace = 0;

    SELECT dbq136.page_title, categorylinks.cl_to FROM u_hoo.dbq136 INNER JOIN
page ON dbq136.page_title = page.page_title INNER JOIN categorylinks ON
categorylinks.cl_from = page.page_id WHERE page.page_namespace = 0;


Result:  
http://toolserver.org/~hoo/dbq/dbq-136.txt (plain text)

   [1]: https://jira.toolserver.org/images/icons/emoticons/wink.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