Post meta data was never designed to be used efficiently in queries. Using it with LIKE based matching will only make it more horrible. You need to rethink your DB. For example use taxonomy terms to indicate which social network is associated with a post.
The value passed to reset() is passed by reference, which means technically it modifies the original variable that’s passed to it. For this to work you need to pass a variable, not a function that returns a value. reset() rewinds array’s internal pointer to the first element and returns the value of the first array … Read more
$wpdb->wp_postmeta is wrong. Always use just $wpdb->postmeta – without further prefixes. So… global $wpdb; $querystr = ” SELECT DISTINCT meta_value FROM $wpdb->postmeta WHERE meta_key LIKE ‘movie_name’ ORDER BY meta_value ASC “; $movie_names = $wpdb->get_results( $querystr, OBJECT ); if ( ! $movie_names ) { $wpdb->print_error(); // Get the last error message for debugging } else { … Read more
Use a meta_query and set type to NUMERIC– $query->set(‘meta_query’, array( array( ‘key’ => ‘_ai_price_int’, ‘value’ => array(0, 4000), ‘compare’ => ‘BETWEEN’, ‘type’ => ‘NUMERIC’ ) )); $query->set(‘meta_key’, ‘_ai_price_int’); $query->set(‘orderby’, ‘meta_value_num’);
pre_get_posts triggers for every query (front and admin side). It also triggers when querying nav-menu items (which is what is happening here). Most of the time you only want to filter particular queries – so you need to check if that query is one you wish to modify. Usually – and I think your example … Read more
Finally, this meta_query works : ‘meta_query’ => array( ‘relation’ => ‘OR’, array( ‘key’ => ‘votes_average’, ‘value’ => ‘6’, ‘compare’ => ‘<‘, ‘type’ => ‘NUMERIC’, ), array( ‘key’ => ‘votes_average’, ‘compare’ => ‘NOT EXISTS’, ‘value’ => ‘null’, ) ),
Remove the quotes around the values for your second meta query. You’re comparing numbers to chars, which won’t work.
It is a little more convoluted, but main queries for admin can be modified roughly in a same way as front end. You would need to: hook into pre_get_posts check for is_admin() check for is_main_query() check for specific page you want to adjust apply your adjustments to the query if all matches
Pre Get Posts / Multiple Meta Keys / Orderby Single Key
I did it this way: $name = explode(‘ ‘, $name); foreach($name as $string) { $args[‘meta_query’][] = array( ‘key’ => ‘name’, ‘value’ => $string, ‘compare’ => ‘LIKE’ ); } Which works good, but I’m not sure if that’s the best solution.