Testing

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles Meta

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

SELECT TOP 20
    Q.Id AS [Question Id],
    Q.Title AS [Question Title],
    Q.CreationDate AS [Question Creation Date],
    A.Id AS [Answer Id],
    A.Body AS [Answer Body],
    A.CreationDate AS [Answer Creation Date]
FROM
    Posts Q
JOIN
    Posts A ON Q.AcceptedAnswerId = A.Id
WHERE
    Q.PostTypeId = 1 -- Question
    AND A.PostTypeId = 2 -- Answer
    AND EXISTS (
        SELECT
            *
        FROM
            PostTags
        WHERE
            PostId = Q.Id
            AND TagId IN (
                SELECT
                    Id
                FROM
                    Tags
                WHERE
                    TagName IN ('javascript', 'typescript', 'ecma')
            )
    )
ORDER BY
    Q.CreationDate DESC;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results