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

--- Comment #3 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Thu, 06 Jan 2011 20:20:45
-------------------------------------------------------------------------------

I've executed the query you wanted, but I haven't yet been able to convert it
into the XML format you requested. May I'm going to convert it later, but for
now I've uploaded the results in 3 formats in the hope that you can use one
![][1]

SQL:

    SELECT pagelinks.pl_title as en_title, langlinksta.iw_title as ta_title,
langlinkshi.iw_title as hi_title FROM page INNER JOIN pagelinks ON page.page_id
= pagelinks.pl_from LEFT JOIN (SELECT langlinks.ll_title as iw_title,
page.page_title as title FROM page INNER JOIN langlinks ON page.page_id =
langlinks.ll_from WHERE langlinks.ll_lang = 'ta') as langlinksta ON
langlinksta.title = pagelinks.pl_title LEFT JOIN (SELECT langlinks.ll_title as
iw_title, page.page_title as title FROM page INNER JOIN langlinks ON
page.page_id = langlinks.ll_from WHERE langlinks.ll_lang = 'hi') as langlinkshi
ON langlinkshi.title = pagelinks.pl_title WHERE page.page_namespace = 2 AND
page.page_title = 'Mahir78/List_of_towns_and_cities_in_India' AND
pagelinks.pl_namespace = 0 GROUP BY en_title;


Result:  
http://toolserver.org/~hoo/dbq/dbq-116.txt (plain text)  
http://toolserver.org/~hoo/dbq/dbq-116_html.txt (xhtml table)  
http://toolserver.org/~hoo/dbq/dbq-116_wiki.txt (wiki table)

   [1]: 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