Preguntas elegantes

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

WITH Answers AS
(
	/* unique answers with best score per question */
	SELECT ParentId AS Id, MAX(Score) AS Score
	FROM Posts
	WHERE PostTypeId = 2
	GROUP BY ParentId
)

SELECT
	/* questions joined with answers */
	format(Q.LastActivityDate,'dd/MM/yy') "Última Actividad",
	Q.Tags Etiquetas,
	CONCAT('http://es.stackoverflow.com/q/',Q.Id,'/127|',Q.Title) URL,
	Q.AnswerCount "Cantidad de Respuestas",
	Q.Score "Puntuaje de Pregunta",
	A.Score "Puntaje de Respuesta"

FROM Posts Q
LEFT OUTER JOIN Answers A
	ON Q.Id = A.Id
WHERE Q.PostTypeId = 1
	AND Q.AnswerCount > 0
	AND Q.AcceptedAnswerId IS NULL
	AND Q.ClosedDate IS NULL
	AND A.Score <= 0
ORDER BY A.Score            DESC,
	Q.Score            DESC,
	Q.LastActivityDate DESC

Enter Parameters

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