If we have the query arguments like this $args = array( ‘queryid’ => ‘blackjack’, … ); $q = new WP_Query( $args ); Note we added one custom query argument that is not officially present in here. Now we can identify the exact query by that queryid if we use the second parameter of the posts_where … Read more
Following Milo‘s answer, I found another workaround that works and i’m more confortable with it. $args = array( ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘category__in’ => array(15, 17), ‘posts_per_page’ => 4 ); $query = new WP_Query(); $items = $query->query($args);
Here’s the culprit: [meta_query] => Array ( [0] => Array ( [key] => city [value] => Las Vegas [compare] => = ) ) Meta queries are slow, and the only way to speed them up is to not use meta queries. The post meta table is optimised for fetching key/value pairs where the post ID … Read more
You need to convert your saved format to the post_date format which is in Y-m-d H:i:s Only then will the comparators work properly with automatically generated query objects.
If you want to be able to get the category by name, this should work: SELECT DISTINCT substr(post_title, – instr(reverse(post_title), “https://wordpress.stackexchange.com/”) + 1) AS year FROM {$wpdb->posts} p LEFT JOIN {$wpdb->term_relationships} rel ON rel.object_id = p.ID LEFT JOIN {$wpdb->term_taxonomy} tax ON tax.term_taxonomy_id = rel.term_taxonomy_id LEFT JOIN {$wpdb->terms} t ON t.term_id = tax.term_id WHERE post_status=”publish” AND … Read more
Your template code includes $wpdb->print_error(). This function prints the last database error between [ and ] brackets, and the executed SQL code. But if there is no error, you just see the empty brackets and the SQL. $wpdb->show_errors() is used to enable displaying of database errors. If you want to see all database errors, you … Read more
Search in WordPress is complicated matter because: WP doesn’t do it very well out of the box People tend to have varied expectations of how precisely search should work Even light (from human perspective) requirements for search tend to translate in complicated and involved code Building search from scratch is involved (I know because I … Read more
Of course it breaks. Pagination depends on the main query saved in the $wp_query object and you have overwritten that. When the next page load the ordinary wp_query that you have not overwritten will run and it won’t match the one you’ve altered. Create a filter for pre_get_posts to alter the main query. function pregp_wpse_97354($qry) … Read more
The following query retrieves the oldest post of a specified user/author: $user_id = 42; // or whatever it is $args = array( ‘posts_per_page’ => 1, ‘post_status’ => ‘publish’, ‘author’ => $user_id, ‘orderby’ => ‘date’, ‘order’ => ‘ASC’, ); $first_post = new WP_Query($args); if ($first_post->have_posts()) { $first_post->the_post(); // Now you can use `the_title();` etc. wp_reset_postdata(); } … Read more
When the wp_enqueue_scripts action fires, the main query has already run and the posts are in the global $wp_query. We just need to grab the ID from each object in $wp_query->posts, the wp_list_pluck function makes that easy: function wpd_get_post_ids(){ if( is_archive() ){ global $wp_query; $post_ids = wp_list_pluck( $wp_query->posts, ‘ID’ ); // $post_ids now contains an … Read more