Q&A for Drupal developers and administrators
SELECT pt.PostId as [Post Link], p.Score, p.ViewCount FROM Tags as t, PostTags as pt, Posts as p WHERE pt.TagId = t.Id AND p.Id = pt.PostId AND t.TagName IN ('freeze', 'crash', 'bug') AND p.AcceptedAnswerId IS NULL AND p.ClosedDate IS NULL AND p.Id NOT IN ( SELECT ps.ParentId FROM Posts as ps WHERE ps.PostTypeId = 2 AND ps.Score > 1 ) ORDER BY ViewCount DESC