Do you mean you would like to populate those blog post on the certain page who post in same location?

If yes, those location data is actually stored in this post table #__easyblog_post.

Hi

No, my request is to get a Trending box (like in Twitter), where we see the most used Tags posted in the blog.

For instance, I could fire something similar:

Select Count(Tag) as Tags GROUP BY Hit ORDER BY Tags DESC Limit 10

Please confirm

Many thanks

Oh, i got your meaning now, for the current table structure, when the user add tag into the blog post, it will create those new tag data into this table #__easyblog_tag , and it will also store in this table as well #__easyblog_post_tag for record which tag added into the blog post on the site.

Hope this will help much you here.