gistfile1.txt

SELECT 
    	p.ProjectID, 
	p.FourHTitle,
	rt.RecordTypeID, 
	rt.RecordTypeName, 
	rt.RecordTypeDescription,
    	(	SELECT COUNT(1) 
		FROM c_RecordTypeConfiguration 
		WHERE OrganizationID = 25 
		AND RecordTypeID = rt.RecordTypeID 
        	AND IsDeleted = 0 
		AND ProjectID = 45
	) AS RecordTypeUsageCount
FROM c_FourHProject p
LEFT OUTER JOIN c_RecordTypeConfiguration rtc
	ON rtc.ProjectID = p.ProjectID
LEFT OUTER JOIN c_RecordType rt 
	ON rtc.RecordTypeID = rt.RecordTypeID
	AND rtc.IsDeleted = 0
WHERE p.FourHOrgId = 25 
ORDER BY p.FourHTitle, rtc.SortOrder