I came across this same issue today. In both our situations, there is in fact a nice solution. Because the serialized data we are searching for, are simply IDs, and they are always wrapped in quotations, we just need to include the quotations as part of the query. This eliminates the problem of encountering false … Read more
Just a plugin concept … Add a form with a button to each user profile, post or wherever you want it named Follow or Unfollow. Show the button only if is_user_logged_in(). You may use a widget for the form. On form submit update a user meta named follows for the user who clicked the button … Read more
This might not have worked before, but WordPress’s meta queries now support the relation parameter. To complete what @s_ha_dum was looking to do, simply add the relation parameter (as OR) and add a second meta query for NOT EXISTS. Example: function searchExcludeOldMatches( $query ) { //if we’re on the admin panel, or it’s a search, … Read more
As of WordPress 3.4.1, there is no way, out of the box, to order by multiple meta values. Since we can’t do it cleanly, we’ll have to hack something together. We can hook into posts_orderby to manually modify the ordering. It’s not altogether pretty, but it will get the job done. Here’s an example: add_filter(‘posts_orderby’, … Read more
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
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
WordPress standard query sucks with multiple meta queries when orderby is set to meta key. After a lot of headaches and time lost I wrote a custom class that allow me to better handle that sort of things. Here there is a simplified version of my class, but it hould work for your purposes: class … Read more
I can see from above query that you are willing to do following thing. Get all post if property_size is 15 AND property-type is marla OR Kanal. The SQL will be like %marla% OR like %Kanal% this is equivalent to like %marla Kanal% this will not make much difference (I assume) So you can minimize … Read more
I don’t know if you can get one array to compare to the other directly, but you can create a loop to set up a meta_query array that will check for each of the IDs within the field separately: $tag_ids = wp_get_post_tags( $post->ID, array( ‘fields’ => ‘ids’ ) ); $meta_query = array(‘relation’ => ‘OR’); foreach … Read more