Users who've never interacted with the site and have only ever logged on once.


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select count(*)
  from Users u
  left outer join Posts p
    on u.Id = p.OwnerUserId
 where DATEDIFF(day, u.CreationDate, u.LastAccessDate) <= 1
   and LastAccessDate < GETDATE() - 365
   and upvotes = 0
   and downvotes = 0
   and p.Id is null
   and Reputation = 1
   and ( len(ltrim(AboutMe)) > 0
        or len(ltrim(WebsiteUrl)) > 0

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results