0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

SELECT TOP 50000 Id, Title, Score, ViewCount, Body, Tags, AnswerCount
FROM Posts
WHERE
  Title NOT LIKE '##ExcludeTitle##%' AND
  Title NOT LIKE '##ExcludeTitle2##%' AND
  Tags LIKE '%##TagName##%' AND
  --Tags NOT LIKE '%##ExcludeTagName##%' AND
  Score >= 0 AND
  AnswerCount >= 1 AND
  PostTypeId = 1 AND 
  CreationDate > '2019-09-01 00:00:00' 
ORDER BY
  ViewCount DESC, Score DESC;

fork query

edited jun 14

created mar 23 akalanka