Indeed I followed this structure, selecting only category pages and I obtained e.g. 690070 (sub category "Futurama", cl_from) to parent category "Comic_science_fiction" e.g. 690451 (sub category "World War II", cl_from) to parent category "Conflicts_in_1939"
so I my perception is the first example is correct, instead World War II should be parent of Conflicts_in_1939
Am I right or am I missing / misunderstood something?
I don't understand why the two should be different. Futurama is a comic science fiction, so Category:Futurama is a subcategory of Category:Comic science fiction. World War II is a conflict that was in progress in 1939, so Category:World War II is a subcategory of Category:Conflicts in 1939. This seems consistent to me.
If I look at the categorylinks for that category (cl_from = 690451) in
the
latest dump, I get some “conflicts” categories, then some “Wars
involving X”
categories and also few others, like “Modern Europe”. I don't see any
parent
category that would be missing.
That's correct for Modern Europe but if you compare with the page http://en.wikipedia.org/wiki/Category:World_War_II you see some links are missing in the sql dump, such as:
http://en.wikipedia.org/wiki/Category:Military_deception_during_World_War_II or http://en.wikipedia.org/wiki/Category:Sociology_of_World_War_II
What you got was a list of parent categories of Category:World War II. But Category:Military deception during World War II is a *subcategory* of Category:World War II, not a parent category.
If you want to get a list of subcategories, you will need to search for something like page_namespace = 14 AND cl_to = 'World_War_II'.
Petr Onderka [[en:User:Svick]]