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

Q&A about the site for information security professionals

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/22/2023' and 
Questions.CreationDate <'05/29/2023'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;*/

fork query

edited jun 5 23 anonymous

created sep 3 20 Omatt