This is very unusual case, and the only solution I can think of here is to get an array of category ids to include into category__in in order to skip posts that are only assigned to category 1 In order to achieve this, we must use get_terms() to get all the categories. We will use … Read more
Note that here you’re overriding the paging of the main query, with the posts_limits filter, by using hardcoded values: ‘LIMIT 0, 25’ where 0 is the offset and 25 is the number of posts to display. So in this case I would just use pre_get_posts with $query->set( ‘posts_per_page’, 25 ); and we don’t have to … Read more
This is directly related to, and a consequence of WordPress.com VIP At VIP, we deal with sites that range in the hundreds of millions of page views per week. As a result, situations that can slow down your site are much more noticeable at that scale than on a small shared host, but this still … Read more
You can use ‘posts_orderby’ filter to change the SQL performed. Note that: using get_posts() you need to set ‘suppress_filters’ argument of false for the filter to be performed if you don’t explicitly set ‘post_status’ you’ll get only published posts (so no much to order) Code sample: $filter = function() { return ‘post_status ASC’; }; add_filter(‘posts_orderby’, … Read more
Yes. To give you some historical perspective WordPress core: is relatively old code base, code volume tends to grow over time; has extreme commitment to backwards compatibility, as result it’s extremely rare for code to be removed from core; is written in essentially obsolete dialect of PHP version 5.2 (which it remains compatible with), which … Read more
meta_query and orderby are seperate parameters, you just put them together in an array. You will have to do one then the other. e.g. <?php $args = array( ‘post_type’ => ‘property’, ‘meta_query’ => array( array( ‘relation’ => ‘AND’, ‘city_clause’ => array( ‘key’ => ‘city’, ‘compare’ => ‘EXISTS’, ), ‘street_clause’ => array( ‘key’ => ‘street_name’, ‘compare’ … Read more
Case #1: Simple Offset You want to ‘offset’ posts of a category archive by ‘n’, i.e. you simply don’t want to show the first/latest ‘n’ posts in an archive. That is, (considering the posts_per_page setting in WP Dashboard > Settings > Reading is set to 10) you want posts 11 to 20 to be shown … Read more
Revisited and simplified answer: You can try: $args = [ ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘category_name’ => ‘projects’, ‘_name__like’ => ‘proj*’ // <– our new input argument! ]; $my_query = new WP_Query( $args ); where we’ve created the _name__like input argument. It supports wildcard *, for example: ‘_name__like’ => ‘a*b*’ Note that draft posts … Read more
If you need to: page the query retain 12 posts per page instead of “sticking” the desired posts on top of the required 12 only need to show those posts on the first page you can try the following $ids_args = [ ‘post_type’ => ‘products’ ‘posts_per_page’ => -1, ‘orderby’ => ‘meta_value_num’, ‘meta_key’ => ‘_price’, ‘order’ … Read more
Use the fields argument to grab just the ID – will save you a ton of memory 😉 $product_ids = get_posts( array( ‘posts_per_page’ => -1, ‘post_type’ => array( ‘product’, ‘product_variation’ ), ‘fields’ => ‘ids’, ) );