0

Please login or register to vote for this query.

(click on this box to dismiss)

Note that it is a time consuming query that can timeout easily

Q&A for pro webmasters

-- Website occurence searching
-- Note that it is a time consuming query that can timeout easily

select top 500
       posts.id as [Post Link], 
       users.id as [User Link],
       users.reputation as [Reputation]
from posts 
    inner join users 
        on posts.owneruserid = users.id
where upper(body) like '%##Website##%'
and users.id = 0
order by [Reputation] asc, [User Link]

fork query

created jul 26 11 Scorpi0