0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

SELECT TOP ##NOA## 
    p.Id AS [Post Link],
    p.Body
FROM
    Posts AS p
WHERE
   p.Body LIKE '%##keyword##%'  and 
   PostTypeId = 2 and 
   len(body) <= 150
   AND p.Id > (SELECT max(p2.Id)-1000000 FROM Posts p2)
ORDER BY p.Id DESC

fork query

edited nov 28 anonymous

created aug 29 Shree34257