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

--- Comment #3 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Tue, 25 Oct 2011 19:44:00
-------------------------------------------------------------------------------

Well, I still don't know what exactly you want... so I did for the pages in the
category (and not for the category itself). Please reopen if you need smth.
different.

SQL:

    SELECT /* SLOW_OK */ categorylinks.* FROM categorylinks as page_list INNER
JOIN categorylinks ON categorylinks.cl_from = page_list.cl_from WHERE
page_list.cl_to = 'Software_engineering';
    SELECT /* SLOW_OK */ pagelinks.* FROM categorylinks as page_list INNER JOIN
pagelinks ON pagelinks.pl_from = page_list.cl_from WHERE page_list.cl_to =
'Software_engineering';


Result:  
http://toolserver.org/~hoo/dbq/dbq-163_1.txt (categorylinks)  
http://toolserver.org/~hoo/dbq/dbq-163_2.txt (pagelinks)

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