SELECT top 50 Tags.TagName, Questions.id [Post Link], ans...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

SELECT top 50
Tags.TagName,
Questions.id [Post Link],
answers.body as Answer_Body,
CASE WHEN Answers.LastEditDate IS NULL THEN 0 ELSE 1 END as Edited_answeryn,
Answers.CommentCount,
Answers.Score,
CASE WHEN Questions.AcceptedAnswerId = answers.id THEN 1 ELSE 0 END as Accepted_answeryn,
Users.Reputation
FROM 
  Posts AS Answers
  INNER JOIN Posts Questions ON (Answers.ParentId = Questions.Id)
  INNER JOIN Users ON (Users.Id = Answers.OwnerUserId)
  INNER JOIN PostTags ON (Questions.Id = PostTags.PostId)
  INNER JOIN Tags ON (PostTags.TagId = Tags.Id)
  

WHERE 
Tags.TagName = 'javascript' OR 
Tags.TagName = 'python' OR
Tags.TagName = 'c' OR 
Tags.TagName = 'java'
and Answers.PostTypeId = 2 
order by NEWID(), RAND()

Enter Parameters

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