High Rep Users with no logins in the last year or so

1

Please login or register to vote for this query.

(click on this box to dismiss)

Signal Processing Meta

Q&A about the site for practitioners of the art and science of signal, image and video processing

SELECT U.Id as [User Link], COUNT(P.Id) as Post_Count, U.AboutMe, U.Views, U.Reputation, Convert(Char(10), CONVERT(nvarchar(30), LastAccessDate, 126), 101) AS [Last Login], Convert(CHAR(10), CONVERT(nvarchar(30), U.CreationDate, 126), 101) AS [First Login]
FROM Users U, Posts P
WHERE
U.Id = P.OwnerUserId
AND
U.Reputation > 20000
AND
U.DisplayName LIKE '% %'
AND
U.AboutMe != ''
AND
DATEDIFF(month, U.LastAccessDate, GETDATE() ) > 1
AND
DATEDIFF(month, U.LastAccessDate, GETDATE() ) < 16
GROUP BY U.Id, U.AboutMe, U.Views, U.Reputation, U.LastAccessDate, U.CreationDate
HAVING Count(P.Id) > 1000

Enter Parameters

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