As far as I remember category__not_in takes array of IDs, which are pain to use when written as string. For single category it would is easier to write it as cat=-14 (minus before ID). See Category Parameters in Codex. PS I think you meant query_posts(), not query()?..
You were starting on the right track but you had several bits of WordPress hookage you still needed to add. An approach I like to use is to encapsulate a call to get_calendar() in a class so we can use the low-level ‘query’ hook but only use for it for the one call. So I … Read more
Hi @kaiser: Consider using the Transients API instead, that’s what it is built for. http://codex.wordpress.org/Transients_API
As t31os said, you can’t do that using WP_Query directy. You can attempt to use the ‘posts_clauses’ filter to modify the individual SQL clauses generated by WP_Query, but it will be quite tricky, however you do it. Instead, it might be easier to replace the entire SQL query. You can use get_tax_sql() to take care … Read more
Why can you not use the core functions previous_posts_link()/next_posts_link() or posts_nav_link(), all of which already account for the taxonomy archive context? EDIT: I think I understand your question now. You want pagination links, rather than previous/next page links. WordPress also has a native function for pagination links: paginate_links() (Codex ref). Here’s how I use this … Read more
As long as you use WP API ($wpdb) to perform queries, they will be cached by caching plugins (well, by those that have such functionality). If you need to cache data that is more compelx to generate rather than just retrieve look into Transients API.
Have a look at this question for a fairly simple solution. Basically, create a plugin to contain your code, add a rewrite rule to intercept any requests that match your custom url, and parse or pass whatever data they contain to your plugin, which can then use those variables to produce whatever output you need. … Read more
You have to do a join or a subquery: $querystr = ” SELECT $wpdb->posts.ID FROM $wpdb->posts WHERE $wpdb->posts.post_type=”post” AND $wpdb->posts.post_date < NOW() AND $wpdb->posts.ID NOT IN ( SELECT DISTINCT post_id FROM $wpdb->postmeta WHERE meta_key = ‘_social_’ ) ORDER BY $wpdb->posts.score DESC LIMIT 1; “;
As you can see on http://codex.wordpress.org/Function_Reference/get_pages you can query by meta_key , so to query by product custom field, you will do something like this . $args=array( ‘meta_key’ => ‘product’ ); $pages = get_pages( $args );
You can try to make use of filters in query (likely posts_where) to make it look for match between clean value and MySQL REGEXP command (if it fits, didn’t use it myself) with your logic, run on raw value.