Open, unlocked questions with "you" in the title

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

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

Enter Parameters

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