0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

select p.id as [Post Link], p.Score
from Posts p
join PostHistory h ON h.PostId = p.Id
where title like '%Yii%' and ClosedDate is not null
GROUP  BY p.Id, p.Score
having SUM(CASE WHEN h.PostHistoryTypeId = 14 THEN -1
WHEN h.PostHistoryTypeId = 15 then 1 ELSE 0 END) >= 0
order by Score desc

fork query

edited sep 22 13 anonymous

created oct 2 12 jon.doe6660