Query ExpressionEngine® Answers Meta - Stack Exchange Data Explorer

Editing Query

Search for a string that occurs either in title, tags or body Posts need a minimum score of 7 and should be without code in body

edit description

Q&A about the site for administrators, end users, developers and designers for ExpressionEngine® 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

596623 SK55 apr 12 '16 at 17:11
574199 SK55 mar 16 '16 at 16:23
574086 SK55 mar 16 '16 at 12:39
574083 SK55 mar 16 '16 at 12:37
419251 SK55 jun 9 '15 at 21:59
419250 SK55 jun 9 '15 at 21:59
419249 SK55 jun 9 '15 at 21:58
419248 SK55 jun 9 '15 at 21:57
419247 SK55 jun 9 '15 at 21:56
419246 SK55 jun 9 '15 at 21:48
419245 SK55 jun 9 '15 at 21:47
419243 SK55 jun 9 '15 at 21:46
419242 SK55 jun 9 '15 at 21:46
419240 SK55 jun 9 '15 at 21:45
419239 SK55 jun 9 '15 at 21:45
419237 SK55 jun 9 '15 at 21:43
419234 SK55 jun 9 '15 at 21:41
419231 SK55 jun 9 '15 at 21:38
419229 SK55 jun 9 '15 at 21:37
419228 SK55 jun 9 '15 at 21:36
419224 SK55 jun 9 '15 at 21:34
419221 SK55 jun 9 '15 at 21:27
419219 SK55 jun 9 '15 at 21:26
419217 SK55 jun 9 '15 at 21:21
419211 SK55 jun 9 '15 at 21:11
419210 SK55 jun 9 '15 at 21:09
419209 SK55 jun 9 '15 at 21:05
419208 SK55 jun 9 '15 at 21:03
419207 SK55 jun 9 '15 at 21:02
419205 SK55 jun 9 '15 at 21:00
419204 SK55 jun 9 '15 at 20:59
419202 SK55 jun 9 '15 at 20:56
419046 SK55 jun 9 '15 at 17:36
419042 SK55 jun 9 '15 at 17:35
419036 SK55 jun 9 '15 at 17:34
418921 SK55 jun 9 '15 at 15:59
418920 SK55 jun 9 '15 at 15:58
418914 SK55 jun 9 '15 at 15:51
418913 SK55 jun 9 '15 at 15:51
418912 SK55 jun 9 '15 at 15:50
418911 SK55 jun 9 '15 at 15:50
418910 SK55 jun 9 '15 at 15:49
418909 SK55 jun 9 '15 at 15:48
418908 SK55 jun 9 '15 at 15:48
418907 SK55 jun 9 '15 at 15:44
418906 SK55 jun 9 '15 at 15:44
418905 SK55 jun 9 '15 at 15:43
418904 SK55 jun 9 '15 at 15:43
418903 SK55 jun 9 '15 at 15:42
418881 SK55 jun 9 '15 at 15:08
418878 SK55 jun 9 '15 at 14:59
418877 SK55 jun 9 '15 at 14:52
418876 SK55 jun 9 '15 at 14:51
418875 SK55 jun 9 '15 at 14:51
418874 SK55 jun 9 '15 at 14:50
418873 SK55 jun 9 '15 at 14:50
418872 SK55 jun 9 '15 at 14:50
418871 SK55 jun 9 '15 at 14:49
418870 SK55 jun 9 '15 at 14:48
418869 SK55 jun 9 '15 at 14:48
418868 SK55 jun 9 '15 at 14:47
418867 SK55 jun 9 '15 at 14:47
418866 SK55 jun 9 '15 at 14:46
418865 SK55 jun 9 '15 at 14:44
418863 SK55 jun 9 '15 at 14:37
418862 SK55 jun 9 '15 at 14:37
418861 SK55 jun 9 '15 at 14:36
418860 SK55 jun 9 '15 at 14:36
418857 SK55 jun 9 '15 at 14:23
418854 SK55 jun 9 '15 at 14:16
418853 SK55 jun 9 '15 at 14:16
418852 SK55 jun 9 '15 at 14:15
418851 SK55 jun 9 '15 at 14:14
418850 SK55 jun 9 '15 at 14:13
418849 SK55 jun 9 '15 at 14:12
418848 SK55 jun 9 '15 at 14:11
418747 SK55 jun 9 '15 at 11:37
418433 SK55 jun 8 '15 at 16:54
409626 SK55 may 19 '15 at 18:08
409625 SK55 may 19 '15 at 18:08
409624 SK55 may 19 '15 at 18:07
409623 SK55 may 19 '15 at 18:07
409622 SK55 may 19 '15 at 18:06
409621 SK55 may 19 '15 at 18:05
409620 SK55 may 19 '15 at 18:03
409619 SK55 may 19 '15 at 18:01
409618 SK55 may 19 '15 at 18:00
409617 SK55 may 19 '15 at 17:59
409616 SK55 may 19 '15 at 17:58
409614 SK55 may 19 '15 at 17:55
409611 SK55 may 19 '15 at 17:52
409610 SK55 may 19 '15 at 17:51
409609 SK55 may 19 '15 at 17:50
409607 SK55 may 19 '15 at 17:49
409606 SK55 may 19 '15 at 17:48
409596 SK55 may 19 '15 at 17:27
409595 SK55 may 19 '15 at 17:26
409594 SK55 may 19 '15 at 17:26
409593 SK55 may 19 '15 at 17:25
409592 SK55 may 19 '15 at 17:25
409591 SK55 may 19 '15 at 17:24
409590 SK55 may 19 '15 at 17:24
409589 SK55 may 19 '15 at 17:24
409588 SK55 may 19 '15 at 17:23
409587 SK55 may 19 '15 at 17:23
409586 SK55 may 19 '15 at 17:23
409585 SK55 may 19 '15 at 17:22
409584 SK55 may 19 '15 at 17:22
409583 SK55 may 19 '15 at 17:22
409582 SK55 may 19 '15 at 17:22
409581 SK55 may 19 '15 at 17:21
409580 SK55 may 19 '15 at 17:20
409579 SK55 may 19 '15 at 17:20
409578 SK55 may 19 '15 at 17:20
409577 SK55 may 19 '15 at 17:19
409576 SK55 may 19 '15 at 17:19
409575 SK55 may 19 '15 at 17:19
409574 SK55 may 19 '15 at 17:18
409573 SK55 may 19 '15 at 17:18
409572 SK55 may 19 '15 at 17:17
409571 SK55 may 19 '15 at 17:16
409570 SK55 may 19 '15 at 17:16
409569 SK55 may 19 '15 at 17:15
409568 SK55 may 19 '15 at 17:12
409567 SK55 may 19 '15 at 17:12
409566 SK55 may 19 '15 at 17:12
409564 SK55 may 19 '15 at 17:11
409562 SK55 may 19 '15 at 17:10
409560 SK55 may 19 '15 at 17:10
409559 SK55 may 19 '15 at 17:10
409557 SK55 may 19 '15 at 17:09
409556 SK55 may 19 '15 at 17:09
409555 SK55 may 19 '15 at 17:08
409554 SK55 may 19 '15 at 17:08
409553 SK55 may 19 '15 at 17:07
409552 SK55 may 19 '15 at 17:04
409551 SK55 may 19 '15 at 17:04
409550 SK55 may 19 '15 at 17:03
409549 SK55 may 19 '15 at 17:03
409548 SK55 may 19 '15 at 17:02
409547 SK55 may 19 '15 at 17:02
409546 SK55 may 19 '15 at 17:02
409544 SK55 may 19 '15 at 17:02
409543 SK55 may 19 '15 at 17:01
409542 SK55 may 19 '15 at 17:01
409541 SK55 may 19 '15 at 17:01
409540 SK55 may 19 '15 at 17:00
409539 SK55 may 19 '15 at 17:00
409538 SK55 may 19 '15 at 16:59
409537 SK55 may 19 '15 at 16:59
409536 SK55 may 19 '15 at 16:59
409535 SK55 may 19 '15 at 16:58
409534 SK55 may 19 '15 at 16:58
409533 SK55 may 19 '15 at 16:57
409532 SK55 may 19 '15 at 16:57
409531 SK55 may 19 '15 at 16:57
409530 SK55 may 19 '15 at 16:56
409529 SK55 may 19 '15 at 16:56
409528 SK55 may 19 '15 at 16:56
409527 SK55 may 19 '15 at 16:54
409526 SK55 may 19 '15 at 16:53
409525 SK55 may 19 '15 at 16:46
409524 SK55 may 19 '15 at 16:46
409523 SK55 may 19 '15 at 16:46
409522 SK55 may 19 '15 at 16:45
409521 SK55 may 19 '15 at 16:45
409520 SK55 may 19 '15 at 16:44
409518 SK55 may 19 '15 at 16:44
409517 SK55 may 19 '15 at 16:43
409516 SK55 may 19 '15 at 16:43
409515 SK55 may 19 '15 at 16:42
409513 SK55 may 19 '15 at 16:41
409512 SK55 may 19 '15 at 16:41
409511 SK55 may 19 '15 at 16:40
409510 SK55 may 19 '15 at 16:40
409509 SK55 may 19 '15 at 16:39
409508 SK55 may 19 '15 at 16:39
409507 SK55 may 19 '15 at 16:38
409506 SK55 may 19 '15 at 16:38
409505 SK55 may 19 '15 at 16:37
408591 SK55 may 18 '15 at 22:10
408584 SK55 may 18 '15 at 22:06
408583 SK55 may 18 '15 at 22:05
408582 SK55 may 18 '15 at 22:05
408470 SK55 may 18 '15 at 20:11
408379 SK55 may 18 '15 at 18:51
408376 SK55 may 18 '15 at 18:50
408375 SK55 may 18 '15 at 18:50
408374 SK55 may 18 '15 at 18:49
408373 SK55 may 18 '15 at 18:49
408370 SK55 may 18 '15 at 18:44
408369 SK55 may 18 '15 at 18:44
408368 SK55 may 18 '15 at 18:43
408366 SK55 may 18 '15 at 18:42
408328 SK55 may 18 '15 at 18:02
408327 SK55 may 18 '15 at 17:58
408326 SK55 may 18 '15 at 17:58
408325 SK55 may 18 '15 at 17:58
408324 SK55 may 18 '15 at 17:57
408323 SK55 may 18 '15 at 17:57
408321 SK55 may 18 '15 at 17:56
406380 SK55 may 13 '15 at 10:38
406379 SK55 may 13 '15 at 10:36
406377 SK55 may 13 '15 at 10:33
406376 SK55 may 13 '15 at 10:32
406369 SK55 may 13 '15 at 10:25
406368 SK55 may 13 '15 at 10:24
406367 SK55 may 13 '15 at 10:22
405728 SK55 may 12 '15 at 11:24
405727 SK55 may 12 '15 at 11:23
405726 SK55 may 12 '15 at 11:22
405725 SK55 may 12 '15 at 11:21
405724 SK55 may 12 '15 at 11:21
405723 SK55 may 12 '15 at 11:20
405722 SK55 may 12 '15 at 11:19
405721 SK55 may 12 '15 at 11:19
405720 SK55 may 12 '15 at 11:18
405719 SK55 may 12 '15 at 11:18
405718 SK55 may 12 '15 at 11:17
405717 SK55 may 12 '15 at 11:17
405716 SK55 may 12 '15 at 11:16
405715 SK55 may 12 '15 at 11:15
405714 SK55 may 12 '15 at 11:14
405101 SK55 may 11 '15 at 10:20
405096 SK55 may 11 '15 at 10:12
405072 SK55 may 11 '15 at 9:57
405071 SK55 may 11 '15 at 9:55
405069 SK55 may 11 '15 at 9:54
405068 SK55 may 11 '15 at 9:52
381936 SK55 mar 29 '15 at 15:19
381923 SK55 mar 29 '15 at 15:07
381916 SK55 mar 29 '15 at 14:49
381899 SK55 mar 29 '15 at 13:49
381897 SK55 mar 29 '15 at 13:47
381895 SK55 mar 29 '15 at 13:44
381882 SK55 mar 29 '15 at 12:26
381881 SK55 mar 29 '15 at 12:25
381880 SK55 mar 29 '15 at 12:25
381879 SK55 mar 29 '15 at 12:24
381878 SK55 mar 29 '15 at 12:23
381877 SK55 mar 29 '15 at 12:23
381876 SK55 mar 29 '15 at 12:23
381875 SK55 mar 29 '15 at 12:20
381874 SK55 mar 29 '15 at 12:13
381869 SK55 mar 29 '15 at 12:04
381867 SK55 mar 29 '15 at 12:03
381866 SK55 mar 29 '15 at 12:02
381865 SK55 mar 29 '15 at 12:01
381863 SK55 mar 29 '15 at 11:59
381859 SK55 mar 29 '15 at 11:55
381858 SK55 mar 29 '15 at 11:51
381857 SK55 mar 29 '15 at 11:51
381849 SK55 mar 29 '15 at 11:41
381848 SK55 mar 29 '15 at 11:39
381847 SK55 mar 29 '15 at 11:38
381845 SK55 mar 29 '15 at 11:36
381843 SK55 mar 29 '15 at 11:35
381840 SK55 mar 29 '15 at 11:31

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