Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática
SELECT TOP 5 q.Id, q.CreationDate, q.OwnerUserId, q.AnswerCount, q.ViewCount, q.CommentCount, q.FavoriteCount, q.Tags, q.Score, q.Title, q.Body, qh.PostHistoryTypeId, qh.Text FROM Posts q JOIN PostHistory qh ON (q.Id = qh.PostId) WHERE q.PostTypeId = 1 AND -- Return questions q.ClosedDate IS NULL AND -- that hasn't been closed qh.PostHistoryTypeId in (1, 2, 3) -- and retrieving initial title, body and tags