Migrated questions from ELU with scores less than parameter


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 http://english.stackexchange.com/%'
and ph.CreationDate > convert(datetime,'09/22/2015 00:00:00.000')
and p.Score <= ##MaximumScore?50##
and p.Score >= ##MinimumScore?-50##
order by score

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results