Custom Admin. SQL help.

We are currently in the middle of some heavy customisation work of the WP admin post section. So far, there are additional tables which are joined via the filters e.g.

add_filter(‘posts_join’,
add_filter(‘posts_where’,
add_filter(‘posts_orderby’,

this helps me order the posts via the new fields etc.

As for the columns in the admin – some stuff done with manage_post_columns..
add_action(‘manage_posts_custom_column’
add_filter(‘manage_posts_columns’

What I now need, is some advice on the hooks or filters to use for the following interface which showcases post counts….

* All (7) |
* Published (7) |
* Trash (2)

Any advice appreciated, I know I’ll have to do some extra SQL, just not sure where to look at present. With the additional joins and where clauses etc, the above counts are now wrong.