https://bugzilla.wikimedia.org/show_bug.cgi?id=59286
--- Comment #9 from Bugzilla Bug Importer (valhallasw)
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: CBM <cbm.wikipe...@gmail.com>
Date: Fri, 15 Aug 2008 22:11:25
-------------------------------------------------------------------------------
What went wrong is that the page_namespace in the final subquery was already
limited to equal 2 earlier on, so the subquery can never return any rows.
Here's a query that should generate more useful data:
select concat('[[Template:',t_title,']] ', page_is_redirect)
from (select distinct tl_title as t_title from templatelinks
where tl_namespace = 10) as temp
join page on page_namespace = 10 and page_title = temp.t_title
where not exists
(select 1 from page join templatelinks
on page_id = tl_from and tl_namespace = 10
where tl_title = t_title and page_namespace != 2 );
I put the results at http://toolserver.org/~cbm/data/DBQ-30.txt
--
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
