select * from Posts as p join PostTypes as pt on p.PostTy...

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 * 
from Posts as p
join PostTypes as pt on p.PostTypeId=pt.Id 
join Users as u on p.OwnerUserId =u.Id
where u.DisplayName = 'Mat Mannion' and pt.Name = 'Question'

--OwnerUserId=6282 and PostTypeId=1

--Select * from PostTypes where Name='Question'

--select * from Users where DisplayName='Mat Mannion'

Enter Parameters

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