Please do not use showposts it got replaced by posts_per_page ages ago. Personally I would add the arguments to the WP_Query like shown below, additionally pagination should work like shown below: $paged = ( get_query_var( ‘paged’ ) ) ? get_query_var( ‘paged’ ) : 1; $args = array( ‘posts_per_page’ => 4, ‘paged’ => $paged, ); $the_query … Read more
$access_ids is a string. post__in accepts an array. So instead of $access_ids you could use ‘post__in’=> $ids skipping the $access_ids = implode( ‘, ‘, $ids ); all together.
The shop page is actually an archive page for posts of type ‘product’. Its template is in woocommerce/archive-product.php. You need to use the pre_get_posts action to preprocess the query before the loop, conditional_tags to recognize that you are in the product archive page, and a taxonomy query to filter the product categories, which belong to … Read more
You can define the args outside of the WP_Query instantiation: <?php $tax_query = array(‘relation’ => ‘AND’); if (isset($search_course_area)) { $tax_query[] = array( ‘taxonomy’ => ‘course-area’, ‘field’ => ‘id’, ‘terms’ => $search_course_area ); } if (isset($search_course_level)) { $tax_query[] = array( ‘taxonomy’ => ‘study-levels’, ‘field’ => ‘id’, ‘terms’ => $search_course_level ); } if (isset($search_course_mode)) { $tax_query[] = … Read more
Important: The following only works for WooCommerce versions less than 3.0. For a more up-to-date answer please see the other answer by kalle. WooCommerce save this data as metadata so you’ll need to run a Meta Query against the name _visibility. Something like: ‘meta_query’ => array( array( ‘key’ => ‘_visibility’, ‘value’ => ‘hidden’, ‘compare’ => … Read more
I created a plugin which does something similar (called Multisite Post Display https://wordpress.org/plugins/multisite-post-reader/ ) . It displays posts from all multisite sub-sites. The code in there might be helpful for what you are doing. You are welcome to dig into it and use the code to help with your project. (After all, I used other … Read more
According to https://codex.wordpress.org/Class_Reference/WP_Query#Order_.26_Orderby_Parameters you want to specify it similar to the following code example: $args = array( ‘orderby’ => array( ‘title’ => ‘DESC’, ‘menu_order’ => ‘ASC’ ) ); $query = new WP_Query( $args ); This is supported from WordPress 4.0. For custom fields (post meta) you will need an added meta query, as detailed on … Read more
WP_Query::reset_postdata() sets the global post variable ($GLOBALS[‘post’] === $post) to the current post in the loop of the current WP_Query instance. public function reset_postdata() { if ( ! empty( $this->post ) ) { $GLOBALS[‘post’] = $this->post; $this->setup_postdata( $this->post ); } } What that means is that, if you run a custom query on a page, … Read more
Below is the query I found somewhere and was going through it. The purpose of query is to sort the posts based on taxonomy. So, I am sharing the code so it might help you understand the use of posts_clauses. function color_clauses_mike( $clauses, $query ) { global $wpdb; if ( isset( $query->query[‘orderby’] ) && ‘color’ … Read more
I got curious about the SQL way of finding all posts without any attachments. Method #1 – Sub query with NOT IN Here’s my first attempt to construct such a query: global $wpdb; $sql = ” SELECT p1.ID, p1.post_title FROM {$wpdb->posts} p1 WHERE p1.post_type=”post” AND p1.post_status=”publish” AND p1.ID NOT IN ( SELECT DISTINCT p2.post_parent FROM … Read more