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