Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

149 views

select * from posts a INNER JOIN posts q ON a.posttypeid=...

feb 18 11
206 views

select top 10 * from posts a INNER JOIN posts q ON a.post...

feb 18 11
162 views

select top 10 * from posts a INNER JOIN posts q ON a.post...

feb 18 11
173 views

select top 10 * from posts a INNER JOIN posts q ON a.post...

feb 18 11
171 views

select top 10 * from posts where posttypeid=1

feb 18 11
173 views

select top 2000 postid as "Post Link", * from comments wh...

feb 18 11 Kobi
185 views

select v.Id from Votes v where v.UserId = ##userId##

feb 18 11 Daniel DiPaolo
164 views

select v.Id from Votes v where v.UserId = ##userId## and...

feb 18 11 Daniel DiPaolo
207 views

select v.Id from Votes v where v.UserId = ##userId## and...

feb 18 11 Daniel DiPaolo
190 views

select v.Id from Votes v where v.UserId = ##userId## and...

feb 18 11 Daniel DiPaolo
207 views

select v.Id from Votes v where v.VoteTypeId = 8 --boun...

feb 18 11 Daniel DiPaolo
187 views

select v.Id as [Post Link] from Votes v where v.VoteTyp...

feb 18 11 Daniel DiPaolo
167 views

select v.postId as [Post Link] from Votes v where v.Vo...

feb 18 11 Daniel DiPaolo
172 views

select p.parentId as [Post Link] from Posts p inner joi...

feb 18 11 Daniel DiPaolo
164 views

select p.parentId as [Post Link] from Posts p inner joi...

feb 18 11 Daniel DiPaolo
141 views

select p.parentId as [Post Link] from Posts p inner joi...

feb 18 11 Daniel DiPaolo
133 views

select top 200 postid as "Post Link", * from comments where

feb 18 11 Kobi
131 views

select top 200 postid as "Post Link", * from comments where

feb 18 11 Kobi
134 views

select top 200 postid as "Post Link", * from comments where

feb 18 11 Kobi
135 views

select top 20 postid as "Post Link", * from comments wher...

feb 18 11 Kobi
148 views

select top 20 * from comments where Text like '%[[] ](htt...

feb 18 11 Kobi
186 views

select top 20 * from comments where Text like '%[ ](http:%'

feb 18 11 Kobi
155 views

select top 20 * from comments where Text like '%[ ](%' or...

feb 18 11 Kobi
170 views

select * from comments where Text like '%[ ](%'

feb 18 11 Kobi
116 views

DECLARE @USER int = ##User##; SELECT TOP 1 * FROM PostH...

feb 18 11
127 views

DECLARE @USER int = ##User##; SELECT MAX(CreationDate) ...

feb 18 11
99 views

DECLARE @USER int = ##User##; SELECT * FROM PostHistory...

feb 18 11
2

4.2k views

Posts that are one upvote away from earning you "Necromancer"

feb 18 11 Daniel DiPaolo
327 views

Posts that are one upvote away from earning you "Necromancer"

feb 18 11 Daniel DiPaolo
322 views

Posts that are one upvote away from earning you "Necromancer"

feb 18 11 Daniel DiPaolo
358 views

Posts that are one upvote away from earning you "Necromancer"

feb 18 11 Daniel DiPaolo
353 views

Posts that are one upvote away from earning you "Necromancer"

feb 18 11 Daniel DiPaolo
1

1.5k views

Posts that are one upvote away from earning you "Necromancer"

feb 18 11 Daniel DiPaolo
305 views

Posts that are one upvote away from earning you "Necromancer"

feb 18 11 Daniel DiPaolo
1

2.6k views

Posts that are one upvote away from earning you "Necromancer"

feb 18 11 Daniel DiPaolo
341 views

Posts that are one upvote away from earning you "Necromancer"

feb 18 11 Daniel DiPaolo
719 views

Posts that are one upvote away from earning you "Necromancer"

feb 18 11 Daniel DiPaolo
296 views

Posts that are one upvote away from earning you "Necromancer"

feb 18 11 Daniel DiPaolo
217 views

Posts that are one upvote away from earning you "Necromancer"

feb 18 11 Daniel DiPaolo
109 views

Posts that are one upvote away from earning you "Necromancer"

feb 18 11 Daniel DiPaolo
1

376 views

Posts that can earn you "Necromancer"

feb 18 11 Daniel DiPaolo
105 views

Posts that can earn you "Necromancer"

feb 18 11 Daniel DiPaolo
1

216 views

Posts that can earn you "Necromancer"

feb 18 11 Daniel DiPaolo
70 views

Almost Necromancer posts

feb 18 11 Daniel DiPaolo
58 views

Almost Necromancer posts

feb 18 11 Daniel DiPaolo
55 views

Almost Necromancer posts

feb 18 11 Daniel DiPaolo
53 views

Almost Necromancer posts

feb 18 11 Daniel DiPaolo
48 views

Almost Necromancer posts

feb 18 11 Daniel DiPaolo
56 views

Almost Necromancer posts

feb 18 11 Daniel DiPaolo
56 views

Almost Necromancer posts

feb 18 11 Daniel DiPaolo
1

126 views

Almost Necromancer posts

feb 18 11 Daniel DiPaolo
24 views

Posts that can earn you "Necromancer"

feb 18 11 Daniel DiPaolo
151 views

Posts that are one upvote away from earning you "Necromancer"

feb 18 11 Daniel DiPaolo
174 views

Posts that are one upvote away from earning you "Necromancer"

feb 18 11 Daniel DiPaolo
106 views

SELECT TOP 100 Title FROM POSTS

feb 18 11
3

6.2k views

Top answerers of SO

feb 18 11 shog9
1.1k views

Top answerers of SO

feb 18 11 shog9
654 views

Top answerers of SO

feb 18 11 shog9
415 views

Top answerers of SO

feb 18 11 shog9
283 views

Top answerers of SO

feb 18 11 shog9
326 views

Top answerers of SO

feb 18 11 shog9
213 views

Top answerers of SO

feb 18 11 shog9
195 views

Top answerers of SO

feb 18 11 shog9
208 views

Top answerers of SO

feb 18 11 shog9
213 views

Top answerers of SO

feb 18 11 shog9
266 views

Top answerers of SO

feb 18 11 shog9
841 views

Top answerers of SO

feb 18 11 shog9
242 views

Top answerers of SO

feb 18 11 shog9
253 views

Top answerers of SO

feb 18 11 shog9
217 views

Top answerers of SO

feb 18 11 shog9
230 views

Top answerers of SO

feb 18 11 shog9
196 views

Top answerers of SO

feb 18 11 shog9
227 views

Top answerers of SO

feb 18 11 shog9
265 views

Top answerers of SO

feb 18 11 shog9
231 views

Top answerers of SO

feb 18 11 shog9
36 views

Top answerers of SO

feb 18 11 shog9
43 views

Top answerers of SO

feb 18 11 shog9
60 views

Top answerers of SO

feb 18 11 shog9
1

288 views

Top answerers of SO

feb 18 11 shog9
41 views

Top answerers of SO

feb 18 11 shog9
25 views

Top answerers of SO

feb 18 11 shog9
1

7k views

Top askers of SO

feb 18 11 shog9
1.3k views

Top askers of SO

feb 18 11 shog9
1.6k views

Top askers of SO

feb 18 11 shog9
789 views

Top askers of SO

feb 18 11 shog9
763 views

Top askers of SO

feb 18 11 shog9
990 views

Top askers of SO

feb 18 11 shog9
685 views

Top askers of SO

feb 18 11 shog9
525 views

Top askers of SO

feb 18 11 shog9
705 views

Top askers of SO

feb 18 11 shog9
627 views

Top askers of SO

feb 18 11 shog9
702 views

Top askers of SO

feb 18 11 shog9
707 views

Top askers of SO

feb 18 11 shog9
678 views

Top askers of SO

feb 18 11 shog9
1k views

Top askers of SO

feb 18 11 shog9
1.1k views

Top askers of SO

feb 18 11 shog9
1.1k views

Top askers of SO

feb 18 11 shog9
1.1k views

Top askers of SO

feb 18 11 shog9
1.9k views

Top askers of SO

feb 18 11 shog9
1.2k views

Top askers of SO

feb 18 11 shog9
1.3k views

Top askers of SO

feb 18 11 shog9
352 views

Top askers of SO

feb 18 11 shog9
1

1.1k views

Top askers

feb 18 11 shog9
329 views

Top askers of SO

feb 18 11 shog9
451 views

Top 200 askers of SO

feb 18 11 shog9
275 views

Top askers of SO

feb 18 11 shog9
446 views

Top askers of SO

feb 18 11 shog9
420 views

Top askers of SO

feb 18 11 shog9
455 views

Top askers of SO

feb 18 11 shog9
273 views

Top askers of SO

feb 18 11 shog9
206 views

Top askers of SO

feb 18 11 shog9
289 views

Top askers of SO

feb 18 11 shog9
217 views

Top askers of SO

feb 18 11 shog9
254 views

Top askers of SO

feb 18 11 shog9
272 views

Top askers of SO

feb 18 11 shog9
271 views

Top askers of SO

feb 18 11 shog9
379 views

Top askers of SO

feb 18 11 shog9
263 views

Top askers of SO

feb 18 11 shog9
274 views

Top askers of SO

feb 18 11 shog9
261 views

Top askers of SO

feb 18 11 shog9
246 views

Top askers of SO

feb 18 11 shog9
234 views

Top askers of SO

feb 18 11 shog9
273 views

Top askers of SO

feb 18 11 shog9
235 views

Top askers of SO

feb 18 11 shog9
220 views

Top askers of SO

feb 18 11 shog9
290 views

Top askers of SO

feb 18 11 shog9
358 views

Top askers of SO

feb 18 11 shog9
203 views

Top responders of SO

feb 18 11 shog9
364 views

Top askers of SO

feb 18 11 shog9
424 views

Top askers of SO

feb 18 11 shog9
471 views

Top askers of SO

feb 18 11 shog9
338 views

Top askers of SO

feb 18 11 shog9
229 views

Top askers of SO

feb 18 11 shog9
49 views

Top askers of SO

feb 18 11 shog9
24 views

Top askers of SO

feb 18 11 shog9
28 views

Top askers of SO

feb 18 11 shog9
23 views

Top askers of SO

feb 18 11 shog9
27 views

Top askers of SO

feb 18 11 shog9
35 views

Top askers of SO

feb 18 11 shog9
29 views

Top askers of SO

feb 18 11 shog9
25 views

Top askers of SO

feb 18 11 shog9
29 views

Top askers of SO

feb 18 11 shog9
193 views

Top askers of SO

feb 18 11 shog9
29 views

Top askers of SO

feb 18 11 shog9
25 views

Top askers of SO

feb 18 11 shog9
29 views

Top askers of SO

feb 18 11 shog9
36 views

Top askers of SO

feb 18 11 shog9
67 views

Top askers of SO

feb 18 11 shog9
172 views

select OwnerUserId as [UserLink], Count(*) as PostCount ...

feb 18 11 shog9
153 views

select OwnerUserId as [UserLink], Count(*) as PostCount ...

feb 18 11 shog9
138 views

SELECT p.Id as [Post Link] FROM Posts p INNER JOIN PostTy...

feb 18 11
109 views

Rising stars, top 50 users ordered on rep per day

feb 18 11
122 views

Rising stars, top 50 users ordered on rep per day

feb 18 11
116 views

DECLARE @AnswererId int = ##AnswerUser## SELECT q.Id as ...

feb 18 11
103 views

DECLARE @AnswererId int = ##AnswerUser## SELECT q.Id as ...

feb 18 11
97 views

DECLARE @AnswererId int = ##AnswerUser## SELECT q.Id as ...

feb 18 11
111 views

DECLARE @AnswererId int = ##AnswerUser## SELECT q.Id as ...

feb 18 11
100 views

DECLARE @AnswererId int = ##AnswerUser## SELECT COUNT(q....

feb 18 11
103 views

DECLARE @AnswererId int = ##AnswerUser## SELECT q.Id as ...

feb 18 11
1

3.2k views

Negative Vibrations - Users sorted by their Downvote / Upvote Ratio.

feb 18 11 oid
147 views

Negative Vibrations - Users sorted by their Downvote / Upvote Ratio.

feb 18 11 oid
141 views

Negative Vibrations - Users sorted by their Downvote / Upvote Ratio.

feb 18 11 oid
138 views

Negative Vibrations - Users sorted by their Downvote / Upvote Ratio.

feb 18 11 oid
130 views

Negative Vibrations - Users sorted by their Downvote / Upvote Ratio.

feb 18 11 oid
132 views

Negative Vibrations - Users sorted by their Downvote / Upvote Ratio.

feb 18 11 oid
128 views

Negative Vibrations - Users sorted by their Downvote / Upvote Ratio.

feb 18 11 oid
148 views

High Standards - Top 100 Users that rarely upvote.

feb 18 11 oid
162 views

High Standards - Top 100 Users that rarely upvote.

feb 18 11 oid
161 views

High Standards - Top 100 Users that rarely upvote.

feb 18 11 oid
126 views

High Standards - Top 100 Users that rarely upvote.

feb 18 11 oid
128 views

High Standards - Top 100 Users that rarely upvote.

feb 18 11 oid
117 views

DECLARE @AnswererId int = ##AnswerUser## DECLARE @Questio...

feb 18 11
155 views

select Text from Comments where Text like '%`%' or Text l...

feb 18 11 balpha
132 views

select Text from Comments where Text like '%`%' or Text l...

feb 18 11 balpha
140 views

select Text from Comments where Text like '%`%' or Text l...

feb 18 11 balpha
170 views

select * from Comments where Id=443

feb 18 11 balpha
137 views

select Text from Comments where Text like '%\%'

feb 18 11 balpha
131 views

SELECT Users.ID as [User Link], Users.Reputation, Users.W...

feb 18 11 amirreza.soudi
135 views

select name from badges group by name order by name desc

feb 18 11
102 views

select name from badges

feb 18 11
119 views

select id from posts

feb 18 11
128 views

select * from PostTypes;

feb 18 11
128 views

Gets all down votes for user

feb 18 11 Renesis
131 views

Gets all down votes for user

feb 18 11 Renesis
164 views

select top 100 * from PostHistory;

feb 18 11 ellement25
157 views

select * from PostHistory;

feb 18 11 ellement25
170 views

select * from Posts where id = 577;

feb 18 11 ellement25
179 views

select * from Posts where id = 1;

feb 18 11 ellement25
127 views

select PostId from PostTags where TagId = 1;

feb 18 11 ellement25
154 views

select top 100 * from PostTags;

feb 18 11 ellement25
168 views

select top 100 * from Tags order by count desc; select to...

feb 18 11 ellement25
161 views

select top 100 * from Tags order by count desc;

feb 18 11 ellement25
150 views

select top 100 * from Tags order by count;

feb 18 11 ellement25
146 views

select top 100 * from Tags;

feb 18 11 ellement25
124 views

select top 10 * from votes v inner join posts q on q.id ...

feb 18 11 cyberkiwi2010
135 views

select top 10 * from votes v inner join posts q on q.id ...

feb 18 11 cyberkiwi2010
177 views

select top 100 * from votes where votetypeid in (9)

feb 18 11 cyberkiwi2010
157 views

select top 100 * from votes where votetypeid in (8,9)

feb 18 11 cyberkiwi2010
165 views

SELECT q.PostId FROM PostTags q WHERE q.TagId = ( SELECT ...

feb 18 11 waiwai933
141 views

SELECT q.PostId FROM PostTags q WHERE q.TagId = ( SELECT ...

feb 18 11 waiwai933
174 views

SELECT TOP 40 TagName, COUNT(p.TagId) as 'Uses', 200-Coun...

feb 18 11 waiwai933
3.7k views

How many rows?

feb 18 11 denilsonsa
148 views

select * from posts where OwnerDisplayName = 'AviD'

feb 17 11
143 views

set nocount on declare @VoteStats table (PostId int, up i...

feb 17 11
119 views

set nocount on declare @VoteStats table (PostId int, up i...

feb 17 11
122 views

set nocount on declare @VoteStats table (PostId int, up i...

feb 17 11
3.8k views

Question-Score-to-Answer Ratio

feb 17 11 Renesis
158 views

SELECT COUNT(*) as Questions, SUM(AnswerCount) as Answers,

feb 17 11 Renesis
138 views

Gets all down votes for user

feb 17 11 Daniel DiPaolo
3k views

Find Questions Voted 4/5 To Close

feb 17 11 yelton.jared
175 views

Gets all down votes for user

feb 17 11 Daniel DiPaolo
167 views

Find Questions Voted 4/5 To Close

feb 17 11 yelton.jared
142 views

Gets all down votes for user

feb 17 11 Daniel DiPaolo
194 views

Find Questions Voted 4/5 To Close

feb 17 11 yelton.jared
134 views

Gets all down votes for user

feb 17 11 Daniel DiPaolo

30 50 100 per page

1,652,705

queries

Q&A about the site for scholars and enthusiasts of literature

402 questions

815 answers

3.2k comments

88 tags

jan 10 most recent