Q&A for professional and enthusiast programmers
SELECT DISTINCT p.Id, p.Title, p.ViewCount From Posts p INNER JOIN PostTags pt ON (p.id = pt.PostId) INNER JOIN Tags t ON (pt.TagId = t.Id) WHERE p.ParentId is NULL -- AND p.Tags IN ('relational','entity-relational')