I found out that in order to query wp posts via custom taxonomy, from a blog 1 to another blog 2, you have to register that custom taxonomy in both blogs, otherwhise it won’t work. this is strange but true! anyways it works fine now.
You can try using $wpdb, like this: // Use the global variable $wpdb; global $wpdb; // :: Define SQL command :: // You can request for the IDs only, // and then get the properties later on via get_post_meta or WC_Product() $q = ‘SELECT wp_posts.ID ‘; $q .= ‘FROM wp_posts ‘; // Attach wp_postmeta table … Read more
This is a really interesting question, which can result in a very expensive, resource intensive process which can really slow your page down dramatically PRELUDE All my code in this question is based on the following post type and taxonomy, so before you run any code, make sure to adjust the post type and taxonomy … Read more
Looking at the WP_Query documentation on tax_queries we can see it accepts a nested array as a parameter. Compare that to the provided code: ‘tax_query’ => array( ‘taxonomy’ => ‘news_category’, ‘field’ => ‘term_id’, ‘terms’ => 82, ), Should look like: ‘tax_query’ => [ [ ‘taxonomy’ => ‘news_category’, ‘field’ => ‘term_id’, ‘terms’ => 82, ] ],
I’m not sure what you exactly need, but normally, by default, get_terms returns only terms that actually have posts assigned to them $terms = get_terms( ‘exhibition’ ); var_dump( $terms ); Apart from this, I really do not know what you exactly need
This query will handle two levels of hierarchy in your taxonomy. More than two levels of hierarchy and you’ll need a recursive self-join. What this does is return the posts in the correct child within parent order. To create the appropriate parent level headings, you’ll have compare the current post’s parent taxon with that of … Read more
Please use below code to show posts in texonomy and titles $s = $request[‘s’]; $tags = str_replace(‘ ‘, ‘-‘, strtolower($request[‘s’])); $q1 = get_posts(array( ‘fields’ => ‘id’, ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘posts_per_page’ => -1, ‘s’ => $s )); $q2 = get_posts(array( ‘fields’ => ‘ids’, ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘posts_per_page’ => -1, ‘tag’ … Read more
You can do everything you need using the search parameters allowed in WP_Query — except searching in the post title only. In order to do that, see this answer. Make sure to look at the taxonomy and meta subqueries allowed in the args passed to WP_Query. EDIT: Since you need to select using OR, you … Read more
This code can’t be added anywhere you want, and it can’t be added to functions.php or any other php file like this. This is a element for the array used to create the WordPress query object. It has to be added via WP_Query class or get_posts and query_posts functions, or via the filter to modify … Read more
The 0 = 1 happens when the terms don’t exist. You’re creating a query for some set of terms. Before it can add the SQL to that main query, it first does a secondary query to get the term_id’s for the relevant terms. If none are found, then it returns 0 = 1 instead, to … Read more