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