most reputation with no views in a site

1

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

DECLARE @sql NVARCHAR(MAX) ='
SELECT u1.reputation, ''https://' + ##site1:string## + '.stackexchange.com/u/''
  + CAST(u1.Id AS NVARCHAR) + ''|'' + u1.DisplayName AS ''User''
  
   FROM [StackExchange.' + ##site1:string## + '].dbo.Users AS u1
   
  where (u1.Views = 0)
  ORDER BY u1.Reputation DESC
  
  ';
EXEC(@sql);

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results