Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

3 views

SELECT TOP 20 * FROM tags ORDER BY COUNT DESC;

apr 7
3 views

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

apr 7
3 views

SELECT TOP 10 * FROM tags ORDER BY COUNT DESC;

apr 7
3 views

SELECT TOP 10 * FROM tags ORDER BY COUNT DESC;

apr 7
3 views

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

apr 7
3 views

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

apr 7
4 views

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

apr 7
7 views

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

apr 7
9 views

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

apr 7
8 views

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

apr 7
9 views

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

apr 7
9 views

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

apr 7
9 views

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

apr 7
9 views

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

apr 7
9 views

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

apr 7
8 views

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

apr 7
8 views

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

apr 7
9 views

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

apr 7
9 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

30 50 100 per page

1,483,858

queries

Q&A for Joomla! administrators, users, developers and designers

6.2k questions

9.1k answers

21k comments

366 tags

apr 5 most recent