PHP_questions

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 = 'java' -- change tag here
)
SELECT
  CONCAT('site://q/', p.Id, '|', p.Title) AS [PostLink],
  p.CreationDate, p.Score, p.Tags, p.Body
FROM Posts p
LEFT JOIN PostTags pt ON pt.PostId = p.Id
WHERE pt.TagId = @TagId
  and p.CreationDate > '2018-12-31' and p.CreationDate < '2020-01-01'
ORDER BY p.CreationDate DESC

Enter Parameters

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