Find potential posts missing tag name

1

Please login or register to vote for this query.

(click on this box to dismiss)

Martial Arts Meta

Q&A about the site for students and teachers of all martial arts

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 main site
loading Hold tight while we fetch your results