Seek and Destroy: Spam Users who are Spamming Urls

2

Please login or register to vote for this query.

(click on this box to dismiss)

Original query : http://data.stackexchange.com/stackoverflow/s/1638/seek-and-destroy-spam-spam-urls-spam-baked-beans-and-spam Here is a version with the Url displayed, filter on the reputation users

Amateur Radio

Q&A for amateur radio enthusiasts

select top 100 SUBSTRING
    (  
      posts.body, 
      CHARINDEX('HTTP://', UPPER(posts.body)) + 7, 
      len(posts.body)
    ) as urlBody
  , posts.id as pid
  , users.id as uid
from posts 
    inner join users 
        on posts.owneruserid = users.id
where UPPER(posts.body) like '%HTTP://%' -- that contain a URL
and users.reputation < 1000 -- skip high reputation users

Enter Parameters

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