Todas perguntas respondidas por você mesmo

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow em Português

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results