Migrated questions from ELU with scores less than parameter

1

Please login or register to vote for this query.

(click on this box to dismiss)

English Language Learners

Q&A for speakers of other languages learning English

select p.Score, ph.CreationDate [Migrated], ph.PostId [Post Link], cr.Name "Closed as"
from PostHistory ph
join Posts p on p.Id=ph.PostId
left join PostHistory cph on cph.PostId=ph.PostId and cph.CreationDate=p.ClosedDate and cph.PostHistoryTypeId=10
left join CloseReasonTypes cr on cr.Id=cph.Comment
where ph.PostHistoryTypeId=36
and p.PostTypeId=1
and ph.Comment like 'from %english.stackexchange.com%'
and ph.CreationDate > convert(datetime,##StartDate:string?09/22/2015##)
and p.Score <= ##MaximumScore?50##
and p.Score >= ##MinimumScore?-50##
order by score

Enter Parameters

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