fresh tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフローMeta

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

SELECT DISTINCT A.TagId, A.TagName FROM (SELECT PostTags.PostId, PostTags.TagId, Tags.TagName, Posts.CreationDate
FROM PostTags
JOIN Posts
ON PostTags.PostId = Posts.Id
JOIN Tags
ON PostTags.TagId = Tags.Id
WHERE PostTags.TagId NOT IN (
  SELECT DISTINCT PostTags.TagId AS OlderTags
  FROM PostTags
  JOIN Posts
  ON PostTags.PostId = Posts.Id
  WHERE DATEDIFF(DAY, CreationDate, GETDATE()) > 1)) as A

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results