Get terms that contain posts that in turn belong to other terms?

This should get you the names of all such terms in an array $wpdb->get_col(“SELECT DISTINCT {$wpdb->terms}.name FROM {$wpdb->terms} INNER JOIN {$wpdb->term_taxonomy} ON {$wpdb->term_taxonomy}.term_id = {$wpdb->terms}.term_id INNER JOIN {$wpdb->term_relationships} ON {$wpdb->term_taxonomy}.term_taxonomy_id = {$wpdb->term_relationships}.term_taxonomy_id WHERE {$wpdb->term_taxonomy}.taxonomy = ‘shape’ AND {$wpdb->term_relationships}.object_id IN ( SELECT object_id FROM {$wpdb->term_relationships} INNER JOIN {$wpdb->term_taxonomy} ON {$wpdb->term_taxonomy}.term_taxonomy_id = {$wpdb->term_relationships}.term_taxonomy_id WHERE {$wpdb->term_taxonomy}.taxonomy = ‘color’ … Read more

Custom taxonomy returns 404

You cannot have a rewrite slug of “https://wordpress.stackexchange.com/”. Note that using a slug of ”, which you will find floating around, will not work for the latest WordPress versions either. If you want a url like http://domain.com/custom-post, there are no bullet-proof solutions, but the answer to this question will give you some leads: Remove slug … Read more

WordPress query with items from more than one selfdefined taxonomy as `term` argument

I managed to do it. I used the following query parameter: ‘tax_query’ => array( array(‘taxonomy’ => ‘wpccategories’, ‘field’ => ‘slug’, ‘terms’ => $termz ) ) With $termz being: $termz = wp_get_object_terms($id, ‘wpccategories’, array(“fields” => “slugs”)); The problem I struggled with was that I needed to use singular ‘field’with singular ‘slug’ in the tax_query (I knew … Read more

Show related posts that match two categories

This seems a little tricky since you seem (ab)use native Category for things that aren’t quite the same (Villa and Housekeeper). You will probably need to write a custom logic since WP won’t just “get” the bit that if you are on one specific category (Villa) you want to query for another (Housekeeper). As for … Read more