Not an answer?

0

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.

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

-- 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 top 100 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())<30
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