Flutter Query

0

Please login or register to vote for this query.

(click on this box to dismiss)

Run query at the end of the month to check unanswered Flutter questions. Update Questions.CreationDate

Science Fiction and Fantasy Meta

Q&A about the site for science fiction and fantasy enthusiasts

select Questions.Id, Questions.CreationDate, Questions.LastActivityDate, Questions.ViewCount,
--Questions.Title, Questions.Body,Questions.Score, Questions.FavoriteCount,
Questions.Title, Questions.Score, Questions.FavoriteCount,
Questions.Tags, Questions.AnswerCount, Questions.CommentCount,
Questions.AcceptedAnswerId,Questions.ClosedDate,
Users.Id,Users.DisplayName, Users.Reputation
FROM Posts as Questions 
    INNER JOIN PostTags 
    ON PostTags.PostId = Questions.Id
    
    INNER JOIN Tags
    on Tags.Id = PostTags.TagId
    
    INNER JOIN Users
    on Questions.OwnerUserId = Users.Id

    
Where Tags.TagName='flutter' and
Questions.CreationDate >='05/01/2017' and 
Questions.CreationDate <'05/11/2021'and
Questions.PostTypeId=1 and
questions.score >=0 and
Questions.AnswerCount = 0 and
Questions.ClosedDate IS NULL
ORDER by Questions.ViewCount DESC 
--and
--questions.score >=0

/*select * from CloseReasonTypes;*/

Enter Parameters

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