SELECT top 5000 Tags.TagName, answers.body as Answer_Body...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

SELECT top 5000
Tags.TagName,
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
FROM 
  Posts AS Answers
  INNER JOIN Posts Questions ON (Answers.ParentId = Questions.Id)
  INNER JOIN PostTags ON (Questions.Id = PostTags.PostId)
  INNER JOIN Tags ON (PostTags.TagId = Tags.Id)
  ----INNER JOIN OwnerUserId ON (OwnerUserId = Users.Reputation)

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