SELECT pt.Id, pt.Name, COUNT(p.Id) AS numPosts, Min(p.Cre...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

SELECT pt.Id, pt.Name, 
COUNT(p.Id) AS numPosts, 
Min(p.CreationDate) AS minCreationDate
FROM PostTypes pt LEFT OUTER JOIN Posts p
ON pt.Id = p.PostTypeId
GROUP BY pt.Id, pt.Name

Enter Parameters

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