SELECT
(select Count(did) as total from data_data where ccID = dCatID and (data_data.dSchoolID = '20' || data_schoolshare.dsSchoolID = '20' || data_data.dSchoolID is null) ) as Total,
cat_categories.ccID, cat_categories.ccTitle,
cat_categories.ccHexColor,
cat_categories.ccUserID, cat_categories.ccDescription, cat_categories.ccThumbnailFileID
FROM cat_categories
LEFT Join data_data ON cat_categories.ccID = data_data.dCatID
Left Join data_schoolshare ON data_data.dID = data_schoolshare.dsDataID
WHERE
(data_data.dSchoolID = '20' || data_schoolshare.dsSchoolID = '20' || data_data.dSchoolID is null)
and cat_categories.ccDateDelete IS NULL
and (ccAction ='Events' or ccAction = 'cal' or ccAction = 'event')
GROUP BY
cat_categories.ccID
having total > 0
ORDER BY ccTitle ASC