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

Internet of Things Meta

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

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 >='01/01/2022' and 
Questions.CreationDate <'01/15/2022'and
Questions.PostTypeId=1 and
questions.score >=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