[wp-trac] [WordPress Trac] #40877: Count user tag

[WordPress Trac]

#40877: Count user tag
--------------------------------+------------------------------------------
 Reporter:  seraj8              |       Owner:
     Type:  feature request     |      Status:  closed
 Priority:  normal              |   Milestone:
Component:  Options, Meta APIs  |     Version:
 Severity:  normal              |  Resolution:  maybelater
 Keywords:  reporter-feedback   |     Focuses:  administration, performance
--------------------------------+------------------------------------------

Comment (by seraj8):

 Hello
 @afercia and @johnbillion Thank for your help...
 I found solution for find number of tags by each user.
 I use this query:


 {{{
 SELECT * FROM wp_term_taxonomy AS tt
 JOIN wp_term_relationships AS tr ON
 tr.term_taxonomy_id=tt.term_taxonomy_id
 JOIN wp_posts AS p ON tr.object_id=p.ID
 JOIN wp_terms AS t ON t.term_id=tt.term_id
 WHERE
 tt.taxonomy='post_tag' AND
 p.post_author=AUTHOR_ID AND
 p.post_status='publish' AND
 p.post_type='post'
 GROUP BY t.name
 }}}


 Thank you

--
Ticket URL: <https://core.trac.wordpress.org/ticket/40877#comment:4>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform