0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Joomla! administrators, users, developers and designers

--set showplan_all on
--go
SELECT TOP ##NOA## 
    p.Id AS [Post Link],
    p.Body
FROM
    Posts AS p
WHERE
  -- len(body) <= 150 and
   p.Body LIKE '%##keyword##%'  and 
   PostTypeId = 2 
   
ORDER BY p.Id DESC
go

fork query

edited nov 28 anonymous

created aug 29 Shree34257