Is there an easy way to do this without having to unserialize it? Not in any reliable way. You can certainly ORDER BY that value but the sorting will use the whole serialized string, which will give you technically accurate results but not the results you want. You can’t extract part of the string for … Read more
First things first, never use query_posts, it overwrites the main query and can cause unwanted side-effects. Use WP_Query instead. _wp_page_template is a post meta key, so the first thing we need to do is to load the value stored in that key for each page, using get_post_meta. That will give us the filename, which we … Read more
Allright, here’s how I got it working: Rewriting the query inside a template file wouldn’t work because the main query already found 0 results based on the wrong assumption that attachments should not be queried. Thus the template file doesn’t even run but jumps to 404.php where everything is too late. So one has to … Read more
Though all of the arguments are optional, paginate_links doesn’t necessarily do anything if there are no arguments. Take a look at the example at the example in the Codex. global $wp_query; $big = 999999999; // need an unlikely integer echo paginate_links( array( ‘base’ => str_replace( $big, ‘%#%’, esc_url( get_pagenum_link( $big ) ) ), ‘format’ => … Read more
Before I fire away, just one note, NEVER (my emphasis) make use of query_posts to create custom queries Note: This function isn’t meant to be used by plugins or themes. As explained later, there are better, more performant options to alter the main query. query_posts() is overly simplistic and problematic way to modify main query … Read more
When you specify a meta_key, query_posts() does an INNER JOIN between the wp_posts and wp_postmeta table. That means that any posts that don’t have any meta value for the key you specified won’t ever be returned in that query. In order to do what you need, you should use the same query you posted in … Read more
try using this fancy function that group the posts by term id that Scribu and Mike created: function event_clauses( $clauses, $wp_query ) { global $wpdb; if ( isset( $wp_query->query[‘orderby’] ) && ‘event_location’ == $wp_query->query[‘orderby’] ) { $clauses[‘join’] .=<<<SQL LEFT OUTER JOIN {$wpdb->term_relationships} ON {$wpdb->posts}.ID={$wpdb->term_relationships}.object_id LEFT OUTER JOIN {$wpdb->term_taxonomy} USING (term_taxonomy_id) LEFT OUTER JOIN {$wpdb->terms} USING … Read more
The only date format that sorts into human calendar order is “year/month/day”. The separators shouldn’t matter. If you left your dates in UNIX time format, as you get from strtotime, they would sort appropriately as well. I would recommend re-organizing your code to match one or the other of those formats. I would go further … Read more
I know it will be not regular answer and maybe not helpful. On big site (more 16k posts) we use SOLR server with module MLT (more like this) and results are more than good.
i think you’d have to use get_posts 5 different times. what about this: global $post; $posts = array(); //categories you want to pull latest posts from; $cats = (1,2,3,4,5); foreach($cats as $cat): $args = array( ‘numberposts’ => 1, ‘category’ => $cat ); $posts[] = get_posts($args); endforeach; if($posts): ?> <ul> <?php foreach( $posts as $post ) … Read more