order the meta query results by 2 custom fields

You forgot to use relation in meta_query . I think this will work: $args = array( ‘post_type’ => ‘brewery’, ‘post_status’ => ‘publish’, ‘posts_per_page’ => -1, ‘meta_query’ => array( ‘relation’ => ‘AND’, ‘review_rating_meta’ => array( ‘key’ => ‘review_rating’, ), ‘reveiw_count_meta’ => array( ‘key’ => ‘reveiw_count’, ), ), ‘orderby’ => array( ‘review_rating_meta’ => ‘DESC’, ‘reveiw_count_meta’ => ‘DESC’, … Read more

Admin slow on Postlist (over 30k Posts in Database)

Perhaps this filter can help you to modify the query for the specific post type and inside wp-admin as per the documentation, this filter is called before the query is executed so you can modify/optimize the query with the help of this filter. do_action_ref_array( ‘pre_get_posts’, WP_Query $query ) further reference: https://developer.wordpress.org/reference/hooks/pre_get_posts/