Q&A for SharePoint enthusiasts
SELECT TOP 10* FROM posts AS p LEFT JOIN PostTypes AS pt ON pt.Id = p.PostTypeId