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

--- Comment #10 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Wed, 29 Feb 2012 22:21:46
-------------------------------------------------------------------------------

The problems are the '-' in the table names (names of the sub query returns).
For example the following wont work:

    SELECT page_title,
    zh-classicaliw.ll_title as zh-classical_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 =
'zh-classical') as zh-classicaliw ON zh-classicaliw.ll_from = article.ll_from
    WHERE page_namespace = 0;


But this one will:

    SELECT page_title,
    zhclassicaliw.ll_title as zhclassical_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 =
'zh-classical') as zhclassicaliw ON zhclassicaliw.ll_from = article.ll_from
    WHERE page_namespace = 0;


I hope it's clear what I mean ![][1]

   [1]: https://jira.toolserver.org/images/icons/emoticons/wink.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