Questions

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 top 60000
    q.Id AS QuestionId,
    q.Title AS QuestionTitle,
    q.Body AS QuestionBody,
    a.Id AS AnswerId,
    a.Body AS AnswerBody,
    a.Score as Score
FROM 
    Posts q
JOIN 
    Posts a ON q.AcceptedAnswerId = a.Id
WHERE 
    q.PostTypeId = 1 -- Perguntas
    AND a.PostTypeId = 2 -- Respostas
    AND q.AcceptedAnswerId IS NOT NULL -- Perguntas com respostas aceitas

Enter Parameters

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