On 9/14/06, Aerik Sylvan aerik@thesylvans.com wrote:
Whoa - intersection "tables"? Why more than one? You lost me.
Okay: a table.
Also, I figured you could get higher order intersections from lower ones, but how do you go the other way?
Assume you have a table of all two-category intersections. If you want to get a list of articles containing A, take the union of all intersections of A with any other category. That will only omit articles whose only category is A.
If someone can point me where I can download the categorylinks table (*only* preferably) I'll get it and throw some sql at it. It'll take me a couple of days to get around to.
You want http://download.wikimedia.org/enwiki/20060911/enwiki-20060911-categorylinks.... (108 MB gzipped). download.wikimedia.org for all your data dump needs. :)