User Comments in Youtube API

0

Please login or register to vote for this query.

(click on this box to dismiss)

TeX Meta

Q&A about the site for users of TeX, LaTeX, ConTeXt, and related typesetting systems

SELECT 
    answer.Id as AnswerId,
    q.Id as QuestionId,
    answer.Body as AnswerBody,
    comment.Text as CommentText
FROM Posts as answer
JOIN (
    SELECT * FROM Posts 
    WHERE tags LIKE '%youtube-api%' 
    AND PostTypeId = 1 AND AcceptedAnswerId IS NOT NULL
) q ON answer.ParentId = q.Id
JOIN Comments as comment ON comment.PostId = answer.Id

Enter Parameters

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