Spam profiles

0

Please login or register to vote for this query.

(click on this box to dismiss)

Searches for user profiles that have no activity but filled in the about me page, usually for spamming a business or other undesirables (but not necessarily yet very likely).

Stack Overflow

Q&A for professional and enthusiast programmers

select
  top ##Top:int?100##
  id as [User Link]
  , datediff(day,creationdate,lastaccessdate) as [Days Active]
  , datediff(month,creationdate,getdate()) as [Months Created]
  , *
from users
where 1=1
and datediff(day,creationdate,lastaccessdate) <= ##ActiveDays:int?7##
and datediff(month,creationdate,getdate()) >= ##CreatedMonthsAgo:int?6##
and (##HasPhone:int?1## = 0 or ' ' + aboutme + ' ' like '%[^0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9][^0-9]%')
and (##HasUrl:int?1## = 0 or aboutme like '%http://%' or aboutme like '%https://%' or websiteurl <> '')
and aboutme <> ''
and not exists (select null from posts where owneruserid = users.id)
order by creationdate asc

-- Top: Max results
-- ActiveDays: Maximum amount of active days since the user was created
-- CreatedMonthsAgo: Minimum months user was created
-- HasPhone: Filter results that contain phone numbers (bool)
-- HasUrl: Filter results that contain urls (bool)

Enter Parameters

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