0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for artists and crafters

set showplan_all on
go
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
ORDER BY p.Id DESC
go

fork query

edited nov 28 anonymous

created aug 29 Shree34257