MD5 QplusA

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results