Oldest Tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bitcoin

Q&A for Bitcoin crypto-currency enthusiasts

SELECT TOP (100)
  s.value Tag,
  CreationDate = MIN(p.CreationDate),
  HasNonDeleted = CAST(COUNT(*) - COUNT(p.DeletionDate) AS bit)
FROM (
    SELECT TOP (1000)  -- limit non-grouped tags for efficiency
      p.CreationDate,
      p.DeletionDate,
      p.Tags
    FROM PostsWithDeleted p
    WHERE p.PostTypeId = 1  -- question
    ORDER BY
      p.CreationDate
) p
CROSS APPLY STRING_SPLIT(REPLACE(TRIM('<>' FROM p.Tags), '><', '|'), '|') s
GROUP BY
  s.value
ORDER BY
  MIN(p.CreationDate);

Enter Parameters

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