Στις 12-01-2013, ημέρα Σαβ, και ώρα 17:00 -0800, ο/η Robert Crowe έγραψε: > Hi Ariel, > > I'm trying to understand the foreign keys. Is the page_props.pp_page column > the key for category.cat_id? Or is it the key for page.page_id where > page_namespace = 14? > > Thanks, > > Robert
pp_page is the page_id of the page which has the particular property set. > SELECT * > > FROM `categorylinks` > > WHERE `cl_to` = 'Humanities' > > > > Yields 9 rows In the original copy of enwiki-20121201-categorylinks.sql.gz I see 96 lines with 'Humanities' for cl_to. Did you try grepping them out and having a look? Ariel _______________________________________________ Xmldatadumps-l mailing list Xmldatadumps-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/xmldatadumps-l