0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

select p.Id AS [Post Link], p.body, p.creationdate, p.closedDate
from 
[users] as u
inner join posts as p 
    on u.id = p.owneruserid and u.reputation < 200
    and posttypeid = 2
    and len(p.body)<200 
    and p.score < 1
    and datediff(dd,p.creationdate, getdate())<60
where 
    (body like '%how can%' or
     body like '%same problem%' or
     body like '%same issue%' or
     body like '%thank%' or
     body like '%thx%' or
     body like '%please%' or
     body like '%plz%' or
     body like '%pls%')
order by p.id desc

fork query

edited jun 4 12

created jun 4 12 anonymous