Автор ответа на свой вопрос, если ответ получит больший рейтинг ...


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT p.OwnerUserId, p.Id, parent.Title, p.Score
From Posts p 
  Join Posts parent on parent.Id = p.ParentId 
  Join PostTags t on t.PostId = parent.Id 
Where t.TagId = 38 AND p.PostTypeId = 2 AND p.OwnerUserId = parent.OwnerUserId AND p.CreationDate >= '2016-01-01' AND p.CreationDate < '2016-01-11' 
ORDER BY p.Score desc;

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results