0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for science fiction and fantasy enthusiasts

SELECT questions.Id as [Post Link], questions.title, questions.body,
answers.body, 
questions.viewcount,questions.Tags,
questions.Score,answers.Score,questions.AnswerCount,
questions.LastActivityDate,questions.AcceptedAnswerId,
questions.CommentCount,
questions.FavoriteCount,
questions.LastEditorUserId,
questions.LastEditorDisplayName,
questions.LastEditDate,
questions.CreationDate,
questions.ClosedDate
FROM Posts questions
left JOIN Posts answers ON answers.parentid = questions.id
WHERE questions.Tags like '%<md5>%' and questions.Tags not like '%<cryptography>%'
order by questions.viewcount DESC

view current version

edited nov 11 19

created nov 11 19 anonymous