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 c.text, c.id AS [Comment Link], creationdate FROM comments c WHERE c.text LIKE '%##keyword1##%' AND len(c.text) <= 100 ORDER BY creationdate 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 (250)
AnswerCount
int
CommentCount
int
FavoriteCount
int
ClosedDate
datetime
CommunityOwnedDate
datetime
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 (30)
UserId
int
Badges
Id
int
UserId
int
Name
nvarchar (50)
Date
datetime
Class
tinyint
TagBased
bit
CloseAsOffTopicReasonTypes
Id
smallint
IsUniversal
bit
MarkdownMini
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)
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
PostTags
PostId
int
TagId
int
PostTypes
Id
tinyint
Name
nvarchar (50)
ReviewRejectionReasons
Id
tinyint
Name
nvarchar (100)
Description
nvarchar (300)
PostTypeId
tinyint
ReviewTaskResults
Id
int
ReviewTaskId
int
ReviewTaskResultTypeId
tinyint
CreationDate
date
RejectionReasonId
tinyint
Comment
nvarchar (150)
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
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
1287624
anonymous
may 5 at 17:36
1265467
HMH
apr 6 at 20:34
1251032
Shree
mar 21 at 4:19
1251022
Shree
mar 21 at 4:07
1251020
Shree
mar 21 at 4:07
1212570
Shree
feb 9 at 3:19
1212569
Shree
feb 9 at 3:18
1212567
Shree
feb 9 at 3:18
1212566
Shree
feb 9 at 3:16
1212565
Shree
feb 9 at 3:16
1212563
Shree
feb 9 at 3:15
1212560
Shree
feb 9 at 3:14
1211474
Shree
feb 8 at 4:48
1211473
Shree
feb 8 at 4:48
1211472
Shree
feb 8 at 4:48
1211471
Shree
feb 8 at 4:47
1210772
Shree
feb 7 at 6:21
1204966
Shree
jan 28 at 4:31
1202793
Shree
jan 24 at 8:26
1202761
Shree
jan 24 at 6:39
1202745
Shree
jan 24 at 5:36
1202744
Shree
jan 24 at 5:29
1201227
Shree
jan 21 at 11:36
1201224
Shree
jan 21 at 11:26
1201222
Shree
jan 21 at 11:21
1110299
Shree
sep 2 '18 at 4:58
1110298
Shree
sep 2 '18 at 4:57
1105846
Shree
aug 24 '18 at 12:19
1105833
Shree
aug 24 '18 at 11:35
1105832
Shree
aug 24 '18 at 11:34
1105831
Shree
aug 24 '18 at 11:29
1095744
Shree
aug 7 '18 at 10:00
1095730
Shree
aug 7 '18 at 9:25
1095729
Shree
aug 7 '18 at 9:24
1088942
Shree
jul 27 '18 at 6:28
1088941
Shree
jul 27 '18 at 6:28
1088940
Shree
jul 27 '18 at 6:27
1088396
Shree
jul 26 '18 at 11:55
1088366
Shree
jul 26 '18 at 11:06
1088365
Shree
jul 26 '18 at 11:06
1088352
Shree
jul 26 '18 at 10:21
1088351
Shree
jul 26 '18 at 10:21
1088338
Shree
jul 26 '18 at 9:09
1088336
Shree
jul 26 '18 at 9:09
1088334
Shree
jul 26 '18 at 9:09
1088333
Shree
jul 26 '18 at 9:08
1087813
Shree
jul 25 '18 at 9:03
1087767
Shree
jul 25 '18 at 4:17
1087722
Shree
jul 25 '18 at 3:25
1081455
Shree
jul 16 '18 at 6:37
1077371
Shree
jul 9 '18 at 11:24
1072987
Shree
jun 29 '18 at 11:45
1072986
Shree
jun 29 '18 at 11:39
1072219
Shree
jun 28 '18 at 7:57
1072218
Shree
jun 28 '18 at 7:56
1072172
Shree
jun 28 '18 at 3:13
1072170
Shree
jun 28 '18 at 3:13
1071714
Shree
jun 27 '18 at 6:46
1071711
Shree
jun 27 '18 at 5:42
1071710
Shree
jun 27 '18 at 4:58
1071709
Shree
jun 27 '18 at 4:45
1070331
Shree
jun 24 '18 at 2:31
1070330
Shree
jun 24 '18 at 1:53
1070092
Shree
jun 23 '18 at 3:03
1070091
Shree
jun 23 '18 at 3:02
1069618
Shree
jun 22 '18 at 8:48
1069610
Shree
jun 22 '18 at 8:29
1069609
Shree
jun 22 '18 at 8:27
1069565
Shree
jun 22 '18 at 5:52
1069545
Shree
jun 22 '18 at 4:33
1069544
Shree
jun 22 '18 at 4:32
1069543
Shree
jun 22 '18 at 4:30
1069541
Shree
jun 22 '18 at 4:15
1069512
Shree
jun 22 '18 at 3:45
1069511
Shree
jun 22 '18 at 3:44
1069510
Shree
jun 22 '18 at 3:44
1069509
Shree
jun 22 '18 at 3:43
1069508
Shree
jun 22 '18 at 3:43
1069507
Shree
jun 22 '18 at 3:04
1069506
Shree
jun 22 '18 at 3:03
1069505
Shree
jun 22 '18 at 3:02
1069504
Shree
jun 22 '18 at 3:00
1069503
Shree
jun 22 '18 at 2:59
1068187
Shree
jun 20 '18 at 5:47
1068186
Shree
jun 20 '18 at 5:47
1068185
Shree
jun 20 '18 at 5:45
permalink
hide sidebar
Enter Parameters
Run Query
Cancel
Options:
Text-only results
Include execution plan
Switch sites:
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