0

Please login or register to vote for this query.

(click on this box to dismiss)

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

select Answer.Id as [Answer Id], Question.Id as [Question Id], Answer.CreationDate as [Answer Date], Answer.ViewCount as [Answer View Count], Answer.LastActivityDate, 
Question.CreationDate as [Question Date], Question.LastActivityDate, Question.ViewCount as [Question View Count],
Question.Title, Answer.Score as [Answer Score], Question.FavoriteCount,
Question.Tags, Question.AnswerCount, Question.CommentCount,
Question.AcceptedAnswerId, Question.ClosedDate
From 
    Posts Answer
    
  INNER JOIN Posts Question 
    ON Question.Id = Answer.ParentId
    
  INNER JOIN PostTags 
    ON PostTags.PostId = Question.Id
    
  INNER JOIN Tags
    on Tags.Id = PostTags.TagId
    
Where Answer.postTypeId=2 --Answers
    And Question.postTypeId=1 --Questions
    And Answer.OwnerUserId=2497859
    And Tags.TagName='flutter'
Order By Question.CreationDate Desc

fork query

edited feb 2

created jan 25 Omatt38037