Q&A about the site for administrators, end users, developers and designers for Craft CMS
select top 1 *
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'