On Fri, Mar 20, 2009 at 1:08 PM, O. O. <olson...@yahoo.com> wrote: > I cannot understand why there are more redirects in the redirect table > than there are in the pages in the Page table with the redirect flag set. > > select count(*) from wikidb.redirect ; --- Gives 3422938 > > while > > select count(*) from wikidb.page where page_is_redirect=1; --- Gives > 3242340 > > Why should there be this difference? Are there redirects that are not > listed in the Page Table?
It's denormalized data, so I'd assume that those are just errors of some kind. If you need to be really really sure whether something is a redirect, you have to parse its text (it's just a regex, should be somewhere in includes/Article.php or something). That's the authoritative check, which IIRC is used when actually deciding whether to redirect. _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l