SELECT p.Id AS QuestionID, p.Title AS QuestionTitle, p.Body

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

SELECT p.Id AS QuestionID, p.Title AS QuestionTitle, p.Body 
  AS QuestionBody, a.Body AS AnswerBody, p.Tags 
  AS QuestionTags, p.Score AS QuestionVotes, p.ViewCount AS QuestionViews, 
  p.CreationDate AS QuestionCreationDate, p.AnswerCount AS AnswerCount,
  p.CommentCount AS CommentCount, p.FavoriteCount AS FavoriteCount,
  p.ClosedDate AS ClosedDate

FROM Posts p, Posts a
 
WHERE p.PostTypeId = 1 AND p.AcceptedAnswerId IS NOT NULL 
  AND p.AcceptedAnswerId = a.Id
  AND p.Tags LIKE '%<unsupervised-learning>%'
  AND p.Title LIKE '%?'
  
ORDER BY p.Score DESC

Enter Parameters

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