El 12/09/13 20:01, Xavier Vinyals Mirabent escribió:
Hi,
Are the values in the columns pr_id and log_id equivalent? I'm trying to select all changes in editing protection status for Wikipedia articles but the table Page_restrictions doesn't contain a time stamp, and the table logging doesn't specify the kind of protection so I'm trying to join them somehow...
Thanks!
Xavi
The table logging does specify the protection applied (for recent protections, time ago it didn't). Look at log_params.