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

--- Comment #6 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Tue, 28 Feb 2012 19:34:44
-------------------------------------------------------------------------------

The following SQL query returns the page title (on elwiki), the lang the link
goes to and the title on the target wiki for namespace 0 (articles).

    SELECT page_title, ll_lang, ll_title FROM langlinks INNER JOIN page ON
page_id = ll_from WHERE page_namespace = 0;

Which produces an output like:

    +------------+---------+-----------------------+
    | page_title | ll_lang | ll_title              |
    +------------+---------+-----------------------+
    | %          | da      | Procenttegn           |
    | %          | en      | Percent sign          |
    | %          | fr      | Pour cent             |
    | %          | ja      | パーセント記号 |
    | %          | ko      | %                     |
    +------------+---------+-----------------------+

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