Stack Exchange
log in
help
Stack Exchange Data Explorer
Home
Queries
Users
Compose Query
Editing Query
edit description
Q&A about the site for administrators, end users, developers and designers for Craft CMS
SELECT TOP 20 CONCAT ('http://superuser.com/q/', Posts.Id) as Question FROM PostHistory JOIN Posts ON Posts.Id = PostHistory.PostId WHERE Posts.ClosedDate >= '2012-01-01' --AND Posts.ClosedDate < '2012-12-01' AND PostHistoryTypeId = 10 AND PostHistory.Comment != 1 ORDER BY NEWID()
Database Schema
Posts
Id
int
PostTypeId
tinyint
AcceptedAnswerId
int
ParentId
int
CreationDate
datetime
DeletionDate
datetime
Score
int
ViewCount
int
Body
nvarchar (max)
OwnerUserId
int
OwnerDisplayName
nvarchar (40)
LastEditorUserId
int
LastEditorDisplayName
nvarchar (40)
LastEditDate
datetime
LastActivityDate
datetime
Title
nvarchar (250)
Tags
nvarchar (4000)
AnswerCount
int
CommentCount
int
FavoriteCount
int
ClosedDate
datetime
CommunityOwnedDate
datetime
ContentLicense
varchar (30)
Users
Id
int
Reputation
int
CreationDate
datetime
DisplayName
nvarchar (40)
LastAccessDate
datetime
WebsiteUrl
nvarchar (200)
Location
nvarchar (100)
AboutMe
nvarchar (max)
Views
int
UpVotes
int
DownVotes
int
ProfileImageUrl
nvarchar (200)
EmailHash
varchar (32)
AccountId
int
Comments
Id
int
PostId
int
Score
int
Text
nvarchar (600)
CreationDate
datetime
UserDisplayName
nvarchar (40)
UserId
int
ContentLicense
varchar (30)
Badges
Id
int
UserId
int
Name
nvarchar (50)
Date
datetime
Class
tinyint
TagBased
bit
CloseAsOffTopicReasonTypes
Id
smallint
IsUniversal
bit
InputTitle
nvarchar (100)
MarkdownInputGuidance
nvarchar (500)
MarkdownPostOwnerGuidance
nvarchar (500)
MarkdownPublicGuidance
nvarchar (500)
MarkdownConcensusDescription
nvarchar (500)
CreationDate
datetime
CreationModeratorId
int
ApprovalDate
datetime
ApprovalModeratorId
int
DeactivationDate
datetime
DeactivationModeratorId
int
CloseReasonTypes
Id
tinyint
Name
nvarchar (200)
Description
nvarchar (500)
FlagTypes
Id
tinyint
Name
nvarchar (50)
Description
nvarchar (500)
PendingFlags
Id
int
FlagTypeId
tinyint
PostId
int
CreationDate
date
CloseReasonTypeId
tinyint
CloseAsOffTopicReasonTypeId
smallint
DuplicateOfQuestionId
int
BelongsOnBaseHostAddress
nvarchar (100)
PostFeedback
Id
int
PostId
int
IsAnonymous
bit
VoteTypeId
tinyint
CreationDate
datetime
PostHistory
Id
int
PostHistoryTypeId
tinyint
PostId
int
RevisionGUID
uniqueidentifier
CreationDate
datetime
UserId
int
UserDisplayName
nvarchar (40)
Comment
nvarchar (400)
Text
nvarchar (max)
ContentLicense
varchar (30)
PostHistoryTypes
Id
tinyint
Name
nvarchar (50)
PostLinks
Id
int
CreationDate
datetime
PostId
int
RelatedPostId
int
LinkTypeId
tinyint
PostNotices
Id
int
PostId
int
PostNoticeTypeId
int
CreationDate
datetime
DeletionDate
datetime
ExpiryDate
datetime
Body
nvarchar (max)
OwnerUserId
int
DeletionUserId
int
PostNoticeTypes
Id
int
ClassId
tinyint
Name
nvarchar (80)
Body
nvarchar (max)
IsHidden
bit
Predefined
bit
PostNoticeDurationId
int
PostsWithDeleted
Id
int
PostTypeId
tinyint
AcceptedAnswerId
int
ParentId
int
CreationDate
datetime
DeletionDate
datetime
Score
int
ViewCount
int
Body
nvarchar (max)
OwnerUserId
int
OwnerDisplayName
nvarchar (40)
LastEditorUserId
int
LastEditorDisplayName
nvarchar (40)
LastEditDate
datetime
LastActivityDate
datetime
Title
nvarchar (250)
Tags
nvarchar (4000)
AnswerCount
int
CommentCount
int
FavoriteCount
int
ClosedDate
datetime
CommunityOwnedDate
datetime
ContentLicense
varchar (30)
PostTags
PostId
int
TagId
int
PostTypes
Id
tinyint
Name
nvarchar (50)
RelatedQuestions
PostId
int
RelatedPostId
int
Position
int
Score
decimal
ReviewRejectionReasons
Id
tinyint
Name
nvarchar (100)
Description
nvarchar (300)
PostTypeId
tinyint
ReviewTaskResults
Id
int
ReviewTaskId
int
ReviewTaskResultTypeId
tinyint
CreationDate
date
RejectionReasonId
tinyint
Comment
nvarchar (400)
ReviewTaskResultTypes
Id
tinyint
Name
nvarchar (100)
Description
nvarchar (300)
ReviewTasks
Id
int
ReviewTaskTypeId
tinyint
CreationDate
date
DeletionDate
date
ReviewTaskStateId
tinyint
PostId
int
SuggestedEditId
int
CompletedByReviewTaskId
int
ReviewTaskStates
Id
tinyint
Name
nvarchar (50)
Description
nvarchar (300)
ReviewTaskTypes
Id
tinyint
Name
nvarchar (50)
Description
nvarchar (300)
SuggestedEdits
Id
int
PostId
int
CreationDate
datetime
ApprovalDate
datetime
RejectionDate
datetime
OwnerUserId
int
Comment
nvarchar (800)
Text
nvarchar (max)
Title
nvarchar (250)
Tags
nvarchar (250)
RevisionGUID
uniqueidentifier
SuggestedEditVotes
Id
int
SuggestedEditId
int
UserId
int
VoteTypeId
tinyint
CreationDate
datetime
TargetUserId
int
TargetRepChange
int
Tags
Id
int
TagName
nvarchar (35)
Count
int
ExcerptPostId
int
WikiPostId
int
IsModeratorOnly
bit
IsRequired
bit
TagSynonyms
Id
int
SourceTagName
nvarchar (35)
TargetTagName
nvarchar (35)
CreationDate
datetime
OwnerUserId
int
AutoRenameCount
int
LastAutoRename
datetime
Score
int
ApprovedByUserId
int
ApprovalDate
datetime
Votes
Id
int
PostId
int
VoteTypeId
tinyint
UserId
int
CreationDate
datetime
BountyAmount
int
VoteTypes
Id
tinyint
Name
nvarchar (50)
Revisions
111777
knb
jan 26 '13 at 22:46
109378
hairboat
jan 14 '13 at 22:48
109371
hairboat
jan 14 '13 at 22:45
109369
hairboat
jan 14 '13 at 22:43
109365
hairboat
jan 14 '13 at 22:39
109357
hairboat
jan 14 '13 at 22:29
109351
hairboat
jan 14 '13 at 22:24
109350
hairboat
jan 14 '13 at 22:23
109289
hairboat
jan 14 '13 at 21:30
107516
hairboat
jan 4 '13 at 20:22
104409
hairboat
dec 12 '12 at 18:04
104407
hairboat
dec 12 '12 at 18:03
104402
hairboat
dec 12 '12 at 18:02
104400
hairboat
dec 12 '12 at 18:02
104399
hairboat
dec 12 '12 at 18:01
104398
hairboat
dec 12 '12 at 18:00
104397
hairboat
dec 12 '12 at 17:58
104396
hairboat
dec 12 '12 at 17:55
104122
hairboat
dec 10 '12 at 21:41
104121
hairboat
dec 10 '12 at 21:40
104108
hairboat
dec 10 '12 at 21:35
104107
hairboat
dec 10 '12 at 21:34
104105
hairboat
dec 10 '12 at 21:33
104104
hairboat
dec 10 '12 at 21:32
104103
hairboat
dec 10 '12 at 21:32
104102
hairboat
dec 10 '12 at 21:30
104101
hairboat
dec 10 '12 at 21:26
104100
hairboat
dec 10 '12 at 21:26
104099
hairboat
dec 10 '12 at 21:26
104098
hairboat
dec 10 '12 at 21:23
104097
hairboat
dec 10 '12 at 21:20
104095
hairboat
dec 10 '12 at 21:18
104094
hairboat
dec 10 '12 at 21:17
104090
hairboat
dec 10 '12 at 20:55
104089
hairboat
dec 10 '12 at 20:54
104088
hairboat
dec 10 '12 at 20:54
104087
hairboat
dec 10 '12 at 20:53
104086
hairboat
dec 10 '12 at 20:41
104076
hairboat
dec 10 '12 at 19:58
104069
hairboat
dec 10 '12 at 19:56
104068
hairboat
dec 10 '12 at 19:55
104067
hairboat
dec 10 '12 at 19:55
104065
hairboat
dec 10 '12 at 19:54
104058
hairboat
dec 10 '12 at 19:50
104056
hairboat
dec 10 '12 at 19:50
104046
hairboat
dec 10 '12 at 19:45
104045
hairboat
dec 10 '12 at 19:45
104044
hairboat
dec 10 '12 at 19:45
104042
hairboat
dec 10 '12 at 19:42
104039
hairboat
dec 10 '12 at 19:36
104029
hairboat
dec 10 '12 at 19:05
104028
hairboat
dec 10 '12 at 19:03
104027
hairboat
dec 10 '12 at 19:01
104026
hairboat
dec 10 '12 at 19:00
104025
hairboat
dec 10 '12 at 18:57
104024
hairboat
dec 10 '12 at 18:57
103907
hairboat
dec 10 '12 at 16:31
103904
hairboat
dec 10 '12 at 16:29
103887
hairboat
dec 10 '12 at 16:15
103296
hairboat
dec 6 '12 at 18:04
103295
hairboat
dec 6 '12 at 18:04
102270
hairboat
nov 30 '12 at 19:50
102268
hairboat
nov 30 '12 at 19:50
102265
hairboat
nov 30 '12 at 19:49
102263
hairboat
nov 30 '12 at 19:48
102261
hairboat
nov 30 '12 at 19:48
102259
hairboat
nov 30 '12 at 19:48
102256
hairboat
nov 30 '12 at 19:46
102255
hairboat
nov 30 '12 at 19:46
102254
hairboat
nov 30 '12 at 19:46
102247
hairboat
nov 30 '12 at 19:44
102240
hairboat
nov 30 '12 at 19:42
102236
hairboat
nov 30 '12 at 19:39
102234
hairboat
nov 30 '12 at 19:38
102231
hairboat
nov 30 '12 at 19:37
102224
hairboat
nov 30 '12 at 19:31
102215
hairboat
nov 30 '12 at 19:29
102214
hairboat
nov 30 '12 at 19:29
102209
hairboat
nov 30 '12 at 19:29
102208
hairboat
nov 30 '12 at 19:28
102203
hairboat
nov 30 '12 at 19:27
102201
hairboat
nov 30 '12 at 19:27
102197
hairboat
nov 30 '12 at 19:26
102196
hairboat
nov 30 '12 at 19:26
102193
hairboat
nov 30 '12 at 19:22
99858
hairboat
nov 16 '12 at 20:58
99854
hairboat
nov 16 '12 at 20:58
99852
hairboat
nov 16 '12 at 20:58
99851
hairboat
nov 16 '12 at 20:57
99850
hairboat
nov 16 '12 at 20:57
99846
hairboat
nov 16 '12 at 20:47
99845
hairboat
nov 16 '12 at 20:47
99844
hairboat
nov 16 '12 at 20:47
99843
hairboat
nov 16 '12 at 20:45
99824
hairboat
nov 16 '12 at 20:39
99807
hairboat
nov 16 '12 at 20:02
99805
hairboat
nov 16 '12 at 20:02
99803
hairboat
nov 16 '12 at 20:01
99770
hairboat
nov 16 '12 at 19:54
99762
hairboat
nov 16 '12 at 19:52
99760
hairboat
nov 16 '12 at 19:52
99751
hairboat
nov 16 '12 at 19:50
99750
hairboat
nov 16 '12 at 19:50
99749
hairboat
nov 16 '12 at 19:50
99746
hairboat
nov 16 '12 at 19:50
99736
hairboat
nov 16 '12 at 19:49
99734
hairboat
nov 16 '12 at 19:49
99731
hairboat
nov 16 '12 at 19:49
99719
hairboat
nov 16 '12 at 19:45
99717
hairboat
nov 16 '12 at 19:45
99713
hairboat
nov 16 '12 at 19:45
99709
hairboat
nov 16 '12 at 19:44
99707
hairboat
nov 16 '12 at 19:44
99700
hairboat
nov 16 '12 at 19:41
99692
hairboat
nov 16 '12 at 19:39
99690
hairboat
nov 16 '12 at 19:39
99689
hairboat
nov 16 '12 at 19:38
99683
hairboat
nov 16 '12 at 19:36
99681
hairboat
nov 16 '12 at 19:35
99678
hairboat
nov 16 '12 at 19:35
99673
hairboat
nov 16 '12 at 19:34
permalink
hide sidebar
Enter Parameters
Run Query
Cancel
Options:
Text-only results
Include execution plan
Switch to main site
Hold tight while we fetch your results
Results
[:current/:total]
Messages
Graph
Execution Plan
Download CSV
Download XML
:records returned in :time ms:cached
Data Explorer works best with JavaScript enabled