One possibility is a direct SQL query similar to the one given here. But I’m not convinced that it would be much more efficient than 2 queries, all handled by WordPress: The is untested $price =0; //Price of current property $id=0; //Property (post) ID. $args = array( ‘post_type’ => ‘property’, ‘post__not_in’=>array($id), ‘posts_per_page’=> 2, ‘meta_query’ => … Read more
You can filter the members loop in BuddyPress by meta values for the members. So you would need to change the loop in the template file members/members-loop.php to be: <?php // Getting current blog_id global $wpdb, $current_blog; $id = $current_blog->blog_id; // Setting variable for current blog_prefix $blog_prefix = $wpdb->get_blog_prefix( $id ); // Start the BuddyPress … Read more
Perhaps try using ‘category__and’ instead? E.g. ‘category__and’ => array(1,3) http://codex.wordpress.org/Function_Reference/query_posts
You can do everything you need using the search parameters allowed in WP_Query — except searching in the post title only. In order to do that, see this answer. Make sure to look at the taxonomy and meta subqueries allowed in the args passed to WP_Query. EDIT: Since you need to select using OR, you … Read more
I’d like to see what the actual generated SQL is that WP_Query is using, but for now. ( You can use http://wordpress.org/extend/plugins/debug-bar/ to easily view the SQL query ) Queries ordered by ‘random’ are inefficient. If you don’t need that remove it. If you do need a random order, consider removing it anyway and using … Read more
This can be done by getting an array of category ids you want to show. We can use get_terms() for this: $taxonomy = array( ‘category’ ); $args = array( ‘exclude’ => array(‘111’),//id of the category term you want to exclude ‘fields’ => ‘ids’ ); $ct_ids = get_terms( $taxonomy, $args ); Now you can use this … Read more
It sounds like you’re looking for wp_localize_script() which lets you pass data to a script that is already enqueued. It works roughly like this: <?php // assuming your script is already registered wp_enqueue_script( ‘wpse_81817’ ); // Do the array building of terms you plan on doing $wpse_81817_phpdata = array( ‘myKey’ => ‘a value’ ); // … Read more
Your problem is this: CAST(wp_postmeta.meta_value AS SIGNED) Run a simple SQL query (command line or PhpMyAdmin, whatever you like) like SELECT CAST(‘1.2’ as SIGNED) and you will see that the value returned is 1. What causes that cast is ‘type’ => ‘NUMERIC’,. You can pass DECIMAL to meta_query instead of NUMERIC but I don’t see … Read more
The problem in your code is ‘meta_query’ code is write insde array of array $args = array( ‘post_status’ => ‘publish’, ‘post_type’ => ‘participant’, ‘order’ => ‘DESC’, ‘meta_key’ => ‘participant_partage_class’, ‘orderby’ => ‘meta_value_num, ‘meta_query’ => array(array( ‘key’ => ‘participant_partage_class’, ‘type’ => ‘SIGNED’, ‘compare’ => ‘>’, )), ‘posts_per_page’ => ‘8’, ‘paged’ => $paged ); $query = new … Read more
I tried this query and it seemed to work quite nicely. Hopefully it helps you as well! $args = array( ‘post_type’ => ‘cbd_team_members’, ‘posts_per_page’ => -1, ‘paged’ => $paged, ‘orderby’ => ‘title’, ‘order’ => ‘ASC’, ‘meta_value’ => $search, ‘meta_compare’ => “like” ); $loop = new WP_Query( $args );