select top(50) t.Id as [Post Link], t.* from Posts t inne...

0

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

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

select top(50) t.Id as [Post Link], t.*
from Posts t
inner join PostTags pt on pt.TagId = t.Id
inner join Posts q on q.Id = pt.PostId
inner join Posts a on a.ParentId = q.Id
where t.PostTypeId = 5
and q.PostTypeId = 1
and a.PostTypeId = 2
and a.OwnerUserId = ##UserId##
order by t.LastEditDate ASC

Enter Parameters

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