I'd like to merge those by edit, not by page. Also, it looks like pr_page only contains those currently protected, I'd like to have all protection status changes, which may include pages not currently protected.
2013/9/12 Federico Leva (Nemo) nemowiki@gmail.com
Xavier Vinyals Mirabent, 12/09/2013 20:01:
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...
Why doesn't <https://www.mediawiki.org/**wiki/Manual:Page_restrictions_** table#pr_pagehttps://www.mediawiki.org/wiki/Manual:Page_restrictions_table#pr_page>
- <https://www.mediawiki.org/**wiki/Manual:Logging_table#log_**pagehttps://www.mediawiki.org/wiki/Manual:Logging_table#log_page>
work?
Nemo