SELECT A.categoryID,A.categorytitle,A.categorydescr, count(*) 'total' FROM " . TABLE_PREFIX . "gamescat A, " . TABLE_PREFIX . "games B WHERE A.categoryID = B.categoryID group by A.categoryID