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.

Q&A for linguists, teachers, students and Spanish language enthusiasts in general wanting to discuss the finer points of the language

-- 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())<210
    and datediff(dd,p.creationdate, getdate())>180
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

fork query

created dec 7 11 jonegerton