I'm getting an error from getActiveCategories() when I try and run this against our DB (mySQL). A slight rewrite fixes the problem for us but probably needs checked to make sure it works on others....

SELECT c.objectid, c.categoryLabel, COUNT(c.objectid) AS assigned
FROM dmCategory c
INNER JOIN refCategories p ON c.objectid = p.categoryID
INNER JOIN farBlogPost bp ON p.objectid = bp.objectid
GROUP BY c.objectid, c.categoryLabel,bp.status
HAVING bp.status = 'approved'

(I've moved the INNER JOIN ONs inline with their joins)