column_A

0

Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga

Q&A for anime and manga fans

DECLARE @TagId int = (
SELECT
  t.Id
FROM Tags t
WHERE t.TagName IN ('async-profiler') -- change tag here
)
SELECT
  CONCAT('site://q/', p.Id, '|', p.Title) AS [PostLink],
  p.CreationDate, p.Score, p.Tags, p.Body, c.Text, c.Score as [CommentScore]
FROM Posts p
LEFT JOIN Comments c ON c.PostID = p.Id
LEFT JOIN PostTags pt ON pt.PostId = p.Id
WHERE pt.TagId = @TagId
  and p.CreationDate > '2016-01-01'
  --and p.ParentId is null
  --and p.AcceptedAnswerId is not NULL
  --and p.Score > 0
  --and c.Score > 0
ORDER BY p.CreationDate DESC, c.Score DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results