$query = $__CONNECTION->prepare("SELECT count(c.`id`) as `count`
                                 FROM `".DB_PREF."comments` c
                                 WHERE c.`author_hash`=:hash
                                 AND c.`visible`=:visible
                                 GROUP BY c.`author_hash`");
$v = 1;

$query->bindValue(':hash',self::key(), PDO::PARAM_STR);
$query->bindParam(':visible',$v, PDO::PARAM_INT);

$vis = array('totalvisible'=>1,
             'killed'=>0,
             'autokilled'=>-1,
             'spam'=>-2);

$breakdown = array();
foreach ($vis as $k=>$v) {
    $query->execute();
    $breakdown[$k] = 0;

    if ($r = $query->fetch(PDO::FETCH_ASSOC)) {
        $breakdown[$k] = $r['count'];
    }
}