I think it should be able to hook into the posts_clauses filter to add a field to your sql query. add_filter( ‘posts_clauses’, ‘intercept_query_clauses’, 20, 1 ); function intercept_query_clauses( $pieces ){ global $wpdb; $pieces[‘fields’].=’, (IF(UNIX_TIMESTAMP()>=’.$wpdb->postmeta.’.meta_value,’.$wpdb->postmeta.’.meta_value,(UNIX-TIMESTAMP() – ‘.$wpdb->postmeta.’.meta_value)+UNIX_TIMESTAMP(‘2099-01-01′))) as timestamp_direction’; $pieces[‘orderby’]=’timestamp_direction ASC’; return $pieces; } The logic is as follows: Let’s say you have some timestamps in … Read more