0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

SELECT TOP 1000
    Tags,
    (LEN(Tags) - LEN(REPLACE(Tags, ',', ''))) + 1 AS NumberOfTags,
    Id AS PostId,
    OwnerUserId AS UserId,
    LEFT(Body, 300) AS PostBody
FROM 
    Posts
WHERE 
    Tags IS NOT NULL
    AND (LEN(Tags) - LEN(REPLACE(Tags, ',', ''))) + 1 >= 5
    AND CreationDate >= '2024-10-01'
ORDER BY 
    NumberOfTags DESC;

fork query

edited oct 24

created oct 24 anonymous