https://bugzilla.wikimedia.org/show_bug.cgi?id=59272
--- Comment #4 from Bugzilla Bug Importer (valhallasw) <wmf.bugconver...@gmail.com> --- ------------------------------------------------------------------------------- From: SQL <sxw...@gmail.com> Date: Fri, 09 May 2008 13:27:28 ------------------------------------------------------------------------------- I've added a query that looks like it worked to me, output at http://tools.wikimedia.de/~sql/mz3.txt.gz . SELECT CONCAT(ns_name, ':', page_title) FROM page JOIN redirect ON page_id=rd_from JOIN toolserver.namespace ON dbname='enwiki_p' AND ns_id = page_namespace WHERE page_namespace=1 OR page_namespace=3 OR page_namespace=5 OR page_namespace=7 OR page_namespace=9 OR page_namespace=11 OR page_namespace=15 OR page_namespace=101 AND rd_namespace=1 OR rd_namespace=3 OR rd_namespace=5 OR rd_namespace=7 OR rd_namespace=9 OR rd_namespace=11 OR rd_namespace=15 OR rd_namespace=101 AND (SELECT count![][1] FROM pagelinks WHERE pl_namespace=page_namespace AND pl_title=page_title)=0; Execution took appx 8mins. [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
