Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Vegetarianism

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

SELECT top 50000
    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 meta site
loading Hold tight while we fetch your results