select* from Posts as p join PostTypes as pt on p.PostTyp...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics Meta

Q&A about the site for people studying math at any level and professionals in related fields

select* 
from Posts as p
join PostTypes as pt on p.PostTypeId=pt.Id
where p.OwnerDisplayName = 'Mat Mannion' and pt.Name = 'Question'

--OwnerUserId=6282 and PostTypeId=1

--Select * from PostTypes where Name='Question'

--select * from Users where DisplayName='Mat Mannion'

Enter Parameters

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