1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users and developers of distributed applications built on top of the blockchain operating system, EOS.IO

WITH results AS (
SELECT t.TagName, 'Excerpt' AS Type, t.Id, p.Body
  FROM Tags AS t
  INNER JOIN Posts AS p
    ON p.Id = t.ExcerptPostId
  WHERE p.Body LIKE '%' + ##query:string## + '%' ESCAPE '\' COLLATE sql_latin1_general_cp1_ci_ai
  
UNION ALL

SELECT t.TagName, 'Wiki', t.Id, p.Body
  FROM Tags AS t
  INNER JOIN Posts AS p
    ON p.Id = t.WikiPostId
  WHERE p.Body LIKE '%' + ##query:string## + '%' ESCAPE '\' COLLATE sql_latin1_general_cp1_ci_ai
)

SELECT 'site://edit-tag-wiki/' + CAST(Id AS NVARCHAR) + '|' + TagName + ', ' + Type,
  body
  FROM results
  ORDER BY TagName

fork query

edited jul 12

created apr 15 Glorfindel