https://bugzilla.wikimedia.org/show_bug.cgi?id=59255
--- Comment #4 from Bugzilla Bug Importer (valhallasw) <wmf.bugconver...@gmail.com> --- ------------------------------------------------------------------------------- From: Daniel Kinzler <dan...@brightbyte.de> Date: Sun, 28 Oct 2007 15:11:56 ------------------------------------------------------------------------------- For future reference: where ... not in (select ...) is rather slow if you do it on a lot of entries. rather use left join ... where x is null. Anyway, the above query will only find pages without any template. there's a lot of non-license templates. I have built a list of license templates, and a view that is like templatelinks, but only for license templates - that would give a more accurate result I hope. Oh well, maybe next time ![][1] hm, perhaps i should make this stuff available somewhere, somehow. maybe create a commonswiki_aux_p database containing "auxiliary" data? [1]: https://jira.toolserver.org/images/icons/emoticons/smile.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