Thank you very much. Unfortunately, it does not help. Most of the edits are not on pages, that were inserted into category, but on templates, and it takes time to update, so timestamps do not fit. And anywhere, if some page was added to category, and now it's not there, it would not help. Thanks again. Igal
2018-07-17 6:50 GMT+03:00 Strainu strainu10@gmail.com:
Hi,
What I would do is is use the categorylinks table [1] to extract a timestamp that can then be used to search for a particular revision. Filtering by user ID is then trivial.
Strainu
[1] https://m.mediawiki.org/wiki/Special:MyLanguage/Manual:categorylinks_table
Pe vineri, 13 iulie 2018, יגאל חיטרון khitron@post.bgu.ac.il a scris:
Hi. Is there a way to get caterization edits data from more than month
ago?
I found the last month in recentchanges SQL table, but that's all. I need to find pages that were added by specific user to specific category, doesn't matter when. Thank you. Igal (User:IKhitron) _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l