0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for developers and researchers interested in open data

SELECT DISTINCT p.Id, p.Title, p.ViewCount
FROM Tags t1
INNER JOIN PostTags pt1 ON t1.Id = pt1.TagId
INNER JOIN Posts p ON pt1.PostId = p.Id
INNER JOIN PostTags pt2 ON p.Id = pt2.PostId
INNER JOIN Tags t2 ON pt2.TagId = t2.Id
WHERE t1.TagName = 'relational'
AND t2.TagName = 'entity-relationship';

fork query

edited dec 13

created dec 13 anonymous