Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

23 views

SELECT AVG(answer_count) AS AverageAnswers FROM ( SELECT ...

dec 9 jon.doe46539
1 view

select count(id) from users where reputation>10000

dec 9
23 views

SELECT MAX(NumberOfComments) AS MostComments FROM ( SELEC...

dec 9 jon.doe46539
23 views

SELECT UserId, COUNT(Id) AS NumberOfComments FROM Comment...

dec 9 jon.doe46539
2 views

SELECT DisplayName FROM Users WHERE (Location LIKE 'Lug%'...

dec 9
23 views

SELECT COUNT(c.Id) AS TotalNumberOfComments FROM Posts p ...

dec 9 jon.doe46539
23 views

SELECT COUNT(c.Id) AS TotalNumberOfComments FROM Posts p ...

dec 9 jon.doe46539
2 views

SELECT DisplayName FROM Users WHERE Location LIKE '%Луган...

dec 9
23 views

SELECT COUNT(c.Id) AS TotalNumberOfComments FROM Posts p ...

dec 9 jon.doe46539
23 views

SELECT u.Id AS UserId, u.DisplayName, COUNT(p.Id) AS Numb...

dec 9 jon.doe46539
23 views

SELECT u.Id AS UserId, u.Reputation FROM Users u JOIN Pos...

dec 9 jon.doe46539
23 views

SELECT p1.Id AS QuestionId, Avg(p2.score) as AverageAnswe...

dec 9 jon.doe46539
23 views

SELECT p1.Id AS QuestionId FROM Posts p1 JOIN Posts p2 ON...

dec 9 jon.doe46539
23 views

SELECT p1.Id AS QuestionId, p1.Title AS QuestionTitle, CO...

dec 9 jon.doe46539
23 views

SELECT p1.Id AS QuestionId FROM Posts p1 JOIN Posts p2 ON...

dec 9 jon.doe46539
6 views

SELECT t.TagName as Platform, DATEPART(YEAR, p.CreationDa...

dec 9
10 views

SELECT TOP 100 p.Id as PostId, p.Title, p.Score as PostSc...

dec 9
10 views

SELECT Users.location as Location, Tags.TagName as Transp...

dec 9
5 views

select * from users;

dec 9 jon.doe46540
11 views

SELECT Users.Location, Tags.TagName, COUNT(*) as PostCount,

dec 9
10 views

SELECT Users.Location, Tags.TagName, COUNT(*) as PostCount,

dec 9
10 views

Users with high self-accept rates (and having > 10 answers)

dec 9
11 views

SELECT TOP 20 p.Id, p.Title, p.Body, p.CreationDate FROM ...

dec 9
11 views

SELECT Users.Location, Tags.TagName, COUNT(*) as PostCount,

dec 9
10 views

SELECT TOP 20 u.Id, u.DisplayName, u.CreationDate FROM Us...

dec 9
11 views

SELECT top 20 u.DisplayName, p.Body FROM Users u LEFT OUT...

dec 9
10 views

SELECT u.DisplayName, p.Body FROM Users u LEFT OUTER JOIN...

dec 9
10 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 9
5 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 9
10 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 9
11 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 9
10 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 9
11 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 9
10 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 9
10 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 9
6 views

SELECT Posts.Title, Posts.Score, Posts.ViewCount, Posts.A...

dec 9
10 views

SELECT top 20 u.DisplayName, p.Body FROM Posts p LEFT OUT...

dec 9

30 50 100 per page

2,278,407

queries

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

16k questions

20k answers

45k comments

506 tags

dec 7 most recent