SELECT COUNT(*) AS EmptyTagsCount FROM posts WHERE OwnerU...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

SELECT COUNT(*) AS EmptyTagsCount
FROM posts
WHERE OwnerUserId IN (
    SELECT DISTINCT posts.OwnerUserId
    FROM posts
    INNER JOIN users
    ON posts.OwnerUserId = users.id
    WHERE posts.tags LIKE '%pr.probability%'
      AND posts.tags LIKE '%linear-algebra%'
      AND posts.tags LIKE '%matrices%'
      AND posts.tags LIKE '%lie-groups%'
)
AND (posts.tags IS NULL OR posts.tags = '');

Enter Parameters

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