I was curious about finding users that have higher reputation on SE sites other than stackoverflow.

I'm kind of fuzzy on what I want to do, but my hypothesis is that ... people who are involved in SE but not very involved in SO are rare.

So anyway, I went to https://data.stackexchange.com/stackoverflow/query/new and immediately realized that I need to limit my query to a single site.


a) Is it possible to query multiple sites in some way that I've overlooked? b) If not, is this feature planned? c) If not, then out of interest, what is missing for it to be implemented?


  • 1
    This might point you in the right direction: Directly support cross-site queries in the Data Explorer. Also, Allow cross-site queries in data explorer. Apr 24 '17 at 16:02
  • Plenty of examples of the cursor technique; e.g. meta.stackexchange.com/a/293300/230261. Also if you want to query from specific databases see examples at meta.stackexchange.com/a/293027/230261 (and the comments under there have links to other automatic cross-site techniques).
    – Jason C
    Apr 24 '17 at 17:01
  • Btw as for your b/c) -- not sure what you mean. Every site has its own database, so you have to use standard cross-database techniques to query from more than one db at a time. So I guess what's missing is uh... a complete redesign of MS SQL Server, a reimagination of the concept of databases as distinct sources of data, and the subsequent general paradigm shift across the entire world of SQL and database design. Either that or SE merely has to redo the fundamental database layout for the whole network and combine every site into one, single, giant database. Either way, shouldn't be too hard.
    – Jason C
    Apr 24 '17 at 17:05
  • The linked question has exactly what I meant. Thanks. Apr 25 '17 at 15:15

Browse other questions tagged .