Do a tax-query and then count the result. No need for a custom query with dozens of JOINS. $posts = new WP_Query( array( ‘post_type’ => ‘MYPOSTTYPE’, ‘tax_query’ => array( array( ‘taxonomy’ => ‘TAX_1’, ‘field’ => ‘slug’, ‘terms’ => array( ‘TERM_TAX_1’ ), ‘operator’ => ‘IN’ ), array( // etc. ) ), ‘post_status’ => ‘publish’ ); prinft( … Read more
If I understand right, you need all attachments (attached or not) with specified term? $args = array( ‘post_type’ => ‘attachment’, ‘my_taxonomy’ => ‘my_taxonomy_term’ ); $my_query = new WP_Query( $args ); if( $my_query->have_posts() ): while ($my_query->have_posts()) : $my_query->the_post(); // your stuff here endwhile; } // Don’t forget to reset wp_reset_postdata(); WP_Query Taxonomy Parameters.
Use this function to determine if Taxonomy is hierarchical or not: Function Reference/is taxonomy hierarchical « WordPress Codex Example: // taxonomy term archives $post_type = get_post_type(); $taxonomies = get_object_taxonomies($post_type); if(!empty($taxonomies)){ foreach($taxonomies as $taxonomy){ // only want hierarchical — no tags please if(is_taxonomy_hierarchical($taxonomy)){ $terms = get_terms($taxonomy); if(!empty($terms)){ echo “<ul>”; foreach ( $terms as $term ) { … Read more
Try the following code: $taxonomy_name=”listing_category”; $queried_object = get_queried_object(); $term_id = $queried_object->term_id; $termchildren = get_terms( $taxonomy_name, array( ‘parent’ => $term_id, ‘hide_empty’ => false ) ); echo ‘<ul>’; foreach ( $termchildren as $child ) { echo ‘<li><a href=”‘ . get_term_link( $child, $taxonomy_name ) . ‘”>’ . $child->name . ‘</a></li>’; } echo ‘</ul>’;
See Taxonomy Parameters in Codex. First — areas should probably be in your tax_query as well. Second — you probably need to make use of operator argument in queries (inner ones). I am not sure without testing this out but AND seems like it would for more strict matches than default IN for your mandatory … Read more
You can use the parent argument in get_terms() to get direct children of a term. You can use the child_of argument to get all descendents of a term. Something like this. $parent_id = 32; $args = array( ‘parent’ => $parent_id ); $terms = get_terms( $taxonomy, $args ); print_r( $terms ); If you want to programmatically … Read more
The main problem is that, in your $_POST loop, $value is an array, yet you apply htmlspecialchars to it, which will vomit and return back nothing. If you haven’t done so already, set WP_DEBUG to true in your wp-config.php – developing without it is simply not an option. Regardless, let’s fix that dirty $_POST loop: … Read more
I haven’t run this code so there may be a syntax error, but the gist is to return userfeed-taxonomy with the terms specified that have featured category OR cities-taxonomy with the terms specified and featured category OR anything else that’s not those taxonomies. It’s kind of clunky, maybe there is a better way: $query->set( ‘tax_query’, … Read more
You could build a SQL query using $wpdb containing all your post IDs from the array that will list all the terms. Or even better get the post IDs in the same query instead of getting them from the array you mentioned. This is an example: global $wpdb; $query = $wpdb->get_results( $wpdb->prepare( “select * from … Read more
Starting from WordPress version 4.5, you can use RAND(seed) with the orderby parameter. However, when the value is simply RAND (i.e. the uppercase of rand), WP_Query ignores it and defaults to the default sorting (which is by the post date). I’ve confirmed that by inspecting the $query->request: With ‘orderby’ => ‘RAND’, the ORDER BY clause … Read more