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

WordPress Trac noreply at wordpress.org
Sat Jun 17 04:42:07 UTC 2017

#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):

 @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
 JOIN wp_posts AS p ON tr.object_id=p.ID
 JOIN wp_terms AS t ON t.term_id=tt.term_id
 tt.taxonomy='post_tag' AND
 p.post_author=AUTHOR_ID AND
 p.post_status='publish' AND
 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

More information about the wp-trac mailing list