Title: gomymusic's Replies | WordPress.org

---

# gomymusic

  [  ](https://wordpress.org/support/users/gomymusic/)

 *   [Profile](https://wordpress.org/support/users/gomymusic/)
 *   [Topics Started](https://wordpress.org/support/users/gomymusic/topics/)
 *   [Replies Created](https://wordpress.org/support/users/gomymusic/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/gomymusic/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/gomymusic/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/gomymusic/engagements/)
 *   [Favorites](https://wordpress.org/support/users/gomymusic/favorites/)

 Search replies:

## Forum Replies Created

Viewing 15 replies - 1 through 15 (of 23 total)

1 [2](https://wordpress.org/support/users/gomymusic/replies/page/2/?output_format=md)
[→](https://wordpress.org/support/users/gomymusic/replies/page/2/?output_format=md)

 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [List 1th post of category then 2th and so on…](https://wordpress.org/support/topic/list-1th-post-of-category-then-2th-and-so-on/)
 *  Thread Starter [gomymusic](https://wordpress.org/support/users/gomymusic/)
 * (@gomymusic)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/list-1th-post-of-category-then-2th-and-so-on/#post-5601722)
 * Anyone?
 * All moderators sleep?
    Please move to WP-Advanced. Wake up!!
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [How to list custom taxonomy 1 terms related to current taxonomy 2 term](https://wordpress.org/support/topic/how-to-list-custom-taxonomy-1-terms-related-to-current-taxonomy-2-term/)
 *  Thread Starter [gomymusic](https://wordpress.org/support/users/gomymusic/)
 * (@gomymusic)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/how-to-list-custom-taxonomy-1-terms-related-to-current-taxonomy-2-term/#post-5376280)
 * Any moderator can move this topic to WP-Advanced ?
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [How to list custom taxonomy 1 terms related to current taxonomy 2 term](https://wordpress.org/support/topic/how-to-list-custom-taxonomy-1-terms-related-to-current-taxonomy-2-term/)
 *  Thread Starter [gomymusic](https://wordpress.org/support/users/gomymusic/)
 * (@gomymusic)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/how-to-list-custom-taxonomy-1-terms-related-to-current-taxonomy-2-term/#post-5376264)
 * Nobody know?
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Order taxonomy term by meta value number of assigned posts](https://wordpress.org/support/topic/order-taxonomy-term-by-meta-value-number-of-assigned-posts/)
 *  Thread Starter [gomymusic](https://wordpress.org/support/users/gomymusic/)
 * (@gomymusic)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/order-taxonomy-term-by-meta-value-number-of-assigned-posts/#post-4492478)
 * Can you make an example please?
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Order taxonomy term by meta value number of assigned posts](https://wordpress.org/support/topic/order-taxonomy-term-by-meta-value-number-of-assigned-posts/)
 *  Thread Starter [gomymusic](https://wordpress.org/support/users/gomymusic/)
 * (@gomymusic)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/order-taxonomy-term-by-meta-value-number-of-assigned-posts/#post-4492464)
 * 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?
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Order taxonomy term by meta value number of assigned posts](https://wordpress.org/support/topic/order-taxonomy-term-by-meta-value-number-of-assigned-posts/)
 *  Thread Starter [gomymusic](https://wordpress.org/support/users/gomymusic/)
 * (@gomymusic)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/order-taxonomy-term-by-meta-value-number-of-assigned-posts/#post-4492453)
 * Nobody?
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [How to list custom taxonomy terms related to current category](https://wordpress.org/support/topic/how-to-list-custom-taxonomy-terms-related-to-current-category/)
 *  Thread Starter [gomymusic](https://wordpress.org/support/users/gomymusic/)
 * (@gomymusic)
 * [12 years, 12 months ago](https://wordpress.org/support/topic/how-to-list-custom-taxonomy-terms-related-to-current-category/#post-3861472)
 *     ```
       $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](http://wordpress.org/support/profile/vtxyzzy)
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [List all unique custom fields fomr a certain meta key from current category?](https://wordpress.org/support/topic/list-all-unique-custom-fields-fomr-a-certain-meta-key-from-current-category/)
 *  Thread Starter [gomymusic](https://wordpress.org/support/users/gomymusic/)
 * (@gomymusic)
 * [12 years, 12 months ago](https://wordpress.org/support/topic/list-all-unique-custom-fields-fomr-a-certain-meta-key-from-current-category/#post-3498978)
 * It works.
    Thanks a lot.
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [List all unique custom fields fomr a certain meta key from current category?](https://wordpress.org/support/topic/list-all-unique-custom-fields-fomr-a-certain-meta-key-from-current-category/)
 *  Thread Starter [gomymusic](https://wordpress.org/support/users/gomymusic/)
 * (@gomymusic)
 * [12 years, 12 months ago](https://wordpress.org/support/topic/list-all-unique-custom-fields-fomr-a-certain-meta-key-from-current-category/#post-3498976)
 * 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..
 * 🙂
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [List all unique custom fields fomr a certain meta key from current category?](https://wordpress.org/support/topic/list-all-unique-custom-fields-fomr-a-certain-meta-key-from-current-category/)
 *  Thread Starter [gomymusic](https://wordpress.org/support/users/gomymusic/)
 * (@gomymusic)
 * [12 years, 12 months ago](https://wordpress.org/support/topic/list-all-unique-custom-fields-fomr-a-certain-meta-key-from-current-category/#post-3498975)
 * terms from a certain taxonomy…
    I want to choose what taxonomy to be…
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [List all unique custom fields fomr a certain meta key from current category?](https://wordpress.org/support/topic/list-all-unique-custom-fields-fomr-a-certain-meta-key-from-current-category/)
 *  Thread Starter [gomymusic](https://wordpress.org/support/users/gomymusic/)
 * (@gomymusic)
 * [12 years, 12 months ago](https://wordpress.org/support/topic/list-all-unique-custom-fields-fomr-a-certain-meta-key-from-current-category/#post-3498973)
 * Thanks a lot!!!
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [List all unique custom fields fomr a certain meta key from current category?](https://wordpress.org/support/topic/list-all-unique-custom-fields-fomr-a-certain-meta-key-from-current-category/)
 *  Thread Starter [gomymusic](https://wordpress.org/support/users/gomymusic/)
 * (@gomymusic)
 * [12 years, 12 months ago](https://wordpress.org/support/topic/list-all-unique-custom-fields-fomr-a-certain-meta-key-from-current-category/#post-3498971)
 * First time I want to list all meta keys from cusrrent category, right now I want
   to list all taxonomy terms from current category.
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [List all unique custom fields fomr a certain meta key from current category?](https://wordpress.org/support/topic/list-all-unique-custom-fields-fomr-a-certain-meta-key-from-current-category/)
 *  Thread Starter [gomymusic](https://wordpress.org/support/users/gomymusic/)
 * (@gomymusic)
 * [12 years, 12 months ago](https://wordpress.org/support/topic/list-all-unique-custom-fields-fomr-a-certain-meta-key-from-current-category/#post-3498969)
 * I dont know what you mean
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [List all unique custom fields fomr a certain meta key from current category?](https://wordpress.org/support/topic/list-all-unique-custom-fields-fomr-a-certain-meta-key-from-current-category/)
 *  Thread Starter [gomymusic](https://wordpress.org/support/users/gomymusic/)
 * (@gomymusic)
 * [12 years, 12 months ago](https://wordpress.org/support/topic/list-all-unique-custom-fields-fomr-a-certain-meta-key-from-current-category/#post-3498967)
 * 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.
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Problem with permalinks](https://wordpress.org/support/topic/problem-with-permalinks-34/)
 *  Thread Starter [gomymusic](https://wordpress.org/support/users/gomymusic/)
 * (@gomymusic)
 * [12 years, 12 months ago](https://wordpress.org/support/topic/problem-with-permalinks-34/#post-3860058)
 * I fixed the problem

Viewing 15 replies - 1 through 15 (of 23 total)

1 [2](https://wordpress.org/support/users/gomymusic/replies/page/2/?output_format=md)
[→](https://wordpress.org/support/users/gomymusic/replies/page/2/?output_format=md)