SELECT (select Count(did) as total from data_data where ccID = dCatID and (data_data.dSchoolID = '1' || data_schoolshare.dsSchoolID = '1' || 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 = '1' || data_schoolshare.dsSchoolID = '1' || data_data.dSchoolID is null) and cat_categories.ccDateDelete IS NULL and ccAction ='portal' and dGroupID ='0' GROUP BY cat_categories.ccID having total > 0 ORDER BY ccTitle ASC

struct
Message	[empty string]
StackTrace	java.lang.NullPointerException
Suppressed	array[empty]
TagContext	array[empty]
Type	java.lang.NullPointerException