Profile spammers Stack apps per year

0

Please login or register to vote for this query.

(click on this box to dismiss)

User Experience Meta

Q&A about the site for user experience researchers and experts

select accountid 
into #users
from users
where reputation = 1
and creationdate between '##year##-01-01' and  '##year##-12-31 23:59:59'
AND datediff(hour, Creationdate, Lastaccessdate) < 504
and len(aboutme) > 0
and users.accountid not in (7585603)
and not exists(select 1 from posts where owneruserid = users.id)
and not exists(select 1 from badges where userid = users.id and name <> 'Autobiographer')
and not exists(select 1 from votes where userid = users.id)

create index #idx_users on #users(accountid);

select *
from dbo.sede_users su
inner join #users u on u.accountid = su.account_id
where su.reputation = 1 and question_count = 0 and answer_count = 0

Enter Parameters

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