error en esta consulta: SELECT dir_categories.id, dir_categories.name, COUNT(dir_pages.id) AS pages FROM dir_categories LEFT JOIN dir_pages ON dir_pages.category = dir_categories.id AND dir_pages.accepted = 'y' WHERE ref = 1 GROUP BY dir_categories.id ORDER BY dir_categories.name