SELECT DISTINCT p.Id AS [Post Link],p.Tags,p.AnswerCount...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Italian Language Meta

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results