SELECT
zzf_category.PK_ID,
count(zzf_topics.PK_ID) AS topics,
zzf_category.catname
FROM
zzf_category
LEFT OUTER JOIN zzf_topics ON (zzf_category.PK_ID = zzf_topics.FK_CATEGORY_ID)
WHERE
zzf_category.catpar = catid
GROUP BY
zzf_category.PK_ID
order by zzf_category.PK_ID asc
Untested
[sql]SELECT zzf_category.PK_ID, count(DISTINCT zzf_topics.PK_ID) AS topics, count(zzf_replies.PK_ID) AS replies, zzf_category.catname FROM zzf_repliesINNER JOIN zzf_topics ON zzf_topics.PK_ID = zzf_replies.FK_TOPICS_IDINNER JOIN zzf_category ON zzf_category.PK_ID = zzf_topics.FK_CATEGORY_IDWHERE zzf_category.catpar = catidGROUP BY zzf_category.PK_IDORDER BY zzf_category.PK_ID ASC[/sql]
There are 10 types of people in this world, those who understand binary and those who don't