0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

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='google-chrome-extension' and
Questions.CreationDate >='01/01/2021' and 
--Questions.CreationDate <'12/31/2019' and
Questions.PostTypeId=1
--and
--questions.score >=0*/

--select * from CloseReasonTypes;

fork query

edited may 23 anonymous

created dec 25 19 jon.doe32893