Is this possible via query args? I don’t think so. Is this possible via ‘posts_where’? It is probably doable using some ‘posts_*’ filters, not only with ‘posts_where’. Or maybe using ‘posts_request’ filter to completely oveeride the query. Do I need to run a separate query and then somehow merge the results? That would be the … Read more
Digging through the source code I couldn’t really find any weird logic that would cause ‘category__in’ to break the ordering of the results. If you do, you might as well file a bug in the WordPress Trac. It’s also hard to reproduce this sort of issue, because it might depend on another issue which is … Read more
Here is some code doing what you’ve asked and using the ideas others have highlighted: <?php if ( false === ( $totd_trans_post_id = get_transient( ‘totd_trans_post_id’ ) ) ) { $args = array(‘numberposts’ => 1, ‘orderby’ => ‘rand’); $totd = get_posts($args); $midnight = strtotime(‘midnight +1 day’); $timenow = time(); $timetillmidnight = $midnight – $timenow; echo $midnight; … Read more
I’ve never had any luck getting the meta compare to work either–but I came up with a workaround for this exact situation (having “featured” items at the top of the page). First, you probably shouldn’t be using query_posts for both queries. You should use a custom query for at least the first one. Then, while … Read more
query_posts will do the query again (destroy current wp_query and create a new one and then doing the query with the parameters you pass to it) To get the same behaviour after setting the new parameter with set_var you need to query the database again using something like this $wp_query->set(‘posts_per_page’, 1); $wp_query->query($wp_query->query_vars);
Do you have the “paged” parameter in the URL of the page(s) that you are trying to use get_query_var with? As far as I know get_query_var(“paged”) is explicitly returning the value of the URL param so you need to have a URL like this for it to work: /?paged=7 Alternatively you could read the URL … Read more
Starting in WordPress 3.5, the orderby parameter will allow the value post__in to sort by the order of the post__in parameter, just like in your example. It may not be ideal to wait or require 3.5+, but this will almost certainly be the best and easiest way to do what you’re looking to do. Here’s … Read more
should it be.. $paged = (get_query_var(‘page’)) ? get_query_var(‘page’) : 1; WP_Query in codex: Pagination Note: You should set get_query_var( ‘page’ ); if you want your query to work with pagination. Since WordPress 3.0.2, you do get_query_var( ‘page’ ) instead of get_query_var( ‘paged’ ). The pagination parameter ‘paged’ for WP_Query() remains the same.
Ok I figured it out. Here’s the optimized code: // Show only posts related to current user add_action(‘pre_get_posts’, ‘query_set_only_author’ ); function query_set_only_author( $wp_query ) { global $current_user; if( is_admin() && !current_user_can(‘edit_others_posts’) ) { $wp_query->set( ‘author’, $current_user->ID ); add_filter(‘views_edit-post’, ‘fix_post_counts’); } } // Fix post counts function fix_post_counts($views) { global $current_user, $wp_query; unset($views[‘mine’]); $types = array( … Read more
If the query is only for a small number of posts, then as linked to by Alex you can sort in php. However, this does not scale well. As suggested by Kovshenin – a better alternative is to use posts_orderby filter: $post_ids = array(83,24,106,2283,14); $args = array( ‘post_type’ => ‘post’, ‘post__in’ => $post_ids, ‘numberposts’ => … Read more