Hmm, special:Contributions is getting crowded. Perhaps we should add a new special page.

So just to clarify, what is being asked for:

List of pages user (let's call him Bob) has edited, such that someone else has subsequently edited the page, no duplicate pages listed, and ordered by the time when Bob last edited the page.

This almost sounds like it'd fit in better with Special:Recentchanges. (And if we could limit it to the last 3 weeks of changes or whenever RC is limited to, probably the concerns about sql efficiency wouldn't be as much [but it'd still be pretty bad. Is filesorting the RC table considered ok on the likes of enwikipedia?])

I know that the database query won't be easy to construct, but I think it would
be OK not to show exactly 20/50/100/... contributions to have such a essential
feature built into core. So the filtering could also be done in PHP, which
should be quite easy. In future, a better SQL term still can be built.

I don't really like the idea of php side filtering. What if 0 results are shown (even though there are actual results that would match)? That just seems icky.

a.d.bergi wrote:

(In reply to comment #1)

So just to clarify, what is being asked for:

List of pages user (let's call him Bob) has edited, such that someone else has
subsequently edited the page, no duplicate pages listed, and ordered by the
time when Bob last edited the page.

Yes. However, I would put it in another order: List of edits by Bob, ordered by time, only the last of these edits per page, and not those which are "on top".

But I don't know how the "on top" filter is done today, so it might be rather inefficient.

Hmm, special:Contributions is getting crowded. Perhaps we should add a new
special page.

This almost sounds like it'd fit in better with Special:Recentchanges. (And if
we could limit it to the last 3 weeks of changes or whenever RC is limited to,
probably the concerns about sql efficiency wouldn't be as much)

Yeah, you're right. A Special:RecentchangesLinkedtoContributions would fit the need better. Do you think a page would be possible, which lists the recentchanges of pages User:Bob has edited in the last X days? Optionally filterable not to show Bobs (or my?) own edits, and also not to show edits which are older than Bobs last edit per page?
I think that would be perfect, just like a Special:NewMessages without LT :-)