MD5 QplusA

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

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 '%<encryption>%' and questions.Tags not like '%<cryptography>%'
order by questions.viewcount DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results