Q&A about the site for administrators, end users, developers and designers for Craft CMS
select u.Id, u.DisplayName, p.Id, substring(p.Title,1,20) as TITLE, p.CreationDate from Users AS u INNER JOIN Posts AS p ON u.Id = p.OwnerUserId where u.Id = 1849252 order by p.Id