0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for enthusiasts and power users of the Android operating system

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,
CASE WHEN Answers.DeletionDate IS NULL THEN 0 ELSE 1 END as DeletedAnswer,
Answers.ViewCount,
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)
WHERE 
Tags.TagName = 'javascript' OR 
Tags.TagName = 'python' OR
Tags.TagName = 'c' OR 
Tags.TagName = 'java'
and Answers.PostTypeId = 2 
order by NEWID(), RAND()

view current version

edited jun 19

created jun 19 anonymous