SELECT COUNT(*) from Posts P LEFT OUTER JOIN PostTags PT ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans

Q&A for music historians, critics, and fans

SELECT COUNT(*) from Posts P
LEFT OUTER JOIN PostTags PT on PT.PostId = P.Id
LEFT OUTER JOIN Tags T on T.Id = P.Id
WHERE T.TagName LIKE '%backbone%'

SELECT COUNT(*) from Posts P
WHERE P.Id IN (
  SELECT PostId from PostTags 
  WHERE PostTags.TagId = (
     SELECT TOP(1) Id From Tags where TagName = 'backbone.js'
  )
)

SELECT COUNT(*) from Posts P
WHERE P.Id IN (
  SELECT PostId from PostTags 
  WHERE PostTags.TagId = (
     SELECT TOP(1) Id From Tags where TagName = 'backbone.js'
  )
) AND P.AcceptedAnswerId IS NOT NULL

SELECT SUM(P.AnswerCount) from Posts P
WHERE P.Id IN (
  SELECT PostId from PostTags 
  WHERE PostTags.TagId = (
     SELECT TOP(1) Id From Tags where TagName = 'backbone.js'
  )
)

Enter Parameters

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