@southerngal: Okie now the Blog Categories have link, and i have fixed some bugs and cut away redundant codes. replace YOUR_CAT_ID with your category, in this case is 2. Here is the code
SELECT cat_ID, cat_name, category_nicename, COUNT(*) AS ‘total_posts’ FROM $tableposts INNER JOIN $tablepost2cat ON $tablepost2cat.post_id = $tableposts.ID INNER JOIN $tablecategories ON $tablepost2cat.category_id = $tablecategories.cat_ID WHERE cat_ID != 2 GROUP BY $tablepost2cat.category_id ORDER BY total_posts DESC
@anonymous: can you try to re-download the file again? I ahve updated some stuffs.