Find questions awaiting answers and with specific text

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
    q.score as [Score],
    q.id as [Post Link],
    q.creationdate as [Created],
    q.lastactivitydate as [Last Active],
    u.displayname as [User],
    u.reputation as [Reputation],
    q.title as [Title]
FROM posts q
  JOIN users u on u.id = q.OwnerUserId
WHERE q.posttypeid = 1 -- Questions
  AND q.answercount = 0 
  AND q.score >= ##MinScore:int##
  AND q.closeddate is null
  AND q.lastactivitydate > '##LastActivityDateYYYYMMDD##'
  AND q.body LIKE '%##SpecifiedText##%'
ORDER BY q.score desc

Enter Parameters

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