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

Constructed Languages Meta

Q&A about the site for designers and users of artificial or invented languages, consciously developed instead of having developed naturally

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