--- Comment #8 from Bugzilla Bug Importer (valhallasw) 
<> ---
From: Hoo man <>
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

Reply via email to