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

--- Comment #8 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Tue, 28 Feb 2012 21:14:18
-------------------------------------------------------------------------------

The following query has to be altered where the /* ... */ are (a row for every
language you want to have has to be added):

    SELECT page_title,
    deiw.ll_title as de_title
    /* ... */
    FROM (SELECT ll_from FROM langlinks GROUP BY ll_from) as article INNER JOIN
page ON page_id = article.ll_from 
    LEFT JOIN (SELECT ll_title, ll_from FROM langlinks WHERE ll_lang = 'de') as
deiw ON deiw.ll_from = article.ll_from
    /* ... */
    WHERE page_namespace = 0;


Well, it's by far not a perfect solution and I hardly doubt it will be fast
enough to work, but the best I can think of at the moment for your specific
data format.

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