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