Firebase questions with most views

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 5000 Posts.CreationDate, 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 > '2010/01/01'
AND (Tags.TagName = 'progressive-web-apps' OR Tags.TagName = 'pwa')
  AND Posts.CreationDate < '2021-06-01'
ORDER BY Posts.CreationDate DESC;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results