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.