A sampling of recent off-topic and too localized closures

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cooking

Q&A for professional and amateur chefs

select top 50 Type, QId as [Post Link]

from (
select top 90 
(case when h.Comment = '2' then 'OT' else 'TL' end) as Type,
q.Id as QId

from PostHistory h
join Posts q on q.Id=h.PostId

where h.PostHistoryTypeId=10
and q.ClosedDate is not null
and isnull((select top 1 PostHistoryTypeId from PostHistory
  where PostId=q.Id and PostHistoryTypeId in (14,15,35) order by CreationDate desc),0) not in (14,35)

and (h.Comment like '2' or h.Comment like '7')

order by q.CreationDate desc
) as x

order by NewId()

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results