Find potential posts missing tag name

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

DECLARE @UserID Int = ##UserID?9449426##
DECLARE @TagName Nvarchar(Max) = LOWER('##TagName?reactjs##')
DECLARE @TagSearch Nvarchar(Max) = LOWER('##TagSearch?react##')

SELECT
  a.Id [Post Link],
  a.Score
FROM Posts q
LEFT JOIN Posts a ON q.Id = a.ParentId
WHERE a.OwnerUserId = @UserID
  AND LOWER(q.Body) LIKE '%' + @TagSearch + '%'
  AND LOWER(q.Tags) NOT LIKE '%' + @TagName + '%'
ORDER BY a.Score DESC

Enter Parameters

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