0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for enthusiasts and scholars of mythology and folklore

SELECT
    q.Id AS QuestionId,
    q.Title AS QuestionTitle,
    q.Body AS QuestionBody,
    q.AcceptedAnswerId,
    q.AnswerCount,
    q.CommentCount,
    q.CommunityOwnedDate,
    q.CreationDate AS QuestionCreationDate,
    q.FavoriteCount,
    q.LastActivityDate AS QuestionLastActivityDate,
    q.LastEditDate AS QuestionLastEditDate,
    q.LastEditorDisplayName AS QuestionLastEditorDisplayName,
    q.LastEditorUserId AS QuestionLastEditorUserId,
    q.OwnerDisplayName AS QuestionOwnerDisplayName,
    q.OwnerUserId AS QuestionOwnerUserId,
    q.Score AS QuestionScore,
    q.Tags AS QuestionTags,
    q.ViewCount AS QuestionViewCount,
    a.Id AS AnswerId,
    a.CreationDate AS AnswerCreationDate,
    a.Score AS AnswerScore,
    a.Body AS AnswerBody
FROM
    Posts q
INNER JOIN
    Posts a ON q.AcceptedAnswerId = a.Id
WHERE
    q.PostTypeId = 1
    AND a.PostTypeId = 2
    AND q.Id IN (2517, 4944)  -- 여기에서 지정한 질문 ID들만 선택
ORDER BY
    q.CreationDate;

fork query

created oct 22 anonymous