0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

SELECT TOP 20 
    p.Id
FROM PostsWithDeleted p
WHERE p.DeletionDate IS NOT NULL
AND EXISTS (SELECT 1
    FROM PostTags pt
    INNER JOIN Tags t ON p.ParentId = pt.PostId
    WHERE pt.TagId = t.id
    AND t.TagName IN ('c#','ldap')
    GROUP BY ()
    HAVING COUNT(*) = 2)
ORDER BY CreationDate DESC

view current version

edited jul 1

created jul 1 anonymous