[wp-hackers] finding out the top 5 source ( source is a custom taxonomy ), in a given category
xoodrew at gmail.com
Sun Feb 3 22:53:12 UTC 2013
You might look at how wp_generate_tag_cloud() in
wp-includes/category-template.php goes about finding the term counts and
assigning font sizes based on those counts.
On Sun, Feb 3, 2013 at 2:19 PM, Haluk Karamete <halukkaramete at gmail.com>wrote:
> 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.
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
-- I've kinda got a thing for WordPress > http://www.drewapicture.com
More information about the wp-hackers