0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT TOP 1000 
    MAX(DisplayName COLLATE DATABASE_DEFAULT) AS DisplayName,
    SUM(UpVotes) + SUM(DownVotes) AS TotalVotes
FROM
    (
        SELECT EmailHash, UpVotes, DownVotes, 'ServerFault.' + DisplayName AS DisplayName FROM [ServerFault.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                                        
        SELECT EmailHash, UpVotes, DownVotes, 'ServerFault.Meta.' + DisplayName AS DisplayName FROM [ServerFault.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                              
        SELECT EmailHash, UpVotes, DownVotes, 'StackApps.' + DisplayName AS DisplayName FROM [StackApps.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                                            
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Android.' + DisplayName AS DisplayName FROM [StackExchange.Android.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                    
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Android.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Android.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL          
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Apple.' + DisplayName AS DisplayName FROM [StackExchange.Apple.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                        
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Apple.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Apple.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL              
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Bicycles.' + DisplayName AS DisplayName FROM [StackExchange.Bicycles.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                  
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Bicycles.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Bicycles.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL        
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Cooking.' + DisplayName AS DisplayName FROM [StackExchange.Cooking.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                    
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Cooking.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Cooking.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL          
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Cstheory.' + DisplayName AS DisplayName FROM [StackExchange.Cstheory.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                  
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Cstheory.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Cstheory.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL        
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Dba.' + DisplayName AS DisplayName FROM [StackExchange.Dba.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                            
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Dba.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Dba.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                  
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Diy.' + DisplayName AS DisplayName FROM [StackExchange.Diy.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                            
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Diy.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Diy.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                  
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Drupal.' + DisplayName AS DisplayName FROM [StackExchange.Drupal.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                      
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Drupal.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Drupal.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL            
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Electronics.' + DisplayName AS DisplayName FROM [StackExchange.Electronics.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL            
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Electronics.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Electronics.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL  
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.English.' + DisplayName AS DisplayName FROM [StackExchange.English.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                    
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.English.Meta.' + DisplayName AS DisplayName FROM [StackExchange.English.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL          
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.GameDev.' + DisplayName AS DisplayName FROM [StackExchange.GameDev.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                    
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.GameDev.Meta.' + DisplayName AS DisplayName FROM [StackExchange.GameDev.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL          
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Gaming.' + DisplayName AS DisplayName FROM [StackExchange.Gaming.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                      
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Gaming.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Gaming.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL            
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Gis.' + DisplayName AS DisplayName FROM [StackExchange.Gis.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                            
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Gis.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Gis.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                  
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Judaism.' + DisplayName AS DisplayName FROM [StackExchange.Judaism.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                    
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Judaism.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Judaism.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL          
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Math.' + DisplayName AS DisplayName FROM [StackExchange.Math.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                          
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Math.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Math.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Photography.' + DisplayName AS DisplayName FROM [StackExchange.Photography.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL            
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Photography.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Photography.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL  
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Physics.' + DisplayName AS DisplayName FROM [StackExchange.Physics.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                    
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Physics.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Physics.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL          
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Programmers.' + DisplayName AS DisplayName FROM [StackExchange.Programmers.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL            
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Programmers.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Programmers.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL  
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Scifi.' + DisplayName AS DisplayName FROM [StackExchange.Scifi.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                        
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Scifi.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Scifi.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL              
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Security.' + DisplayName AS DisplayName FROM [StackExchange.Security.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                  
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Security.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Security.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL        
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Sharepoint.' + DisplayName AS DisplayName FROM [StackExchange.Sharepoint.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL              
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Sharepoint.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Sharepoint.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL    
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Skeptics.' + DisplayName AS DisplayName FROM [StackExchange.Skeptics.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                  
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Skeptics.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Skeptics.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL        
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Stats.' + DisplayName AS DisplayName FROM [StackExchange.Stats.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                        
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Stats.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Stats.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL              
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Tex.' + DisplayName AS DisplayName FROM [StackExchange.Tex.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                            
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Tex.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Tex.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                  
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Ubuntu.' + DisplayName AS DisplayName FROM [StackExchange.Ubuntu.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                      
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Ubuntu.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Ubuntu.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL            
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Ui.' + DisplayName AS DisplayName FROM [StackExchange.Ui.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                              
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Ui.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Ui.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                    
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Unix.' + DisplayName AS DisplayName FROM [StackExchange.Unix.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                          
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Unix.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Unix.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.WebApps.' + DisplayName AS DisplayName FROM [StackExchange.WebApps.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                    
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.WebApps.Meta.' + DisplayName AS DisplayName FROM [StackExchange.WebApps.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL          
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Webmasters.' + DisplayName AS DisplayName FROM [StackExchange.Webmasters.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL              
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Webmasters.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Webmasters.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL    
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Wordpress.' + DisplayName AS DisplayName FROM [StackExchange.Wordpress.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                
        SELECT EmailHash, UpVotes, DownVotes, 'StackExchange.Wordpress.Meta.' + DisplayName AS DisplayName FROM [StackExchange.Wordpress.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL      
        SELECT EmailHash, UpVotes, DownVotes, 'StackOverflow.' + DisplayName AS DisplayName FROM [StackOverflow.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                                    
        SELECT EmailHash, UpVotes, DownVotes, 'StackOverflow.Meta.' + DisplayName AS DisplayName FROM [StackOverflow.Meta.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                          
        SELECT EmailHash, UpVotes, DownVotes, 'SuperUser.' + DisplayName AS DisplayName FROM [SuperUser.Exported]..Users WHERE EmailHash IS NOT NULL UNION ALL                                            
        SELECT EmailHash, UpVotes, DownVotes, 'SuperUser.Meta.' + DisplayName AS DisplayName FROM [SuperUser.Meta.Exported]..Users WHERE EmailHash IS NOT NULL
    ) AS NetworkUsers
GROUP BY EmailHash
ORDER BY TotalVotes DESC

fork query

edited jun 13 12 reemrevnivek

created jun 10 12 Tim Stone