Existing and past tags containing the given string

1

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers

Q&A for Drupal developers and administrators

; with tagshistory_cte AS
(
SELECT
  Id AS phid,
  replace(value,'>','') TagName
FROM
  PostHistory
  CROSS APPLY STRING_SPLIT(Text,'<')
Where PostHistoryTypeId in (3,6,9)
and len(value) > 0
)

SELECT
  DISTINCT(th.tagname)
FROM tagshistory_cte th 
WHERE th.tagname LIKE '%##text?divisble##%'
ORDER BY th.tagname

Enter Parameters

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