Search code examples
stackexchangeuser-activity

How many accounts does a user have?-StackExchange

I am trying to make a query on stackexchange that would tell me for every user, on which stack community he is present and possibly its reputation on that specific community. It seems there is no indicator in the Sql for this purpose.

Anyone has a solution? Much appreciated! Best from Italy

Solution

  • I do not have a query for every user specifically, by there are a couple existing queries in the Data Explorer than can be used to count the number of accounts that exist across the network:

    • This query generates a list queries to run. This is building a giant query across all sites in the SE network
    • Utilizing the output of the previous point (and skipping the first 4 rows and the last row), we can run the query

    The results of the second query show the number of accounts that exist on multiple sites.

    While it doesn't show the number of accounts for each individual user, it does provide the scope of shared accounts across the network. Querying for each user is probably prohibitively expensive in terms of resources.