0

Please login or register to vote for this query.

(click on this box to dismiss)

Вопросы и ответы о сайте для программистов

SELECT TOP 20 p.Id as [Post Link]
FROM Posts as p
JOIN PostTags AS pt ON p.Id = pt.PostId
JOIN Tags AS t ON t.Id = pt.TagId
GROUP BY p.Id
HAVING COUNT(*) = 1
ORDER BY p.Id

fork query

edited nov 23 20 anonymous

created jan 29 14 Marius Žilėnas