The really old api i was talking about was https://meta.wikimedia.org/wiki/Wikimedia_update_feed_service The "secret" sparql category api (not actually secret) is
