Στις 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