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()