Maybe with SQL, but I wouldnt suggest it, so you have two options: Query a full list, and then check your condition on each post retrieved. or Save the product of those three fields in another meta field, which can then be queried. EDIT: For the second method, it really depends on the context. if … Read more
The main issue in your code is this part: $query->set(‘orderby’,’meta_value_date’); whereby you should use meta_value and not meta_value_date. (There is meta_value_num, but that’s not suitable for used with sorting by dates.) Then make sure the meta_type is set to DATE (which yes, you already done it correctly), and use the right date format — 10132020 … Read more
Why don’t you use WordPress get_posts? You can add the parameter orderby => ‘title’ as you want. $args = array( ‘posts_per_page’ => -1, ‘order’ => ‘ASC’, ‘orderby’ => ‘title’ ); $posts = get_posts( $args ); print_r($posts); If you want the sql you can just add ORDER BY post_title: SELECT * FROM $wpdb->posts WHERE post_type=”post” AND … 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’);
Set below code : <?php if (is_category()) { $posts = query_posts($query_string .’&orderby=title&order=asc’); } ?> You can exclude if condition if do not using category. For more reference: Alphabetizing Posts
You are very close. I had the same problem a while ago, and blogged about it. Your join is missing one more join table, wp_terms, which has the term you want to sort on. Here is the code I used: class OrderWpscProducts { // flag for when a shop products post query is being created … Read more
Order by custom field meta_key date and then by custom file meta_key number
bbPress plugin: forum lists not showing in correct order? [closed]
How to order posts by meta_value and title
Manage Columns : order by post_parent’s title