select top 100 p.Id AS [Post Link], p.body, p.score from ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Materials Modeling Meta

Q&A for materials modelers and data scientists

select top 100 p.Id AS [Post Link], p.body, p.score
from posts as p
inner join [users] as u on u.id = p.owneruserid
and u.reputation < 100
and p.score < 0
and p.AcceptedAnswerId IS NULL
and p.closeddate IS NULL
and (p.body LIKE '%whore%'
or p.body LIKE '%shit%'
or p.body LIKE '%fuck%'
or p.body LIKE '%suck%'
or p.body LIKE '%slut%'
or p.body LIKE '%bitch%'
or p.body LIKE '%douche%'
or p.body LIKE '%penis%'
or p.body LIKE '%dick%'
or p.body LIKE '%asshole%')
order by p.score

Enter Parameters

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