gomymusic

Anyone?

All moderators sleep?
Please move to WP-Advanced.
Wake up!!

Any moderator can move this topic to WP-Advanced ?

Nobody know?

Can you make an example please?

In this way I will list posts ordered by meta_value_num.
I want to list taxonomy terms sorted by views of posts assigned.

Anyone?

Nobody?

$cat = get_query_var('cat');
$taxonomy = 'madeof';
$sql = "
SELECT DISTINCT t2.name
FROM $wpdb->terms t2
JOIN $wpdb->term_taxonomy tt2 ON (t2.term_id = tt2.term_id
      AND tt2.taxonomy = '$taxonomy')
JOIN $wpdb->term_relationships tr2 ON (tt2.term_taxonomy_id = tr2.term_taxonomy_id)
JOIN $wpdb->posts p ON tr2.object_id = p.ID
JOIN $wpdb->term_relationships tr ON  (p.ID = tr.object_id
         AND tr.term_taxonomy_id = $cat)
ORDER BY t2.name ASC
";
// print_r("<p>SQL:$sql</p>");
$values = $wpdb->get_col($sql);
// print_r($values);
foreach ( $values as $term ) {
   echo "<br />Brand: $term";
}

This is the code… thanks to vtxyzzy

It works.
Thanks a lot.

So.. I have:
category1term, category2term
taxonomy1term, taxonomy2term
post1, post2, post3, post4

When I see the category page category1term I see post1 and post2 (post3 and post4 are in other category). Both of them are in taxonomy1term. In this case I want to list only taxonomy1term because post1 and post2 are associated with taxonomy2term..

??

terms from a certain taxonomy…
I want to choose what taxonomy to be…

Thanks a lot!!!

First time I want to list all meta keys from cusrrent category, right now I want to list all taxonomy terms from current category.

I dont know what you mean

I want to list all taxonomy terms related to current category in category term. So.. If I access “category1” category page, I see all posts from that category. But I want to see all taxonomy terms that are associated only with post from the current category.

PS: Right now I changed Brand from custom meta box in custom taxonomy.

Thanks.

I fixed the problem