Users with certain answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math Meta

Q&A about the site for people interested in the history and origins of science and mathematics

SELECT TOP 100 
q.Id as [Post Link], q.Score as [Question Score], a.Score as [Answer Score] from Posts q
inner join Posts a on a.ParentId = q.Id
WHERE (q.ClosedDate IS NOT NULL and datediff(day,q.CreationDate,getdate()) <= 31) 
and a.OwnerUserId = 446262 OR
a.OwnerUserId = 142385 OR
a.OwnerUserId = 798694 OR
a.OwnerUserId = 4280 OR
a.OwnerUserId = 82404 OR
a.OwnerUserId = 9340
order by q.ClosedDate desc

Enter Parameters

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