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(a)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:Page_restrictions_ta…
+
<https://www.mediawiki.org/**wiki/Manual:Logging_table#log_**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: v <renes@umn.edu>inya002@umn.edu
Office: 3-157 Hanson Hall
Phone: +1 6126257837
Homepage:
www.econ.umn.edu/~vinya002