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 <[email protected]>: > 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, יגאל חיטרון <[email protected]> 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 > > [email protected] > > https://lists.wikimedia.org/mailman/listinfo/wikitech-l > _______________________________________________ > Wikitech-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikitech-l _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
