Searching for bad Minecraft questions on Gaming.SE
The use of the Tags field on the Post is a poor choice for the query. It relies on a table scan, which is slow, because it has to check each question. Note, you can use the &lt; and &gt; characters to identify tag start and end values in the Tags column, but, as I say, don't use that column.

Instead, you should do a join with the PostTags and Tags tables. Using a CTE to simplify that query makes sense.

I really dislike the all-caps style of SQL, but realize that there is no standard. If you can change standards, please use lower-case for keywords... it makes the column and table names much easier to see (and those are the important parts). Still, you get +1 for being consistent in your capitalization. Consistency is really important, and you nailed it.

Note that the Posts table has no deleted posts, none. There's no need to check the DeletedDate at all.

So, joining Tags to PostTags gets you minecraft-tagged posts. Joining that to Posts gets you the ones you can test scores and closures on.

Here are unclosed, low-scoring, minecraft-related posts....:

WITH mctags AS (
  SELECT Id AS tid
  FROM Tags
  WHERE TagName LIKE 'minecraft%'
), mcqs AS (
  SELECT DISTINCT PostId
  FROM PostTags INNER JOIN mctags ON TagId = tid
)
SELECT
    Id AS [Post Link],
    OwnerUserId AS [User Link],
    Tags,
    Score
FROM Posts
INNER JOIN mcqs ON Id = PostId
WHERE Score &lt;= -1
  AND ClosedDate IS NULL
  AND PostTypeId = 1


Note, I have tried to continue using your all-caps keywords.... despite myself ;-)

Hmmm, some aditional notes:


your text says you check for questions "below -1", but your code checks for questions "below 0" ... there is a difference between &lt; and &lt;=.
it does not check the closed-status of the post. If you want to see if a currently-open post was closed in the past, you need to check the PostHistory table.