0

Please login or register to vote for this query.

(click on this box to dismiss)

Perguntas e respostas para programadores profissionais e entusiastas

DECLARE @UserId int = ##UserId##

SELECT QUESTION.ID AS [Post Link], QUESTION.SCORE AS VOTO_NA_PERGUNTA, ANSWER.SCORE AS VOTO_NA_RESPOSTA, QUESTION.ANSWERCOUNT FROM POSTS AS QUESTION
INNER JOIN POSTS AS ANSWER ON ANSWER.PARENTID = QUESTION.ID
INNER JOIN USERS AS USERS ON USERS.ID = QUESTION.OWNERUSERID
WHERE QUESTION.OWNERUSERID = ANSWER.OWNERUSERID AND USERS.ID = @UserId
ORDER BY QUESTION.CREATIONDATE DESC

fork query

edited feb 9 17

created feb 9 17 Marcelo Bonifazio