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
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.
If I understood you right… [A] Multi-Tax queries have the problem that they’re doing a JOIN of the meta table for every term. So imho it’s not the best idea to use the built in way. [B.1.a] I’d simply do a normal query with a one (main-)tax arg and then do the sorting depending on … Read more
I have found that the best way to include WordPress pages into a fancybox is to create a new template to use for those pages. For example I have some of my contact forms in a fancy box and the template I use is called custom-page-plain.php and doesn’t call header.php and contains a link to … Read more
<?php $querystr = ” SELECT wposts.* FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta WHERE wposts.ID = wpostmeta.post_id AND wpostmeta.meta_key = ‘date_field’ AND wpostmeta.meta_value=”03/11/2010″ AND wposts.post_status=”publish” AND wposts.post_type=”post” ORDER BY wposts.post_date DESC “; $pageposts = $wpdb->get_results($querystr, OBJECT); ?> Then you would access $pageposts as an object
I think your issue is that wp_pagenavi() is doing pagination based off of the global $wp_query instance instead instance you created. You should either switch to using query_posts() to replace the global query instead, or use WordPress’ built in paginate_links to output the paging.
The situation An array like array( 1,2,3,4,2,5 ) will be read like the following: Array( 0 => 1 ,1 => 2 ,2 => 3 ,3 => 4 ,4 => 2 ,5 => 5 ) [length = 6 ] which seems ok. But when you look at the WP_Query object, you’ll see the following part added … Read more
Here’s a plan: Store the dates as individual custom fields with the same meta_key (ex: start_date) JOIN the wp_posts table with the wp_postmeta table, without a GROUP BY (to allow the same event to appear more than once) ORDER BY start_date The full query would look like this: SELECT wp_posts.*, meta_value AS start_date FROM wp_posts … Read more
Here’s one solution: global $wpdb; $cat_array = $wpdb->get_results( ” SELECT terms.*, posts.ID as post_ID FROM wp_terms terms JOIN wp_term_taxonomy term_taxonomy ON terms.term_id = term_taxonomy.term_id JOIN wp_term_relationships term_relationships ON ( term_relationships.term_taxonomy_id = term_taxonomy.term_taxonomy_id AND term_taxonomy.taxonomy = ‘category’ ) JOIN wp_posts posts ON ( posts.ID = term_relationships.object_id AND posts.post_type=”post” AND posts.post_status=”publish” ) GROUP BY terms.term_id ORDER BY … Read more