https://bugzilla.wikimedia.org/show_bug.cgi?id=59402
Web browser: ---
Bug ID: 59402
Summary: DBQ-144 Query to create translated interlanguage links
Product: Tool Labs tools
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: Unprioritized
Component: Database Queries
Assignee: wmf.bugconver...@gmail.com
Reporter: wmf.bugconver...@gmail.com
Classification: Unclassified
Mobile Platform: ---
This issue was converted from https://jira.toolserver.org/browse/DBQ-144.
Summary: Query to create translated interlanguage links
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Hoo man <h...@online.de>
-------------------------------------------------------------------------------
From: Stavros Giannou <afa...@yahoo.com>
Date: Fri, 01 Jul 2011 19:11:57
-------------------------------------------------------------------------------
I want to be able to create a list of interlanguage links of Greek articles
into all other available languages in csv or tab delimited format. I.e. 1st
column is Greek article, 2nd column is article in English (if available), 3rd
column article in French (if available), something similar to this really:
https://jira.toolserver.org/browse/DBQ-116
http://toolserver.org/~hoo/dbq/dbq-116.txt
But I'm not sure how to modify the query below.
So far I have been able to create mappings to one language only at a time, i.e:
SELECT
page.*,
langlinks.*
FROM
page
JOIN langlinks
ON langlinks.ll_from = page_id
WHERE
langlinks.ll_lang = "[language id]"
--
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
