Post Tags - DB

0

Please login or register to vote for this query.

(click on this box to dismiss)

Korean Language

Q&A for linguists, teachers and students of the Korean language

SELECT 
z.tags2 AS [Tags]
,[NumberOfTags]
, [PostID]
, [UserID]
, [PostBody]
FROM (
SELECT 
p.tags
,STRING_AGG(p.tags, '<>') AS [Tags2]
,LEN(p.Tags) - LEN(REPLACE(p.Tags, '<','')) AS [NumberOfTags]
,p.id AS [PostID]
,p.OwnerUserID AS [UserID]
,p.body AS [PostBody]

FROM posts p
WHERE p.id = 3335954 --4

group by p.id
,p.tags
,p.id 
,p.OwnerUserID 
,p.body 

) z

Enter Parameters

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