Stack Exchange
log in
help
Stack Exchange Data Explorer
Home
Queries
Users
Compose Query
Editing Query
edit description
Q&A for professional and enthusiast programmers
select * from posts where YEAR(creationdate)>=2010 AND YEAR(creationdate)<2014 and parentid is null order by creationdate asc OFFSET 3050000 ROWS FETCH NEXT 50000 ROWS ONLY
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 (250)
AnswerCount
int
CommentCount
int
FavoriteCount
int
ClosedDate
datetime
CommunityOwnedDate
datetime
ContentLicense
varchar (12)
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 (12)
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 (12)
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 (250)
AnswerCount
int
CommentCount
int
FavoriteCount
int
ClosedDate
datetime
CommunityOwnedDate
datetime
ContentLicense
varchar (12)
PostTags
PostId
int
TagId
int
PostTypes
Id
tinyint
Name
nvarchar (50)
RelatedQuestions
PostId
int
RelatedPostId
int
Position
int
Score
numeric
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
1824651
green.fuzer
oct 18 '21 at 14:15
1824646
green.fuzer
oct 18 '21 at 14:12
1824511
green.fuzer
oct 18 '21 at 11:48
1824507
green.fuzer
oct 18 '21 at 11:45
1824500
green.fuzer
oct 18 '21 at 11:36
1824496
green.fuzer
oct 18 '21 at 11:31
1824495
green.fuzer
oct 18 '21 at 11:28
1824494
green.fuzer
oct 18 '21 at 11:24
1824493
green.fuzer
oct 18 '21 at 11:23
1824491
green.fuzer
oct 18 '21 at 11:19
1824487
green.fuzer
oct 18 '21 at 11:15
1824482
green.fuzer
oct 18 '21 at 11:12
1824480
green.fuzer
oct 18 '21 at 11:08
1824478
green.fuzer
oct 18 '21 at 11:05
1824474
green.fuzer
oct 18 '21 at 11:02
1824472
green.fuzer
oct 18 '21 at 10:58
1824471
green.fuzer
oct 18 '21 at 10:58
1824469
green.fuzer
oct 18 '21 at 10:50
1824467
green.fuzer
oct 18 '21 at 10:46
1824465
green.fuzer
oct 18 '21 at 10:41
1824457
green.fuzer
oct 18 '21 at 10:35
1824449
green.fuzer
oct 18 '21 at 10:30
1824411
green.fuzer
oct 18 '21 at 9:43
1824404
green.fuzer
oct 18 '21 at 9:34
1824400
green.fuzer
oct 18 '21 at 9:31
1824397
green.fuzer
oct 18 '21 at 9:29
1824395
green.fuzer
oct 18 '21 at 9:27
1824388
green.fuzer
oct 18 '21 at 9:25
1824384
green.fuzer
oct 18 '21 at 9:23
1824381
green.fuzer
oct 18 '21 at 9:21
1824374
green.fuzer
oct 18 '21 at 9:17
1824373
green.fuzer
oct 18 '21 at 9:14
1824370
green.fuzer
oct 18 '21 at 9:12
1824369
green.fuzer
oct 18 '21 at 9:09
1824367
green.fuzer
oct 18 '21 at 9:06
1824365
green.fuzer
oct 18 '21 at 9:03
1824363
green.fuzer
oct 18 '21 at 9:01
1824358
green.fuzer
oct 18 '21 at 8:58
1824354
green.fuzer
oct 18 '21 at 8:52
1824349
green.fuzer
oct 18 '21 at 8:47
1824348
green.fuzer
oct 18 '21 at 8:46
1824345
green.fuzer
oct 18 '21 at 8:43
1824343
green.fuzer
oct 18 '21 at 8:41
1824340
green.fuzer
oct 18 '21 at 8:37
1824336
green.fuzer
oct 18 '21 at 8:34
1824335
green.fuzer
oct 18 '21 at 8:31
1824334
green.fuzer
oct 18 '21 at 8:28
1824333
green.fuzer
oct 18 '21 at 8:25
1824332
green.fuzer
oct 18 '21 at 8:23
1824331
green.fuzer
oct 18 '21 at 8:13
1824330
green.fuzer
oct 18 '21 at 8:10
1824329
green.fuzer
oct 18 '21 at 8:07
1824328
green.fuzer
oct 18 '21 at 8:04
1824327
green.fuzer
oct 18 '21 at 8:02
1824325
green.fuzer
oct 18 '21 at 8:00
1824322
green.fuzer
oct 18 '21 at 7:58
1824320
green.fuzer
oct 18 '21 at 7:57
1824318
green.fuzer
oct 18 '21 at 7:55
1824315
green.fuzer
oct 18 '21 at 7:53
1824313
green.fuzer
oct 18 '21 at 7:51
1824311
green.fuzer
oct 18 '21 at 7:49
1824307
green.fuzer
oct 18 '21 at 7:47
1824306
green.fuzer
oct 18 '21 at 7:45
1824305
green.fuzer
oct 18 '21 at 7:44
permalink
hide sidebar
Enter Parameters
Run Query
Cancel
Options:
Text-only results
Include execution plan
Switch to meta 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