Post Tags - DB

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

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