Q&A for administrators and users of the CiviCRM Constituent Relationship Management software
select a.Id, a.PostTypeId, b.Name from Posts a inner join PostTypes b on a.PostTypeId = b.Id where OwnerDisplayName = 'Mat Mannion' and a.PostTypeId = 1;