Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language
-- Enter Query Title -- Enter Query Description SELECT DISTINCT p.Id AS [Post Link],p.Tags,p.AnswerCount,MAX(a.Score) AS TopScore FROM Posts p JOIN Users u ON u.Id = p.OwnerUserId JOIN PostTags pt ON pt.PostId = p.Id JOIN Tags t ON t.Id = pt.TagId LEFT JOIN Posts a ON a.ParentId = p.Id WHERE (p.LastEditDate < '1-May-2010' OR p.LastEditDate IS NULL) AND p.AcceptedAnswerId IS NULL AND p.Score >= 0 AND u.LastAccessDate > '1-May-2010' AND u.Reputation > 1 AND (p.title LIKE '%CFML%' OR p.title LIKE '%ColdFusion%' OR p.title LIKE '%Railo%' OR p.title LIKE '%BlueDragon%' OR p.title LIKE '%openbd%' OR p.title LIKE '%regex%' OR p.title LIKE '%regular expression%' OR t.TagName IN ('CFML','ColdFusion','Railo','BlueDragon','openbd','regex')) GROUP BY p.Id,p.Tags,p.AnswerCount HAVING MAX(a.Score) < 3