Stack Exchange Data Explorer
Sep 4 '17 at 15:18
Non-series tags on Anime.SE
SELECT * FROM Tags AS t WHERE (SELECT MIN(ph.CreationDate...
SELECT WikiPostId FROM Tags AS t
SELECT LEN(t.TagName), t.TagName FROM Tags AS t WHERE LEN...
Views on Naruto/etc vs. other questions
Total number of questions asked, including deleted questions
senshin's bounty notices
SELECT v.UserId AS [User Link], SUM(v.BountyAmount) AS [T...
Questions that survived the great [identification-request] cleanup of 2016
SELECT a.Score, a.Id AS [Post Link] FROM Posts AS q INNER...
DECLARE @tag_name nvarchar(max) = 'myself-yourself' DECLA...
Tags created by the great [identification-request] retagging of 2017
SELECT * FROM PostHistory WHERE PostHistoryTypeId IN (3, ...
Questions that were affected by the great [identification-request] retagging of 2017
SELECT TOP 1 * FROM PostHistory AS ph2 WHERE ph2.PostId =...
site design / logo © 2020 Stack Exchange Inc; user contributions licensed under
cc by-sa 4.0