Stack Exchange
log in
help
Stack Exchange Data Explorer
Home
Queries
Users
Compose Query
Editing Query
edit description
Q&A for professionals, academics, and students working within the systems development life cycle
select top 50 PostId as [Post Link] from PendingFlags where CloseReasonTypeId = 103 group by PostId having count(1) = 2 order by PostId desc;
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
257218
Eat A Peach
jun 3 '14 at 8:45
256840
Eat A Peach
jun 2 '14 at 9:16
256778
Eat A Peach
jun 2 '14 at 8:04
256776
Eat A Peach
jun 2 '14 at 6:44
256775
Eat A Peach
jun 2 '14 at 6:43
256774
Eat A Peach
jun 2 '14 at 6:39
256773
Eat A Peach
jun 2 '14 at 6:36
256772
Eat A Peach
jun 2 '14 at 6:34
256770
Eat A Peach
jun 2 '14 at 6:33
256769
Eat A Peach
jun 2 '14 at 6:31
256768
Eat A Peach
jun 2 '14 at 6:29
256767
Eat A Peach
jun 2 '14 at 6:29
185689
Eat A Peach
nov 25 '13 at 5:43
172444
Eat A Peach
oct 1 '13 at 10:04
172443
Eat A Peach
oct 1 '13 at 10:03
172442
Eat A Peach
oct 1 '13 at 10:02
172441
Eat A Peach
oct 1 '13 at 10:02
172440
Eat A Peach
oct 1 '13 at 10:02
172439
Eat A Peach
oct 1 '13 at 10:01
172438
Eat A Peach
oct 1 '13 at 9:54
172437
Eat A Peach
oct 1 '13 at 9:54
169306
Eat A Peach
sep 18 '13 at 8:11
169305
Eat A Peach
sep 18 '13 at 8:10
169304
Eat A Peach
sep 18 '13 at 8:04
169302
Eat A Peach
sep 18 '13 at 8:00
169301
Eat A Peach
sep 18 '13 at 8:00
169300
Eat A Peach
sep 18 '13 at 7:57
168832
Eat A Peach
sep 17 '13 at 6:36
168830
Eat A Peach
sep 17 '13 at 6:20
168829
Eat A Peach
sep 17 '13 at 6:20
168828
Eat A Peach
sep 17 '13 at 6:19
168827
Eat A Peach
sep 17 '13 at 6:17
168825
Eat A Peach
sep 17 '13 at 6:11
168824
Eat A Peach
sep 17 '13 at 6:10
168823
Eat A Peach
sep 17 '13 at 6:06
168822
Eat A Peach
sep 17 '13 at 6:06
168821
Eat A Peach
sep 17 '13 at 6:06
168577
Eat A Peach
sep 16 '13 at 5:14
168576
Eat A Peach
sep 16 '13 at 5:14
168574
Eat A Peach
sep 16 '13 at 5:13
168573
Eat A Peach
sep 16 '13 at 5:13
168572
Eat A Peach
sep 16 '13 at 5:11
168571
Eat A Peach
sep 16 '13 at 5:08
168570
Eat A Peach
sep 16 '13 at 5:08
164946
Eat A Peach
sep 3 '13 at 9:44
164945
Eat A Peach
sep 3 '13 at 9:40
164944
Eat A Peach
sep 3 '13 at 9:37
164943
Eat A Peach
sep 3 '13 at 9:35
164941
Eat A Peach
sep 3 '13 at 9:31
164940
Eat A Peach
sep 3 '13 at 9:30
164939
Eat A Peach
sep 3 '13 at 9:29
164602
Eat A Peach
sep 2 '13 at 9:22
164601
Eat A Peach
sep 2 '13 at 9:21
164600
Eat A Peach
sep 2 '13 at 9:21
164599
Eat A Peach
sep 2 '13 at 9:20
164598
Eat A Peach
sep 2 '13 at 9:19
164597
Eat A Peach
sep 2 '13 at 9:18
164596
Eat A Peach
sep 2 '13 at 9:17
164595
Eat A Peach
sep 2 '13 at 9:13
164594
Eat A Peach
sep 2 '13 at 9:11
164593
Eat A Peach
sep 2 '13 at 9:11
164592
Eat A Peach
sep 2 '13 at 9:07
164591
Eat A Peach
sep 2 '13 at 9:06
164590
Eat A Peach
sep 2 '13 at 9:05
164589
Eat A Peach
sep 2 '13 at 9:04
164588
Eat A Peach
sep 2 '13 at 9:04
164587
Eat A Peach
sep 2 '13 at 9:00
164585
Eat A Peach
sep 2 '13 at 8:44
164584
Eat A Peach
sep 2 '13 at 8:44
164583
Eat A Peach
sep 2 '13 at 8:41
164582
Eat A Peach
sep 2 '13 at 8:39
164581
Eat A Peach
sep 2 '13 at 8:39
164580
Eat A Peach
sep 2 '13 at 8:38
164579
Eat A Peach
sep 2 '13 at 8:38
164578
Eat A Peach
sep 2 '13 at 8:37
164577
Eat A Peach
sep 2 '13 at 8:36
164576
Eat A Peach
sep 2 '13 at 8:32
164031
Eat A Peach
aug 30 '13 at 9:04
164030
Eat A Peach
aug 30 '13 at 9:02
164029
Eat A Peach
aug 30 '13 at 9:01
164028
Eat A Peach
aug 30 '13 at 9:01
164027
Eat A Peach
aug 30 '13 at 8:52
164026
Eat A Peach
aug 30 '13 at 8:49
164025
Eat A Peach
aug 30 '13 at 8:48
164024
Eat A Peach
aug 30 '13 at 8:48
164021
Eat A Peach
aug 30 '13 at 8:35
164020
Eat A Peach
aug 30 '13 at 8:35
164019
Eat A Peach
aug 30 '13 at 8:34
164018
Eat A Peach
aug 30 '13 at 8:33
164017
Eat A Peach
aug 30 '13 at 8:30
164015
Eat A Peach
aug 30 '13 at 8:29
164014
Eat A Peach
aug 30 '13 at 8:28
164013
Eat A Peach
aug 30 '13 at 8:27
164012
Eat A Peach
aug 30 '13 at 8:27
164011
Eat A Peach
aug 30 '13 at 8:26
164010
Eat A Peach
aug 30 '13 at 8:26
164009
Eat A Peach
aug 30 '13 at 8:26
164008
Eat A Peach
aug 30 '13 at 8:17
164007
Eat A Peach
aug 30 '13 at 8:14
164006
Eat A Peach
aug 30 '13 at 8:06
163928
Eat A Peach
aug 30 '13 at 6:42
163926
Eat A Peach
aug 30 '13 at 6:41
163925
Eat A Peach
aug 30 '13 at 6:41
163923
Eat A Peach
aug 30 '13 at 6:41
163919
Eat A Peach
aug 30 '13 at 6:35
163914
Eat A Peach
aug 30 '13 at 6:33
163910
Eat A Peach
aug 30 '13 at 6:31
163821
Eat A Peach
aug 30 '13 at 5:20
163820
Eat A Peach
aug 30 '13 at 5:17
163819
Eat A Peach
aug 30 '13 at 5:16
163818
Eat A Peach
aug 30 '13 at 5:14
163817
Eat A Peach
aug 30 '13 at 5:11
163816
Eat A Peach
aug 30 '13 at 5:08
163815
Eat A Peach
aug 30 '13 at 5:04
163814
Eat A Peach
aug 30 '13 at 5:04
163813
Eat A Peach
aug 30 '13 at 5:03
163812
Eat A Peach
aug 30 '13 at 5:03
163811
Eat A Peach
aug 30 '13 at 5:03
163810
Eat A Peach
aug 30 '13 at 5:02
163809
Eat A Peach
aug 30 '13 at 5:02
163808
Eat A Peach
aug 30 '13 at 5:01
163807
Eat A Peach
aug 30 '13 at 4:52
163806
Eat A Peach
aug 30 '13 at 4:50
163805
Eat A Peach
aug 30 '13 at 4:47
163804
Eat A Peach
aug 30 '13 at 4:46
163803
Eat A Peach
aug 30 '13 at 4:45
163802
Eat A Peach
aug 30 '13 at 4:44
163801
Eat A Peach
aug 30 '13 at 4:43
163660
Eat A Peach
aug 29 '13 at 7:46
163654
Eat A Peach
aug 29 '13 at 6:16
163652
Eat A Peach
aug 29 '13 at 6:12
163650
Eat A Peach
aug 29 '13 at 6:11
163649
Eat A Peach
aug 29 '13 at 6:10
163648
Eat A Peach
aug 29 '13 at 6:08
163647
Eat A Peach
aug 29 '13 at 6:05
163645
Eat A Peach
aug 29 '13 at 6:01
163300
Eat A Peach
aug 28 '13 at 10:37
163299
Eat A Peach
aug 28 '13 at 10:36
163297
Eat A Peach
aug 28 '13 at 10:36
163293
Eat A Peach
aug 28 '13 at 10:31
163291
Eat A Peach
aug 28 '13 at 10:29
163290
Eat A Peach
aug 28 '13 at 10:27
163286
Eat A Peach
aug 28 '13 at 10:18
163282
Eat A Peach
aug 28 '13 at 10:16
163065
Eat A Peach
aug 27 '13 at 5:07
163061
Eat A Peach
aug 27 '13 at 4:43
160023
Eat A Peach
aug 16 '13 at 11:18
160022
Eat A Peach
aug 16 '13 at 11:17
160021
Eat A Peach
aug 16 '13 at 11:16
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