That sounds like a database query that should be possible. I'm not familiar enough with the syntax to write such a query myself, but if no one else on this list offers a suggestion, then I suggest you ask on the Research mailing list or in the #wikimedia-research channel on Freenode IRC.

Good luck,