Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

5 views

Viewing all User

apr 7
6 views

Viewing all User

apr 7
5 views

Viewing all User

apr 7
7 views

SELECT * FROM Badges

apr 7
6 views

Viewing all User

apr 7
7 views

select * from Posts where PostTypeId=1 and OwnerUserId=10...

apr 7
8 views

select * from Comments c where c.PostId in (select Id fro...

apr 7
8 views

SELECT Id,DisplayName,Reputation FROM Users WHERE Reputat...

apr 7
9 views

SELECT TOP 20 * FROM tags ORDER BY COUNT DESC;

apr 7
9 views

select distinct top 50000 p.id, p.title, p.body, a.body a...

apr 7
9 views

SELECT TOP 10 * FROM tags ORDER BY COUNT DESC;

apr 7
9 views

SELECT TOP 10 * FROM tags ORDER BY COUNT DESC;

apr 7
9 views

select distinct top 50000 p.id, p.title, p.body, a.body a...

apr 7
9 views

select distinct top 50000 p.id, p.title, p.body, a.body a...

apr 7
9 views

SELECT Id,DisplayName,Reputation FROM Users WHERE Reputat...

apr 7
11 views

SELECT TOP 1 u.DisplayName,u.Reputation AS Reputation, u...

apr 7
12 views

declare @limit int = ##Limit##; declare @tag_id int = (s...

apr 7
11 views

SELECT TOP 1 u.DisplayName,u.Reputation AS Reputation, u...

apr 7
11 views

SELECT TOP 1 u.DisplayName,u.Reputation AS Reputation, u...

apr 7
11 views

SELECT TOP 1 u.DisplayName,u.Reputation AS Reputation, u...

apr 7
11 views

SELECT TOP 1 u.DisplayName,u.Reputation AS Reputation, u...

apr 7
11 views

SELECT TOP 1 u.DisplayName,u.Reputation AS Reputation, u...

apr 7
11 views

SELECT TOP 1 u.DisplayName,u.Reputation AS Reputation, u...

apr 7
10 views

SELECT TOP 1 u.DisplayName,u.Reputation AS Reputation, u...

apr 7
10 views

SELECT TOP 1 u.DisplayName,u.Reputation AS Reputation, u...

apr 7
11 views

SELECT TOP 1 u.DisplayName,COUNT(b.Name) TotalNumberOfBad...

apr 7
10 views

SELECT * FROM Badges b JOIN Users u ON u.Id = b.UserId WH...

apr 7
12 views

SELECT TOP 1 u.DisplayName,u.Reputation AS Reputation, u...

apr 7
12 views

SELECT TOP 1 u.DisplayName,u.Reputation AS Reputation, u...

apr 7
12 views

SELECT TOP 1 u.DisplayName,u.Reputation AS Reputation, C...

apr 7
12 views

SELECT u.DisplayName,u.Reputation AS Reputation, COUNT(b...

apr 7
12 views

SELECT u.DisplayName,u.Reputation AS Reputation, COUNT(b...

apr 7
12 views

SELECT u.DisplayName,u.Reputation AS Reputation,MAX(b.Na...

apr 7
12 views

SELECT u.DisplayName,u.Reputation AS Reputation, MAX(b.N...

apr 7
12 views

SELECT u.DisplayName,u.Reputation AS Reputation, COUNT(b...

apr 7
12 views

SELECT Id, CreationDate, Tags FROM posts WHERE PostTypeId...

apr 7
11 views

SELECT u.DisplayName,u.Reputation AS Reputation, COUNT(b...

apr 7
11 views

SELECT u.DisplayName,u.Reputation AS Reputation, COUNT(b...

apr 7
12 views

SELECT * FROM Badges

apr 7
12 views

SELECT u.DisplayName, COUNT(b.Name) TotalNumberOfBadges ...

apr 7
12 views

SELECT u.DisplayName, COUNT(b.Name) TotalNumberOfBadges ...

apr 7
12 views

SELECT * FROM Badges b JOIN Users u ON u.Id = b.UserId WH...

apr 7
12 views

SELECT Max(reputation) FROM Badges b JOIN Users u ON u.Id...

apr 7
12 views

SELECT * FROM Badges b JOIN Users u ON u.Id = b.UserId WH...

apr 7
11 views

SELECT u.DisplayName FROM Badges b JOIN Users u ON u.Id ...

apr 7
11 views

SELECT Max(reputation) FROM Badges b JOIN Users u ON u.Id...

apr 7
11 views

SELECT u.DisplayName,COUNT(DISTINCT(u.DisplayName)), u.L...

apr 7
11 views

SELECT u.DisplayName,COUNT(DISTINCT(u.DisplayName)), u.L...

apr 7
11 views

SELECT u.DisplayName,COUNT(DISTINCT(u.DisplayName)), u.L...

apr 7
11 views

SELECT u.DisplayName,COUNT(DISTINCT(u.DisplayName)), u.L...

apr 7
11 views

SELECT u.DisplayName,COUNT(DISTINCT(u.DisplayName)), COU...

apr 7
11 views

SELECT COUNT(DISTINCT(u.DisplayName)), COUNT(u.Location)...

apr 7
11 views

WITH Raw AS ( SELECT Posts.OwnerUserId AS UserId, Votes.C...

apr 7 peterh - PLEASE DELETE THIS ACCOUNT
12 views

SELECT * FROM Users

apr 7
11 views

SELECT u.DisplayName, u.Location,b.Name FROM Badges b JO...

apr 7
11 views

SELECT * FROM Badges b JOIN Users u ON u.Id = b.UserId WH...

apr 7
13 views

SELECT TOP 1000 Posts.PostTypeId, Votes.* FROM Votes, Posts

apr 7 peterh - PLEASE DELETE THIS ACCOUNT
13 views

SELECT TOP 1000 * FROM Votes, Posts WHERE Votes.VoteTypeI...

apr 7 peterh - PLEASE DELETE THIS ACCOUNT
10 views

SELECT u.DisplayName, u.Location FROM Badges b JOIN User...

apr 7
11 views

SELECT b.Name, u.Location FROM Badges b JOIN Users u ON ...

apr 7
10 views

SELECT * FROM Badges b JOIN Users u ON u.Id = b.UserId WH...

apr 7
10 views

SELECT * FROM Badges b JOIN Users u ON u.Id = b.UserId WH...

apr 7
10 views

SELECT * FROM Badges b JOIN Users u ON u.Id = b.UserId WH...

apr 7
10 views

SELECT * FROM Badges b JOIN Users u ON u.Id = b.UserId WH...

apr 7
13 views

SELECT TOP 1000 * FROM Votes WHERE VoteTypeId BETWEEN 8 A...

apr 7 peterh - PLEASE DELETE THIS ACCOUNT
13 views

SELECT * FROM VoteTypes;

apr 7 peterh - PLEASE DELETE THIS ACCOUNT
10 views

SELECT * FROM Badges b JOIN Users u ON u.Id = b.UserId WH...

apr 7
13 views

select * from Badges where name = 'Enlightened' and year(...

apr 7
12 views

select count(*) as questionsAsked from Posts where PostTy...

apr 7
12 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

apr 7
12 views

select year(CreationDate), count(*) as nrUsers from Users...

apr 7
12 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

apr 7
12 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

apr 7
12 views

with AnswerScores AS ( SELECT Users.Id AS [User Link], SU...

apr 7
12 views

with AnswerScores AS ( SELECT Users.Id AS [User Link], SU...

apr 7
12 views

with AnswerScores AS ( SELECT Users.Id AS [User Link], SU...

apr 7
12 views

select top(100) t.TagName,sum(p.ViewCount) Views from pos...

apr 7
12 views

select year(CreationDate), count(*) as nrUsers from Users...

apr 7
12 views

select top(50) t.TagName,sum(p.ViewCount) Views from post...

apr 7
12 views

with AnswerScores AS ( SELECT Users.Id AS [User Link], SU...

apr 7
12 views

select * from Badges where name = 'Enlightened'

apr 7
12 views

select top(50) t.TagName,sum(p.ViewCount) Views from post...

apr 7
12 views

select top(20) t.TagName,sum(p.ViewCount) Views from post...

apr 7
12 views

select top(20) t.TagName,sum(p.ViewCount) Views from post...

apr 7
12 views

select top(20) t.TagName,sum(p.ViewCount) Views from post...

apr 7
12 views

select top(20) t.TagName,sum(p.ViewCount) Views from post...

apr 7
12 views

with AnswerScores AS ( SELECT Users.Id AS [User Link], SU...

apr 7
12 views

with AnswerScores AS ( SELECT Users.Id AS [User Link], SU...

apr 7
12 views

with AnswerScores AS ( SELECT Users.Id AS [User Link], SU...

apr 7
12 views

with AnswerScores AS ( SELECT Users.Id AS [User Link], SU...

apr 7
12 views

with AnswerScores AS ( SELECT Users.Id AS [User Link], SU...

apr 7
12 views

SELECT Count(*) AS QuestionCount FROM Posts p JOIN PostTa...

apr 7
12 views

select * from users where location = 'South Africa'

apr 7
12 views

SELECT Count(*) AS QuestionCount FROM Posts p JOIN PostTa...

apr 7
12 views

SELECT Count From Tags Where TagName = 'javascript'

apr 7
12 views

SELECT Count From Tags Where TagName = 'javascript'

apr 7
12 views

select * from users

apr 7
20 views

ddasdasd

apr 7
21 views

ddasdasd

apr 7
21 views

ddasdasd

apr 7
20 views

ddasdasd

apr 7
21 views

ddasdasd

apr 7
13 views

SELECT Count From Tags Where TagName = 'javascript OR java'

apr 7
13 views

SELECT Count From Tags Where TagName = 'javascript OR java'

apr 7
12 views

SELECT Count From Tags Where TagName = 'javascript'

apr 7
13 views

SELECT Count From Tags Where TagName = 'javascript'

apr 7
13 views

SELECT Count From Tags Where TagName = 'javascript'

apr 7
12 views

SELECT Count From Tags Where TagName = 'javascript'

apr 7
13 views

SELECT Count From Tags Where TagName = 'javascript'

apr 7
12 views

SELECT Count From Tags Where TagName = 'javascript'

apr 7
12 views

SELECT Count From Tags Where TagName = 'javascript'

apr 7
12 views

select count(*) as questionsAsked from Posts where PostTy...

apr 7
12 views

select distinct top 50000 p.id, p.title, p.body, a.body a...

apr 7
12 views

select distinct top 3000 p.id, p.title, p.body, a.body as...

apr 7
12 views

select distinct top 3000 p.id, p.title, p.body, a.body as...

apr 7
11 views

select * from PostHistoryTypes

apr 7
11 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

apr 7
1

22 views

Number of questions, answers, posts per month (including deleted posts)

apr 7 Martin20528
10 views

SELECT u.Id AS [User Link], CONCAT('https://stackoverflow...

apr 7
1

23 views

Number of questions, answers, posts per month

apr 7 Martin20528
10 views

select count(*) as questionsAsked from Posts where PostTy...

apr 7

30 50 100 per page

1,483,864

queries

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

39k questions

90k answers

215k comments

1.2k tags

apr 5 most recent