0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

SELECT questions.Id as [post_link], questions.title as [title], questions.body as [body_question],
answers.body as [body_answer], 
questions.viewcount as [viewcount],questions.Tags as [tags],
questions.Score as [score],answers.Score as [score_answer],questions.AnswerCount as [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 '%<x509>%' and questions.Tags not like '%<cryptography>%'
order by questions.viewcount DESC

fork query

edited nov 11 19

created nov 11 19 anonymous