https://bugzilla.wikimedia.org/show_bug.cgi?id=60031
Umherirrender <umherirrender_de...@web.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |tylerro...@gmail.com,
| |umherirrender_de...@web.de
--- Comment #3 from Umherirrender <umherirrender_de...@web.de> ---
No joins are added to the sql.
You wrote:
< 2014-01-14 09:02:56.881 CET >ERROR: column « tl_namespace » doesn’t exist at
character 54
< 2014-01-14 09:02:56.881 CET >INSTRUCTION : SELECT /*
WantedTemplatesPage::reallyDoQuery Low */ tl_namespace AS namespace,tl_title
AS title,COUNT(*) AS value FROM "page" WHERE (page_title IS NULL) AND
tl_namespace = '10' GROUP BY tl_namespace,tl_title ORDER BY value DESC LIMIT
51
Reformatted is that:
SELECT /* WantedTemplatesPage::reallyDoQuery Low */
tl_namespace AS namespace,
tl_title AS title,
COUNT(*) AS value
FROM "page"
WHERE (page_title IS NULL)
AND tl_namespace = '10'
GROUP BY tl_namespace,tl_title
ORDER BY value DESC LIMIT 51
But the correct sql would be: (example from mysql)
SELECT
tl_namespace AS namespace,
tl_title AS title,
COUNT(*) AS value
FROM `templatelinks`
LEFT JOIN `page`
ON ((page_namespace = tl_namespace) AND (page_title = tl_title))
WHERE (page_title IS NULL)
AND tl_namespace = '10'
GROUP BY tl_namespace,tl_title
ORDER BY value DESC LIMIT 51
There is the templatelinks table and with that table the column tl_namespace is
known.
--
You are receiving this mail because:
You are the assignee for the bug.
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
