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

--- Comment #3 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Kylu <k...@ts.wikimedia.org>
Date: Sun, 13 Apr 2008 21:34:04
-------------------------------------------------------------------------------

ns:1 select count![][1]/**page_title,rd_title**/ from page,redirect where
page_id=rd_from and page_namespace=1 and rd_namespace=1 and (select count![][1]
from pagelinks where pl_namespace=page_namespace and pl_title=page_title)=0;

other enwiki_p talkpage namespaces: 3,5,7,9,11,15,101

Will post to
https://wiki.ts.wikimedia.org/view/Query_service/Unused_talk_redirects

  * Update 17 Apr 2008: Not done. TS Admins note that the query, as written,
uses too many resources. Try converting the query you gave me to JOIN and
reissue.

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