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_page> + <https://www.mediawiki.org/wiki/Manual:Logging_table#log_page> work?

Nemo



--
Xavier Vinyals-Mirabent
-----------------------------------------------------
Mail: 1925, 4th Street South
        4-101 Hanson Hall
        Minneapolis, MN 55455-0462
Email: vinya002@umn.edu 
Office: 3-157 Hanson Hall
Phone: +1 6126257837
Homepage: www.econ.umn.edu/~vinya002