Title: Custom Admin. SQL help.
Last modified: August 19, 2016

---

# Custom Admin. SQL help.

 *  [paulanthony](https://wordpress.org/support/users/paulanthony/)
 * (@paulanthony)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/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.

The topic ‘Custom Admin. SQL help.’ is closed to new replies.

## Tags

 * [admin-panel](https://wordpress.org/support/topic-tag/admin-panel/)
 * [custom admin](https://wordpress.org/support/topic-tag/custom-admin/)

 * In: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/)
 * 0 replies
 * 1 participant
 * Last reply from: [paulanthony](https://wordpress.org/support/users/paulanthony/)
 * Last activity: [15 years, 8 months ago](https://wordpress.org/support/topic/custom-admin-sql-help/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics