Here's an improved cross-site version.
Performs up to 2 times faster.
Uses newer TSQL features for shorter, easier to understand code.
Gives more natural site names.
Provides https URL's.
Catches the oversight with StackExchange.Audio.Meta.
See the query in SEDE.
Or here's the code:
/*-- INSTRU...
The answer to this question implies that you can write cross-site Data Explorer queries, but the sample query doesn't appear to do what I think it should.
SELECT TOP 1 *
FROM [StackOverflow.Exported]..[Users] u1
INNER JOIN [ServerFault.Exported]..[Users] u2 ON u1.Id = u2.Id
I had assum...
Often you want to query some statistic for a user across all sites. For example, you might write a query to find your rejected suggested edits across all Stack Exchange sites.
To implement this, you would join on the network-wide user ID, across the tables corresponding to all the sites. (Doing ...