0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

SELECT TOP 200 ViewCount, Posts.Id AS [Post Link], Tags, Title, AnswerCount, CreationDate
FROM Posts 
INNER JOIN PostTags ON PostTags.PostId = Posts.Id
INNER JOIN Tags ON PostTags.TagId = Tags.Id
WHERE CreationDate > DATEADD(year, -1, GETDATE()) /* '2010/01/01' */
  AND Tags.TagName like 'firebase%'
ORDER BY ViewCount DESC;

fork query

edited nov 9 anonymous

created oct 18 Frank van Puffelen