Firstly, there’s no point in converting to ‘meta_query’ if you’re dealing with a single custom field. Secondly, ‘meta_query’ doesn’t handle ordering. Finally, since your date is in the ‘Ymd’ format, comparing them as numbers will produce incorrect results. In your initial code, they are compared as strings.
How about this? /** * Convert query string to meta query. */ function query_string_to_meta_query( $query_string ) { $meta_query = array( ‘relation’ => ‘AND’ ); foreach ( wp_parse_args( $query_string ) as $key => $value ) { $meta_query[] = array( ‘key’ => $key, ‘value’ => $value ); } return array( ‘post_type’ => array( ‘post’, ‘custom’ ), ‘meta_query’ … Read more
“My SQL doesn’t work” questions are difficult because they are nearly untestable without having the OP’s dataset, but… I think you may be making this too complicated. SELECT DISTINCT (p.ID), p.post_title FROM wp_posts p JOIN wp_postmeta pm1 ON p.ID = pm1.post_id JOIN wp_postmeta pm2 ON p.ID = pm2.post_id WHERE 1 = 1 AND p.post_type=”game” AND … Read more
You could also use the posts_orderby filter: function wpse155827_posts_orderby_price( $orderby ) { return str_replace( ‘wp_postmeta.meta_value’, ‘substr(wp_postmeta.meta_value, 1)’, $orderby ); } add_filter( ‘posts_orderby’, ‘wpse155827_posts_orderby_price’ ); $theQuery = new WP_Query( array( ‘orderby’ => ‘meta_value_num’, ‘meta_key’ => ‘price’, ‘order’ => ‘ASC’, ‘suppress_filters’ => false, ) ); remove_filter( ‘posts_orderby’, ‘wpse155827_posts_orderby_price’ );
You can add another array into your meta_query to include all posts from your second post type. Given in your example, you have 2 post types events news If you can pick a meta_key that only exists for news but doesn’t exist on events, then this set of args would return all news post types … Read more
The way you did in your code you are querying posts with the key rw_related_link. If I understood you right, you must use get_post_meta inside the loop. <?php while ($normal_query->have_posts()) { $normal_query->the_post(); $related_link = get_post_meta(get_the_ID(), ‘rw_related_link’, true); // The value you want is in $related_link variable. ?> <li><a href=”https://wordpress.stackexchange.com/questions/178321/<?php the_permalink(); ?>”><?php the_title(); ?></a></li> <?php } … Read more
Custom queries and sticky posts are quite a curve ball to work with. I don’t know how your setup looks and what exactly is your user case, but your best solution here would be to run two queries here, the first one to get your sticky posts and the other one to display normal posts … Read more
Date and time format meta_query requires the same format you used when storing the data of the meta fields. Some times different formats can be compared directly, but most of the time they aren’t. A recommend format to use is MySQL format: date format: YYYY-MM-DD (for PHP date functions: Y-m-d) time format: HH:MM:SS (for PHP … Read more
That’s not json. You can’t put a semi-colon inside a javaScript Object like that. That’s serialized-data. If you return that string & then call unserialize on it & then var_dump you can see what’s inside. Also, see fuxia♦’s Answer Here for more info. & to Maikal’s credit, you can use a meta_query in this situation, … Read more
Have you var_dumped $location? WP_Query‘s meta_query uses the class WP_Meta_Query, which automatically appends and prepends ‘%’ to any string passed to it: // From wp-includes/class-wp-meta-query.php:610 switch ( $meta_compare ) { // … case ‘LIKE’ : case ‘NOT LIKE’ : $meta_value=”%” . $wpdb->esc_like( $meta_value ) . ‘%’; $where = $wpdb->prepare( ‘%s’, $meta_value ); break; // … … Read more