EmailHash comparison

0

Please login or register to vote for this query.

(click on this box to dismiss)

This is the output of http://data.stackexchange.com/stackoverflow/query/69700/generate-emailhash-comparison?opt.textResults=true#messages, edited to remove the non-exported or test/temp databases. This latest (December 2012) export includes some EmailHashes that are case sensitive and some that are case insensitive, so I COLLATED all comparisons rather than working out which is which.

Network Engineering

Q&A for network engineers

Select 'ServerFault' As [DatabaseName], Count(*) As [Count] From [ServerFault]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                                          
Select 'ServerFault.Meta' As [DatabaseName], Count(*) As [Count] From [ServerFault.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                                
Select 'StackApps' As [DatabaseName], Count(*) As [Count] From [StackApps]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                                              
Select 'StackExchange.Android' As [DatabaseName], Count(*) As [Count] From [StackExchange.Android]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                      
Select 'StackExchange.Android.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Android.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL            
Select 'StackExchange.Apple' As [DatabaseName], Count(*) As [Count] From [StackExchange.Apple]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                          
Select 'StackExchange.Apple.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Apple.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                
Select 'StackExchange.Bicycles' As [DatabaseName], Count(*) As [Count] From [StackExchange.Bicycles]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                    
Select 'StackExchange.Bicycles.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Bicycles.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL          
Select 'StackExchange.Cooking' As [DatabaseName], Count(*) As [Count] From [StackExchange.Cooking]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                      
Select 'StackExchange.Cooking.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Cooking.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL            
Select 'StackExchange.Cstheory' As [DatabaseName], Count(*) As [Count] From [StackExchange.Cstheory]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                    
Select 'StackExchange.Cstheory.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Cstheory.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL          
Select 'StackExchange.Dba' As [DatabaseName], Count(*) As [Count] From [StackExchange.Dba]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                              
Select 'StackExchange.Dba.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Dba.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                    
Select 'StackExchange.Diy' As [DatabaseName], Count(*) As [Count] From [StackExchange.Diy]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                              
Select 'StackExchange.Diy.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Diy.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                    
Select 'StackExchange.Drupal' As [DatabaseName], Count(*) As [Count] From [StackExchange.Drupal]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                        
Select 'StackExchange.Drupal.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Drupal.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL              
Select 'StackExchange.Electronics' As [DatabaseName], Count(*) As [Count] From [StackExchange.Electronics]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL              
Select 'StackExchange.Electronics.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Electronics.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL    
Select 'StackExchange.English' As [DatabaseName], Count(*) As [Count] From [StackExchange.English]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                      
Select 'StackExchange.English.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.English.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL            
Select 'StackExchange.GameDev' As [DatabaseName], Count(*) As [Count] From [StackExchange.GameDev]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                      
Select 'StackExchange.GameDev.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.GameDev.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL            
Select 'StackExchange.Gaming' As [DatabaseName], Count(*) As [Count] From [StackExchange.Gaming]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                        
Select 'StackExchange.Gaming.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Gaming.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL              
Select 'StackExchange.Gis' As [DatabaseName], Count(*) As [Count] From [StackExchange.Gis]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                              
Select 'StackExchange.Gis.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Gis.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                    
Select 'StackExchange.Judaism' As [DatabaseName], Count(*) As [Count] From [StackExchange.Judaism]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                      
Select 'StackExchange.Judaism.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Judaism.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL            
Select 'StackExchange.Math' As [DatabaseName], Count(*) As [Count] From [StackExchange.Math]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                            
Select 'StackExchange.Math.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Math.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                  
Select 'StackExchange.Mathematica' As [DatabaseName], Count(*) As [Count] From [StackExchange.Mathematica]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL              
Select 'StackExchange.Mathematica.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Mathematica.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL    
Select 'StackExchange.Photography' As [DatabaseName], Count(*) As [Count] From [StackExchange.Photography]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL              
Select 'StackExchange.Photography.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Photography.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL    
Select 'StackExchange.Physics' As [DatabaseName], Count(*) As [Count] From [StackExchange.Physics]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                      
Select 'StackExchange.Physics.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Physics.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL            
Select 'StackExchange.Programmers' As [DatabaseName], Count(*) As [Count] From [StackExchange.Programmers]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL              
Select 'StackExchange.Programmers.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Programmers.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL    
Select 'StackExchange.Rpg' As [DatabaseName], Count(*) As [Count] From [StackExchange.Rpg]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                              
Select 'StackExchange.Rpg.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Rpg.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                    
Select 'StackExchange.Scifi' As [DatabaseName], Count(*) As [Count] From [StackExchange.Scifi]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                          
Select 'StackExchange.Scifi.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Scifi.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                
Select 'StackExchange.Security' As [DatabaseName], Count(*) As [Count] From [StackExchange.Security]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                    
Select 'StackExchange.Security.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Security.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL          
Select 'StackExchange.Sharepoint' As [DatabaseName], Count(*) As [Count] From [StackExchange.Sharepoint]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                
Select 'StackExchange.Sharepoint.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Sharepoint.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL      
Select 'StackExchange.Skeptics' As [DatabaseName], Count(*) As [Count] From [StackExchange.Skeptics]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                    
Select 'StackExchange.Skeptics.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Skeptics.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL          
Select 'StackExchange.Stats' As [DatabaseName], Count(*) As [Count] From [StackExchange.Stats]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                          
Select 'StackExchange.Stats.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Stats.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                
Select 'StackExchange.Tex' As [DatabaseName], Count(*) As [Count] From [StackExchange.Tex]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                              
Select 'StackExchange.Tex.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Tex.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                    
Select 'StackExchange.Ubuntu' As [DatabaseName], Count(*) As [Count] From [StackExchange.Ubuntu]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                        
Select 'StackExchange.Ubuntu.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Ubuntu.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL              
Select 'StackExchange.Unix' As [DatabaseName], Count(*) As [Count] From [StackExchange.Unix]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                            
Select 'StackExchange.Unix.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Unix.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                  
Select 'StackExchange.Ux' As [DatabaseName], Count(*) As [Count] From [StackExchange.Ux]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                                
Select 'StackExchange.Ux.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Ux.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                      
Select 'StackExchange.WebApps' As [DatabaseName], Count(*) As [Count] From [StackExchange.WebApps]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                      
Select 'StackExchange.WebApps.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.WebApps.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL            
Select 'StackExchange.Webmasters' As [DatabaseName], Count(*) As [Count] From [StackExchange.Webmasters]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                
Select 'StackExchange.Webmasters.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Webmasters.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL      
Select 'StackExchange.Wordpress' As [DatabaseName], Count(*) As [Count] From [StackExchange.Wordpress]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                  
Select 'StackExchange.Wordpress.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Wordpress.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL        
Select 'StackOverflow' As [DatabaseName], Count(*) As [Count] From [StackOverflow]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                                      
Select 'StackOverflow.Meta' As [DatabaseName], Count(*) As [Count] From [StackOverflow.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                            
Select 'SuperUser' As [DatabaseName], Count(*) As [Count] From [SuperUser]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS UNION ALL                                              
Select 'SuperUser.Meta' As [DatabaseName], Count(*) As [Count] From [SuperUser.Meta]..Users fu Join Users u ON fu.EmailHash=u.EmailHash COLLATE SQL_Latin1_General_CP1_CI_AS Where ISNULL(u.EmailHash,'')<>'' COLLATE SQL_Latin1_General_CP1_CI_AS 
Order By [Count] Desc, [DatabaseName]

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results