Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function published_term_count($term_id, $taxonomy){
- if($term_id && $taxonomy){
- global $wpdb;
- $query = "
- SELECT COUNT(ID) FROM $wpdb->posts
- LEFT JOIN $wpdb->term_relationships ON
- ($wpdb->posts.ID = $wpdb->term_relationships.object_id)
- LEFT JOIN $wpdb->term_taxonomy ON
- ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
- WHERE $wpdb->posts.post_status = 'publish'
- AND $wpdb->posts.post_type IN ('post')
- AND $wpdb->term_taxonomy.taxonomy = '" . $taxonomy . "'
- AND $wpdb->term_taxonomy.term_id = '" . $term_id . "'
- ";
- }
- return $wpdb->get_var($query);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement