Wrong node count on author/keyword overview pages, when using revisions

The count displayed is the number of revisions, not the number of articles (nodes). I don't think you want that.

How come?
When multiple node revisions are in the database, there are also multiple rows in the biblio_keyword table; one for each vid.
The join between biblio_keyword_data and biblio_keyword is the one that yields duplicate rows -one per vid- and makes the count go up.

Solution: use a subquery to get the correct node count per keyword (which only counts nodes in the {node} table, not all vids).