Custom field data is stored in the postmeta table, and it’s likely that scanning through this table is causing slowness. You should: install the debug bar plugin which will give you more insight into the queries that are being executed against the database – you’ll be able to see how long each query takes, and … Read more
Yes there is, the_posts gets called just after the posts have been selected from the database and it passes an array of $posts as a first parameter and the $wp_query object as second parameter to your hooked function.
According to the Codex, here’s how you would query posts from several taxonomies: ‘tax_query’ => array( ‘relation’ => ‘AND’, array( ‘taxonomy’ => ‘videoscategory’, ‘field’ => ‘slug’, ‘terms’ => $custom_term->slug ), array( ‘taxonomy’ => ‘yourothertaxonomy’, ‘field’ => ‘slug’, ‘terms’ => $other_custom_term->slug ) )
Use either: $the_query = new WP_Query(‘posts_per_page=2&category_name=events’); or $the_query = new WP_Query(array( ‘posts_per_page’ => 2, ‘category_name’ => ‘events’, // this is the category SLUG )); // EDIT Please note that category_name actually is the category slug (which is for one-word names originally the same). It is not the actual name (maybe having spaces, special characters etc. … Read more
A meta_query is an array of arrays. Look at the examples in the the Codex. $args = array( ‘post_type’ => ‘my_custom_post_type’, ‘meta_key’ => ‘age’, ‘orderby’ => ‘meta_value_num’, ‘order’ => ‘ASC’, ‘meta_query’ => array( array( ‘key’ => ‘age’, ‘value’ => array(3, 4), ‘compare’ => ‘IN’, ) ) ); $query = new WP_Query($args); What you have is … Read more
I needed to get post with type event and the custom field “date” later than today, this sample of code worked perfectly for me, I hope it helps to someone in a similar situation. $today = date(“Y-m-d”); $today1 = date(“Ymd”, strtotime(“$today”)); $custom_meta = array( array( ‘key’ => ‘data_de_inicio’, ‘value’=>$today1, ‘compare’=>’>’, ‘type’=>’date’, ), ); $query = … Read more
The orderby-parameter should be post_date instead of date. your code would look something like this: $blogs = get_last_updated(‘ ‘, 0, 1); foreach ($blogs AS $blog) { switch_to_blog($blog[“blog_id”]); $args = array( ‘orderby’ => ‘post_date’, ‘order’ => ‘DESC’, ‘numberposts’ => 1, ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘suppress_filters’ => true ); $lastposts = get_posts( $args ); foreach($lastposts … Read more
In my personal opinion, this can get a bit resource intensive, so you will need to implement some type of cache system, or even look at transient What you want to do is to extent your current post view function or even create one on the side for this. You would want to capture each … Read more
The ‘the_posts’ filter hook allows you to edit posts that are going to be displayed in a loop. It’s fired for all queries (the main and the secondaries) so you need to check that the query you’re acting on is the right one. That said in your case you can: send a query variable to … Read more
You’re gonna need regular expressions to accomplish that. First of all, you need to change ‘LIKE’ to ‘RLIKE’ (or ‘REGEXP’). Second, replace $keyword in ‘value’ with a regex that involves word boundaries. Like so: $queryArgs = array( ‘post_type’ => ‘faculty’, ‘posts_per_page’ => -1, ‘meta_query’ => array( ‘relation’ => ‘OR’, array( ‘key’ => ‘proposed_keywords’, // name … Read more