0

Please login or register to vote for this query.

(click on this box to dismiss)

Helps identify H&R's, possibly spammers?

Q&A for SharePoint enthusiasts

-- What users have visited asking or answering only once posting links?
-- Helps identify H&R's, possibly spammers?

SELECT TOP 2500
    OwnerUserId AS [User Link],
    Score,
    Id AS [Post Link]
FROM
    Posts
WHERE
    OwnerUserId IN (SELECT OwnerUserId
                    FROM Posts
                    GROUP BY OwnerUserId
                    HAVING COUNT(*) = 1)
AND
    PostTypeId = 2
AND
    Score <= 0
AND
    Body LIKE '%http%'
ORDER BY
    Score ASC

fork query

created jun 2 11 Jeff Mercado