select u.Id, u.DisplayName, p.Id, substring(p.Title,1,20)...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

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

Enter Parameters

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