[wp-hackers] finding out the top 5 source ( source is a custom taxonomy ), in a given category

Haluk Karamete halukkaramete at gmail.com
Sun Feb 3 21:19:38 UTC 2013

The client I'm working with have thousands of articles and media (
audio/video ) files. To WordPress, all are posted by Author ID 1,
which we named as STAFF.

All the content though in reality has been created by various people
and sources, certainly not by the STAFF.

To keep that info ( who created the content or where the source is ),
I used a non-hierarchical custom taxonomy called "source". if the
source happens to be an institution name I tagged the content by the
institution name as follows.


source: CNN source: Washington Post

And if the source happens to be a person, I used a prefix "by " in
front of the name.


source: by anderson cooper source: by jon stewart

Of course, the content has been tagged and categorized, accordingly.

Now, the question is how to effectively find out things like who's the
top 5 source's in category XYZ?

I don't think this can be pulled by using the wp_query args - by
tapping into the advanced tax query's section, cause wp_query args
eventually returns posts only. Here we are asking terms in return.

One possible way for this is the following

take the XYX category go thru all the posts - one by one particularly
paying attention to the source data in those posts while going thru,
dump each source term id in a temporary table when done with going
thru all the posts in that category, switch your attention to the
temporary table and get a summary on that table using a get count
after a group by and finally get the top 5.

but getting all that in a single statement? that ain't my cup of tea yet.


More information about the wp-hackers mailing list