Query Craft CMS Meta - Stack Exchange Data Explorer

Editing Query

edit description

Q&A about the site for administrators, end users, developers and designers for Craft CMS

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

304530 anonymous oct 11 '14 at 17:32
115796 Aarthi feb 8 '13 at 23:48
115795 Aarthi feb 8 '13 at 23:47
115794 Aarthi feb 8 '13 at 23:46
115793 Aarthi feb 8 '13 at 23:46
115792 Aarthi feb 8 '13 at 23:45
115791 Aarthi feb 8 '13 at 23:45
115788 Aarthi feb 8 '13 at 23:44
115787 Aarthi feb 8 '13 at 23:44
115786 Aarthi feb 8 '13 at 23:43
115724 Aarthi feb 8 '13 at 21:56
115723 Aarthi feb 8 '13 at 21:54
115720 Aarthi feb 8 '13 at 21:45
115381 Aarthi feb 7 '13 at 22:55
115380 Aarthi feb 7 '13 at 22:54
115379 Aarthi feb 7 '13 at 22:52
115378 Aarthi feb 7 '13 at 22:51
115377 Aarthi feb 7 '13 at 22:50
115369 Aarthi feb 7 '13 at 22:14
115368 Aarthi feb 7 '13 at 22:14
115367 Aarthi feb 7 '13 at 22:14
115366 Aarthi feb 7 '13 at 22:12
115365 Aarthi feb 7 '13 at 22:12
115364 Aarthi feb 7 '13 at 22:11
115363 Aarthi feb 7 '13 at 22:11
115362 Aarthi feb 7 '13 at 22:10
115361 Aarthi feb 7 '13 at 22:10
115350 Aarthi feb 7 '13 at 21:43
115349 Aarthi feb 7 '13 at 21:43
115348 Aarthi feb 7 '13 at 21:41
115347 Aarthi feb 7 '13 at 21:40
115346 Aarthi feb 7 '13 at 21:39
115344 Aarthi feb 7 '13 at 21:39
115343 Aarthi feb 7 '13 at 21:38
115038 Aarthi feb 7 '13 at 0:55
115037 Aarthi feb 7 '13 at 0:52
115036 Aarthi feb 7 '13 at 0:52
115035 Aarthi feb 7 '13 at 0:51
115034 Aarthi feb 7 '13 at 0:49
115033 Aarthi feb 7 '13 at 0:48
115024 Aarthi feb 7 '13 at 0:22
115023 Aarthi feb 7 '13 at 0:22
115022 Aarthi feb 7 '13 at 0:22
115020 Aarthi feb 7 '13 at 0:03
115019 Aarthi feb 7 '13 at 0:02
114658 Aarthi feb 6 '13 at 16:44
114656 Aarthi feb 6 '13 at 16:41
114654 Aarthi feb 6 '13 at 16:41
114653 Aarthi feb 6 '13 at 16:41
114652 Aarthi feb 6 '13 at 16:41
114650 Aarthi feb 6 '13 at 16:40
114649 Aarthi feb 6 '13 at 16:39
114648 Aarthi feb 6 '13 at 16:39
114646 Aarthi feb 6 '13 at 16:39
114645 Aarthi feb 6 '13 at 16:39
114622 Aarthi feb 6 '13 at 16:10
114621 Aarthi feb 6 '13 at 16:10
114620 Aarthi feb 6 '13 at 16:10
114619 Aarthi feb 6 '13 at 16:09
114618 Aarthi feb 6 '13 at 16:09
114617 Aarthi feb 6 '13 at 16:09
114616 Aarthi feb 6 '13 at 16:08
114614 Aarthi feb 6 '13 at 16:08
114611 Aarthi feb 6 '13 at 16:07
111353 Aarthi jan 23 '13 at 23:23
111352 Aarthi jan 23 '13 at 23:22
111351 Aarthi jan 23 '13 at 23:20
111350 Aarthi jan 23 '13 at 23:20
111349 Aarthi jan 23 '13 at 23:19
111346 Aarthi jan 23 '13 at 23:15
111345 Aarthi jan 23 '13 at 23:15
111341 Aarthi jan 23 '13 at 23:02
111340 Aarthi jan 23 '13 at 23:02
111339 Aarthi jan 23 '13 at 23:02
111338 Aarthi jan 23 '13 at 23:02
111337 Aarthi jan 23 '13 at 23:02
111330 Aarthi jan 23 '13 at 22:51
111329 Aarthi jan 23 '13 at 22:51
111327 Aarthi jan 23 '13 at 22:50
111326 Aarthi jan 23 '13 at 22:49
111325 Aarthi jan 23 '13 at 22:49
111324 Aarthi jan 23 '13 at 22:46
111323 Aarthi jan 23 '13 at 22:46
111322 Aarthi jan 23 '13 at 22:45
111310 Aarthi jan 23 '13 at 22:16
111305 Aarthi jan 23 '13 at 22:13
111304 Aarthi jan 23 '13 at 22:13
111303 Aarthi jan 23 '13 at 22:13
110982 Aarthi jan 23 '13 at 19:49
110981 Aarthi jan 23 '13 at 19:48
110980 Aarthi jan 23 '13 at 19:46
110979 Aarthi jan 23 '13 at 19:46
110965 Aarthi jan 23 '13 at 18:59
110964 Aarthi jan 23 '13 at 18:58
110963 Aarthi jan 23 '13 at 18:56
110962 Aarthi jan 23 '13 at 18:55
110961 Aarthi jan 23 '13 at 18:55
110960 Aarthi jan 23 '13 at 18:54
110959 Aarthi jan 23 '13 at 18:53
110958 Aarthi jan 23 '13 at 18:53
110957 Aarthi jan 23 '13 at 18:52
110956 Aarthi jan 23 '13 at 18:51
110955 Aarthi jan 23 '13 at 18:51
110951 Aarthi jan 23 '13 at 18:39
108698 Aarthi jan 11 '13 at 19:27
108697 Aarthi jan 11 '13 at 19:27
108695 Aarthi jan 11 '13 at 19:26
108694 Aarthi jan 11 '13 at 19:26
108693 Aarthi jan 11 '13 at 19:24
108692 Aarthi jan 11 '13 at 19:23
108687 Aarthi jan 11 '13 at 19:20
108685 Aarthi jan 11 '13 at 19:19
108680 Aarthi jan 11 '13 at 19:17
108678 Aarthi jan 11 '13 at 19:17
108672 Aarthi jan 11 '13 at 19:14
108665 Aarthi jan 11 '13 at 19:10
108662 Aarthi jan 11 '13 at 18:48
108661 Aarthi jan 11 '13 at 18:48
108659 Aarthi jan 11 '13 at 18:46
108658 Aarthi jan 11 '13 at 18:46
108657 Aarthi jan 11 '13 at 18:46
103541 Aarthi dec 7 '12 at 18:26
103535 Aarthi dec 7 '12 at 18:24
103534 Aarthi dec 7 '12 at 18:23
103419 Aarthi dec 6 '12 at 22:56
103418 Aarthi dec 6 '12 at 22:56
103416 Aarthi dec 6 '12 at 22:53
103415 Aarthi dec 6 '12 at 22:45
103414 Aarthi dec 6 '12 at 22:44
103413 Aarthi dec 6 '12 at 22:20
103412 Aarthi dec 6 '12 at 22:20
103411 Aarthi dec 6 '12 at 22:02
103410 Aarthi dec 6 '12 at 22:02
103406 Aarthi dec 6 '12 at 21:48
103405 Aarthi dec 6 '12 at 21:42
103403 Aarthi dec 6 '12 at 21:10
103402 Aarthi dec 6 '12 at 21:04
103400 Aarthi dec 6 '12 at 21:01
103399 Aarthi dec 6 '12 at 21:01
103398 Aarthi dec 6 '12 at 20:59
103397 Aarthi dec 6 '12 at 20:58
103396 Aarthi dec 6 '12 at 20:57
103395 Aarthi dec 6 '12 at 20:57
103394 Aarthi dec 6 '12 at 20:56
103393 Aarthi dec 6 '12 at 20:56
103391 Aarthi dec 6 '12 at 20:55
103385 Aarthi dec 6 '12 at 20:53
103381 Aarthi dec 6 '12 at 20:52
103150 Aarthi dec 5 '12 at 22:47
103133 Aarthi dec 5 '12 at 22:27
103131 Aarthi dec 5 '12 at 22:26
103130 Aarthi dec 5 '12 at 22:25
103129 Aarthi dec 5 '12 at 22:24
103128 Aarthi dec 5 '12 at 22:24
103125 Aarthi dec 5 '12 at 22:16
103119 Aarthi dec 5 '12 at 21:40
103118 Aarthi dec 5 '12 at 21:38
103117 Aarthi dec 5 '12 at 21:36
103115 Aarthi dec 5 '12 at 21:36
103113 Aarthi dec 5 '12 at 21:30
103112 Aarthi dec 5 '12 at 21:28
103111 Aarthi dec 5 '12 at 21:28
101760 Aarthi nov 30 '12 at 2:05
101753 Aarthi nov 30 '12 at 2:03
101752 Aarthi nov 30 '12 at 2:02
101750 Aarthi nov 30 '12 at 1:59
101749 Aarthi nov 30 '12 at 1:59
101748 Aarthi nov 30 '12 at 1:59
101747 Aarthi nov 30 '12 at 1:58
101745 Aarthi nov 30 '12 at 1:54
101744 Aarthi nov 30 '12 at 1:49
101743 Aarthi nov 30 '12 at 1:48
101742 Aarthi nov 30 '12 at 1:48
101741 Aarthi nov 30 '12 at 1:47
101740 Aarthi nov 30 '12 at 1:45
101739 Aarthi nov 30 '12 at 1:45
101738 Aarthi nov 30 '12 at 1:45
101737 Aarthi nov 30 '12 at 1:44
101736 Aarthi nov 30 '12 at 1:44
101735 Aarthi nov 30 '12 at 1:43
101734 Aarthi nov 30 '12 at 1:38
101733 Aarthi nov 30 '12 at 1:35
101732 Aarthi nov 30 '12 at 1:35
101731 Aarthi nov 30 '12 at 1:34

Enter Parameters

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