Query Physical Fitness - Stack Exchange Data Explorer

Editing Query

edit description

Q&A for physical fitness professionals, athletes, trainers, and those providing health-related needs

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)

MarkdownPrivilegedUserGuidance

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)
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

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

114907 hairboat feb 6 '13 at 19:59
114854 hairboat feb 6 '13 at 19:16
114853 hairboat feb 6 '13 at 19:15
114852 hairboat feb 6 '13 at 19:14
114851 hairboat feb 6 '13 at 19:14
114850 hairboat feb 6 '13 at 19:14
114849 hairboat feb 6 '13 at 19:13
114565 hairboat feb 6 '13 at 15:20
114564 hairboat feb 6 '13 at 15:19
114563 hairboat feb 6 '13 at 15:18
114562 hairboat feb 6 '13 at 15:18
114561 hairboat feb 6 '13 at 15:17
114560 hairboat feb 6 '13 at 15:17
114559 hairboat feb 6 '13 at 15:17
114558 hairboat feb 6 '13 at 15:15
114555 hairboat feb 6 '13 at 14:41
114553 hairboat feb 6 '13 at 14:41
114552 hairboat feb 6 '13 at 14:40
114376 hairboat feb 5 '13 at 21:40
114375 hairboat feb 5 '13 at 21:39
112127 hairboat jan 29 '13 at 18:08
112126 hairboat jan 29 '13 at 18:05
112125 hairboat jan 29 '13 at 18:04
112124 hairboat jan 29 '13 at 18:04
112123 hairboat jan 29 '13 at 18:03
112122 hairboat jan 29 '13 at 18:02
112121 hairboat jan 29 '13 at 18:02
112021 hairboat jan 28 '13 at 16:24
112020 hairboat jan 28 '13 at 16:23
112019 hairboat jan 28 '13 at 16:23
112018 hairboat jan 28 '13 at 16:22
112017 hairboat jan 28 '13 at 16:13
112016 hairboat jan 28 '13 at 16:12
112015 hairboat jan 28 '13 at 16:10
112014 hairboat jan 28 '13 at 16:09
112013 hairboat jan 28 '13 at 16:09
112012 hairboat jan 28 '13 at 16:09
112011 hairboat jan 28 '13 at 16:09
112010 hairboat jan 28 '13 at 16:09
112009 hairboat jan 28 '13 at 16:07
112008 hairboat jan 28 '13 at 16:07
112007 hairboat jan 28 '13 at 16:07
111682 hairboat jan 25 '13 at 17:05
111681 hairboat jan 25 '13 at 17:04
111680 hairboat jan 25 '13 at 17:04
111679 hairboat jan 25 '13 at 17:04
111678 hairboat jan 25 '13 at 17:03
111677 hairboat jan 25 '13 at 17:03
111676 hairboat jan 25 '13 at 17:03
111675 hairboat jan 25 '13 at 17:02
111674 hairboat jan 25 '13 at 17:02
111673 hairboat jan 25 '13 at 17:02
111672 hairboat jan 25 '13 at 17:00
111562 hairboat jan 24 '13 at 20:42
111549 hairboat jan 24 '13 at 20:38
111548 hairboat jan 24 '13 at 20:37
111542 hairboat jan 24 '13 at 20:34
111541 hairboat jan 24 '13 at 20:32
111539 hairboat jan 24 '13 at 20:26
111258 hairboat jan 23 '13 at 21:13
111253 hairboat jan 23 '13 at 21:12
111251 hairboat jan 23 '13 at 21:11
111248 hairboat jan 23 '13 at 21:10
111246 hairboat jan 23 '13 at 21:10
111245 hairboat jan 23 '13 at 21:10
111242 hairboat jan 23 '13 at 21:10
111238 hairboat jan 23 '13 at 21:09
111235 hairboat jan 23 '13 at 21:08
111233 hairboat jan 23 '13 at 21:08
111227 hairboat jan 23 '13 at 21:04
111226 hairboat jan 23 '13 at 21:04
111216 hairboat jan 23 '13 at 21:01
111215 hairboat jan 23 '13 at 21:00
111198 hairboat jan 23 '13 at 20:53
111197 hairboat jan 23 '13 at 20:53
111195 hairboat jan 23 '13 at 20:51
111194 hairboat jan 23 '13 at 20:51
111192 hairboat jan 23 '13 at 20:51
111189 hairboat jan 23 '13 at 20:50
111184 hairboat jan 23 '13 at 20:50
111166 hairboat jan 23 '13 at 20:47
111157 hairboat jan 23 '13 at 20:46
111149 hairboat jan 23 '13 at 20:44
111147 hairboat jan 23 '13 at 20:44
111145 hairboat jan 23 '13 at 20:43
111144 hairboat jan 23 '13 at 20:43
111143 hairboat jan 23 '13 at 20:42
111142 hairboat jan 23 '13 at 20:42
111139 hairboat jan 23 '13 at 20:42
111130 hairboat jan 23 '13 at 20:41
111109 hairboat jan 23 '13 at 20:38
111102 hairboat jan 23 '13 at 20:37
111099 hairboat jan 23 '13 at 20:37
111096 hairboat jan 23 '13 at 20:36
111094 hairboat jan 23 '13 at 20:36
111089 hairboat jan 23 '13 at 20:36
111088 hairboat jan 23 '13 at 20:35
111085 hairboat jan 23 '13 at 20:34
111076 hairboat jan 23 '13 at 20:33
111072 hairboat jan 23 '13 at 20:33
111053 hairboat jan 23 '13 at 20:27
111049 hairboat jan 23 '13 at 20:26
111042 hairboat jan 23 '13 at 20:25
111033 hairboat jan 23 '13 at 20:24
111011 hairboat jan 23 '13 at 20:18
111010 hairboat jan 23 '13 at 20:18
111007 hairboat jan 23 '13 at 20:16
110991 hairboat jan 23 '13 at 20:13
110989 hairboat jan 23 '13 at 20:13

Enter Parameters

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