Find questions contain tag "polls"

0

Please login or register to vote for this query.

(click on this box to dismiss)

SET @TargTags = LTRIM (RTRIM (@TargTags) );

Craft CMS Meta

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

SELECT  TOP 10
    Q.Id            
  , Q.Tags
  , Q.Score
  , Q.Title
  ,  CONVERT (VARCHAR(10), Q.Creationdate, 112)  AS [Date Asked]
  , Q.AnswerCount   AS [Num Answers]

FROM        Posts AS Q
WHERE       Q.PostTypeId = 1 -- Question
AND         Q.ClosedDate IS NULL
AND         Q.Tags like '%<Mass-Effect-3>%'
AND         Len(Q.body)>5
AND         Q.AnswerCount>5
ORDER BY    Q.AnswerCount DESC

Enter Parameters

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