Django VS Rails - Total Posts by MONTH and YEAR


Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

Select Tags.TagName, YEAR(Posts.CreationDate) as [YearDate], MONTH(Posts.CreationDate) as [MonthDate], Count(Posts.Id) as [TotalPosts]
FROM Tags 
  JOIN PostTags ON PostTags.TagId = Tags.Id
  JOIN Posts ON PostTags.PostId = Posts.Id
WHERE Tags.TagName = 'django' OR Tags.TagName = 'ruby-on-rails'
GROUP BY Tags.TagName, YEAR(Posts.CreationDate), MONTH(Posts.CreationDate)
ORDER BY YEAR(Posts.CreationDate) DESC, MONTH(Posts.CreationDate) DESC, Tags.TagName DESC

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results