Exact term search

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

SELECT   p.id                     AS [Post Link], 
         p.creationdate 
FROM     posts p 
JOIN     posts a ON a.parentid = p.id
WHERE    (p.body LIKE '%##keyword1##%' OR p.title LIKE '%##keyword1##%')
AND      p.acceptedanswerid IS NULL
AND      p.closeddate IS NULL
GROUP BY p.id,p.creationdate,p.acceptedanswerid,p.closeddate
HAVING max(p.score) <= 0
ORDER BY creationdate ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results