Which Stack Exchange users have the most accounts with over 200 reputation all across the SE network

2

Please login or register to vote for this query.

(click on this box to dismiss)

Uses the output of http://data.stackexchange.com/stackoverflow/query/168065/generate-inner-select-for-all-users-with-rep200?opt.textResults=true

Emacs

Q&A for those using, extending or developing Emacs

Select Count(Distinct DisplayName) As [Names], Max(DisplayName) As [Name], (Case When Count(Distinct DisplayName) > 1 Then Min(DisplayName) Else NULL End) As [Alt], Count(*) As [Sites], Min(CreationDate) As [FirstSeen]
from (
Select 'ServerFault' As [DatabaseName], AccountId, DisplayName, CreationDate From [ServerFault]..Users fu WHERE fu.Reputation>200 UNION ALL                                            
Select 'StackApps' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackApps]..Users fu WHERE fu.Reputation>200 UNION ALL                                                
Select 'StackExchange.3dprinting' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.3dprinting]..Users fu WHERE fu.Reputation>200 UNION ALL                  
Select 'StackExchange.Academia' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Academia]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Ai' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Ai]..Users fu WHERE fu.Reputation>200 UNION ALL                                  
Select 'StackExchange.Android' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Android]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Anime' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Anime]..Users fu WHERE fu.Reputation>200 UNION ALL                            
Select 'StackExchange.Apple' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Apple]..Users fu WHERE fu.Reputation>200 UNION ALL                            
Select 'StackExchange.Arabic' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Arabic]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Arduino' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Arduino]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Astronomy' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Astronomy]..Users fu WHERE fu.Reputation>200 UNION ALL                    
Select 'StackExchange.Audio' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Audio]..Users fu WHERE fu.Reputation>200 UNION ALL                            
Select 'StackExchange.Aviation' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Aviation]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Beer' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Beer]..Users fu WHERE fu.Reputation>200 UNION ALL                              
Select 'StackExchange.Bicycles' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Bicycles]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Biology' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Biology]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Bitcoin' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Bitcoin]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Blender' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Blender]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Boardgames' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Boardgames]..Users fu WHERE fu.Reputation>200 UNION ALL                  
Select 'StackExchange.Bricks' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Bricks]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Buddhism' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Buddhism]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Chemistry' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Chemistry]..Users fu WHERE fu.Reputation>200 UNION ALL                    
Select 'StackExchange.Chess' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Chess]..Users fu WHERE fu.Reputation>200 UNION ALL                            
Select 'StackExchange.Chinese' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Chinese]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Christianity' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Christianity]..Users fu WHERE fu.Reputation>200 UNION ALL              
Select 'StackExchange.Civicrm' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Civicrm]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Codegolf' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Codegolf]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Codereview' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Codereview]..Users fu WHERE fu.Reputation>200 UNION ALL                  
Select 'StackExchange.Coffee' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Coffee]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Cogsci' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Cogsci]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Computergraphics' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Computergraphics]..Users fu WHERE fu.Reputation>200 UNION ALL      
Select 'StackExchange.Cooking' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Cooking]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Craftcms' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Craftcms]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Crafts' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Crafts]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Crypto' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Crypto]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Cs' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Cs]..Users fu WHERE fu.Reputation>200 UNION ALL                                  
Select 'StackExchange.Cstheory' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Cstheory]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Datascience' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Datascience]..Users fu WHERE fu.Reputation>200 UNION ALL                
Select 'StackExchange.Dba' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Dba]..Users fu WHERE fu.Reputation>200 UNION ALL                                
Select 'StackExchange.Diy' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Diy]..Users fu WHERE fu.Reputation>200 UNION ALL                                
Select 'StackExchange.Drupal' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Drupal]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Dsp' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Dsp]..Users fu WHERE fu.Reputation>200 UNION ALL                                
Select 'StackExchange.Earthscience' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Earthscience]..Users fu WHERE fu.Reputation>200 UNION ALL              
Select 'StackExchange.Ebooks' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Ebooks]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Economics' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Economics]..Users fu WHERE fu.Reputation>200 UNION ALL                    
Select 'StackExchange.Electronics' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Electronics]..Users fu WHERE fu.Reputation>200 UNION ALL                
Select 'StackExchange.Elementaryos' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Elementaryos]..Users fu WHERE fu.Reputation>200 UNION ALL              
Select 'StackExchange.Ell' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Ell]..Users fu WHERE fu.Reputation>200 UNION ALL                                
Select 'StackExchange.Emacs' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Emacs]..Users fu WHERE fu.Reputation>200 UNION ALL                            
Select 'StackExchange.Engineering' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Engineering]..Users fu WHERE fu.Reputation>200 UNION ALL                
Select 'StackExchange.English' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.English]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Ethereum' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Ethereum]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Expatriates' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Expatriates]..Users fu WHERE fu.Reputation>200 UNION ALL                
Select 'StackExchange.Expressionengine' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Expressionengine]..Users fu WHERE fu.Reputation>200 UNION ALL      
Select 'StackExchange.Fitness' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Fitness]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Freelancing' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Freelancing]..Users fu WHERE fu.Reputation>200 UNION ALL                
Select 'StackExchange.French' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.French]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.GameDev' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.GameDev]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Gaming' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Gaming]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Garage' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Garage]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Gardening' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Gardening]..Users fu WHERE fu.Reputation>200 UNION ALL                    
Select 'StackExchange.Genealogy' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Genealogy]..Users fu WHERE fu.Reputation>200 UNION ALL                    
Select 'StackExchange.German' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.German]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Gis' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Gis]..Users fu WHERE fu.Reputation>200 UNION ALL                                
Select 'StackExchange.Graphicdesign' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Graphicdesign]..Users fu WHERE fu.Reputation>200 UNION ALL            
Select 'StackExchange.Ham' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Ham]..Users fu WHERE fu.Reputation>200 UNION ALL                                
Select 'StackExchange.Hardwarerecs' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Hardwarerecs]..Users fu WHERE fu.Reputation>200 UNION ALL              
Select 'StackExchange.Health' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Health]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Hermeneutics' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Hermeneutics]..Users fu WHERE fu.Reputation>200 UNION ALL              
Select 'StackExchange.Hinduism' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Hinduism]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.History' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.History]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Homebrew' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Homebrew]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Hsm' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Hsm]..Users fu WHERE fu.Reputation>200 UNION ALL                                
Select 'StackExchange.Islam' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Islam]..Users fu WHERE fu.Reputation>200 UNION ALL                            
Select 'StackExchange.Italian' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Italian]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Japanese' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Japanese]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Joomla' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Joomla]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Judaism' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Judaism]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Korean' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Korean]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Languagelearning' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Languagelearning]..Users fu WHERE fu.Reputation>200 UNION ALL      
Select 'StackExchange.Latin' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Latin]..Users fu WHERE fu.Reputation>200 UNION ALL                            
Select 'StackExchange.Law' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Law]..Users fu WHERE fu.Reputation>200 UNION ALL                                
Select 'StackExchange.Lifehacks' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Lifehacks]..Users fu WHERE fu.Reputation>200 UNION ALL                    
Select 'StackExchange.Linguistics' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Linguistics]..Users fu WHERE fu.Reputation>200 UNION ALL                
Select 'StackExchange.Magento' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Magento]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Martialarts' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Martialarts]..Users fu WHERE fu.Reputation>200 UNION ALL                
Select 'StackExchange.Math' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Math]..Users fu WHERE fu.Reputation>200 UNION ALL                              
Select 'StackExchange.Matheducators' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Matheducators]..Users fu WHERE fu.Reputation>200 UNION ALL            
Select 'StackExchange.Mathematica' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Mathematica]..Users fu WHERE fu.Reputation>200 UNION ALL                
Select 'StackExchange.Mathoverflow' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Mathoverflow]..Users fu WHERE fu.Reputation>200 UNION ALL              
Select 'StackExchange.Meta' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Meta]..Users fu WHERE fu.Reputation>200 UNION ALL                              
Select 'StackExchange.Moderators' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Moderators]..Users fu WHERE fu.Reputation>200 UNION ALL                  
Select 'StackExchange.Monero' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Monero]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Money' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Money]..Users fu WHERE fu.Reputation>200 UNION ALL                            
Select 'StackExchange.Movies' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Movies]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Music' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Music]..Users fu WHERE fu.Reputation>200 UNION ALL                            
Select 'StackExchange.Musicfans' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Musicfans]..Users fu WHERE fu.Reputation>200 UNION ALL                    
Select 'StackExchange.Mythology' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Mythology]..Users fu WHERE fu.Reputation>200 UNION ALL                    
Select 'StackExchange.Networkengineering' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Networkengineering]..Users fu WHERE fu.Reputation>200 UNION ALL  
Select 'StackExchange.Opendata' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Opendata]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Opensource' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Opensource]..Users fu WHERE fu.Reputation>200 UNION ALL                  
Select 'StackExchange.Outdoors' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Outdoors]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Parenting' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Parenting]..Users fu WHERE fu.Reputation>200 UNION ALL                    
Select 'StackExchange.Patents' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Patents]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Pets' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Pets]..Users fu WHERE fu.Reputation>200 UNION ALL                              
Select 'StackExchange.Philosophy' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Philosophy]..Users fu WHERE fu.Reputation>200 UNION ALL                  
Select 'StackExchange.Photography' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Photography]..Users fu WHERE fu.Reputation>200 UNION ALL                
Select 'StackExchange.Physics' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Physics]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Pm' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Pm]..Users fu WHERE fu.Reputation>200 UNION ALL                                  
Select 'StackExchange.Poker' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Poker]..Users fu WHERE fu.Reputation>200 UNION ALL                            
Select 'StackExchange.Politics' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Politics]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Portuguese' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Portuguese]..Users fu WHERE fu.Reputation>200 UNION ALL                  
Select 'StackExchange.Productivity' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Productivity]..Users fu WHERE fu.Reputation>200 UNION ALL              
Select 'StackExchange.Programmers' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Programmers]..Users fu WHERE fu.Reputation>200 UNION ALL                
Select 'StackExchange.Puzzling' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Puzzling]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Quant' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Quant]..Users fu WHERE fu.Reputation>200 UNION ALL                            
Select 'StackExchange.Raspberrypi' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Raspberrypi]..Users fu WHERE fu.Reputation>200 UNION ALL                
Select 'StackExchange.Retrocomputing' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Retrocomputing]..Users fu WHERE fu.Reputation>200 UNION ALL          
Select 'StackExchange.Reverseengineering' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Reverseengineering]..Users fu WHERE fu.Reputation>200 UNION ALL  
Select 'StackExchange.Robotics' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Robotics]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Rpg' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Rpg]..Users fu WHERE fu.Reputation>200 UNION ALL                                
Select 'StackExchange.Rus' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Rus]..Users fu WHERE fu.Reputation>200 UNION ALL                                
Select 'StackExchange.Russian' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Russian]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Salesforce' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Salesforce]..Users fu WHERE fu.Reputation>200 UNION ALL                  
Select 'StackExchange.Scicomp' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Scicomp]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Scifi' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Scifi]..Users fu WHERE fu.Reputation>200 UNION ALL                            
Select 'StackExchange.Security' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Security]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Sharepoint' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Sharepoint]..Users fu WHERE fu.Reputation>200 UNION ALL                  
Select 'StackExchange.Skeptics' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Skeptics]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Softwarerecs' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Softwarerecs]..Users fu WHERE fu.Reputation>200 UNION ALL              
Select 'StackExchange.Sound' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Sound]..Users fu WHERE fu.Reputation>200 UNION ALL                            
Select 'StackExchange.Space' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Space]..Users fu WHERE fu.Reputation>200 UNION ALL                            
Select 'StackExchange.Spanish' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Spanish]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Sports' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Sports]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Sqa' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Sqa]..Users fu WHERE fu.Reputation>200 UNION ALL                                
Select 'StackExchange.Startups' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Startups]..Users fu WHERE fu.Reputation>200 UNION ALL                      
Select 'StackExchange.Stats' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Stats]..Users fu WHERE fu.Reputation>200 UNION ALL                            
Select 'StackExchange.Sustainability' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Sustainability]..Users fu WHERE fu.Reputation>200 UNION ALL          
Select 'StackExchange.Tex' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Tex]..Users fu WHERE fu.Reputation>200 UNION ALL                                
Select 'StackExchange.Tor' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Tor]..Users fu WHERE fu.Reputation>200 UNION ALL                                
Select 'StackExchange.Travel' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Travel]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Tridion' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Tridion]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Ubuntu' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Ubuntu]..Users fu WHERE fu.Reputation>200 UNION ALL                          
Select 'StackExchange.Unix' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Unix]..Users fu WHERE fu.Reputation>200 UNION ALL                              
Select 'StackExchange.Ux' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Ux]..Users fu WHERE fu.Reputation>200 UNION ALL                                  
Select 'StackExchange.Vi' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Vi]..Users fu WHERE fu.Reputation>200 UNION ALL                                  
Select 'StackExchange.WebApps' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.WebApps]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackExchange.Webmasters' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Webmasters]..Users fu WHERE fu.Reputation>200 UNION ALL                  
Select 'StackExchange.Windowsphone' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Windowsphone]..Users fu WHERE fu.Reputation>200 UNION ALL              
Select 'StackExchange.Woodworking' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Woodworking]..Users fu WHERE fu.Reputation>200 UNION ALL                
Select 'StackExchange.Wordpress' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Wordpress]..Users fu WHERE fu.Reputation>200 UNION ALL                    
Select 'StackExchange.Workplace' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Workplace]..Users fu WHERE fu.Reputation>200 UNION ALL                    
Select 'StackExchange.Worldbuilding' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Worldbuilding]..Users fu WHERE fu.Reputation>200 UNION ALL            
Select 'StackExchange.Writers' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackExchange.Writers]..Users fu WHERE fu.Reputation>200 UNION ALL                        
Select 'StackOverflow' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackOverflow]..Users fu WHERE fu.Reputation>200 UNION ALL                                        
Select 'StackOverflow.Br' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackOverflow.Br]..Users fu WHERE fu.Reputation>200 UNION ALL                                  
Select 'StackOverflow.Es' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackOverflow.Es]..Users fu WHERE fu.Reputation>200 UNION ALL                                  
Select 'StackOverflow.Ja' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackOverflow.Ja]..Users fu WHERE fu.Reputation>200 UNION ALL                                  
Select 'StackOverflow.Ru' As [DatabaseName], AccountId, DisplayName, CreationDate From [StackOverflow.Ru]..Users fu WHERE fu.Reputation>200 UNION ALL                                  
Select 'SuperUser' As [DatabaseName], AccountId, DisplayName, CreationDate From [SuperUser]..Users fu WHERE fu.Reputation>200
) AlmostAllUsers
Group By AccountId -- having Count(*)<>Count(Distinct [DatabaseName])
Order By 4 Desc, 5 Desc

Enter Parameters

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