Not an answer?

8

Please login or register to vote for this query.

(click on this box to dismiss)

Targetting recent posts (within 30 days) that may not be answers. Marking these as not an answer may help achieve the Marshall badge. This is based on a pre-existing query by p.campbell.

Woodworking

Q&A for professional and amateur woodworkers

-- Not an answer?
-- Targetting recent posts (within 30 days) that may not be answers. Marking these as not an answer may help achieve the Marshall badge. This is based on a pre-existing query by p.campbell.

select p.Id AS [Post Link], p.body, p.creationdate
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 '%thank%' or
     body like '%thx%' or
     body like '%please%' or
     body like '%plz%' or
     body like '%pls%')
order by p.id desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results