0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for serious players and enthusiasts of chess

SELECT DISTINCT

p.Id as questionId,

p.Title as questionTitle,

p.Tags,

p.Body as questionBody,

p.CreationDate as questionCreationDate,

p.AcceptedAnswerId,

p.viewCount as questionViewCount,

p.AnswerCount,

p.CommentCount as questionCommentCount,

p.Score as questionScore,

p.FavoriteCount as questionFavoriteCount,

p.OwnerUserId as questionUserId,

u.Location as questionUserLocation,

u.CreationDate as questionUserCreationDate,

u.Views as questionUserViews,

a.Id as answerId,

a.Body as answerBody,

a.OwnerUserId as answerUserId,

a.Score as answerScore,

a.CommentCount as answerCommentCount,

c.Id as commentId,

c.Text as commentText

FROM

Posts p

INNER JOIN PostTags pt ON p.Id = pt.PostId

INNER JOIN Tags t ON pt.TagId = t.Id

LEFT JOIN Users u ON u.Id = p.OwnerUserId

LEFT JOIN Posts a ON a.parentID = p.Id

LEFT JOIN Comments c ON c.PostId = p.Id

WHERE

(UPPER(t.TagName) LIKE UPPER('mockk'))

ORDER By questionId, answerId

fork query

edited aug 11

created aug 11 anonymous