0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

SELECT users.id AS UserId, posts.tags
FROM posts
INNER JOIN users
ON posts.OwnerUserId = users.id
WHERE posts.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%'
)
ORDER BY users.id;

fork query

edited may 20

created may 20 anonymous