SELECT users.id AS UserId, posts.tags FROM posts INNER JO...

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 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 '%strings%'
      AND posts.tags LIKE '%algebra%'
      AND posts.tags LIKE '%matrices%'
)
ORDER BY users.id;

Enter Parameters

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