Count user tag

[seraj8]

Hello
In the database tables User ID to insert tags not registered.
Therefore, the number of tags can not be output for each user.

Thank you

[afercia]

Not sure what's intended for "user tags", maybe something added by some plugin? Looks like something not related to accessibility though, removing the focus as per today's bug scrub.

[johnbillion]

I think what's being asked here is for a field akin to the author field for terms so it's possible for users to own terms, thereby making them countable by user.

There's nothing on the roadmap for this and it's unlikely to be worked on at least in the short term. Closing as maybelater in case someone wants to pick it up.

[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