select
                t.term_taxonomy_id,
                t.name,
                (
                    select object_id 
                    from wp_term_relationships tr2
                    inner join wp_posts p on tr2.object_id = p.ID and p.post_status = "publish" 
                    inner join wp_postmeta pm11 on tr2.object_id = pm11.post_id and pm11.meta_key = "eagle_booking_mtb_room_min_booking_nights" 
                    where tr2.term_taxonomy_id = t.term_taxonomy_id
                    
                    order by pm11.meta_value, object_id
                    limit 1
    
                ) object_id_min,
                (
                    select object_id 
                    from wp_term_relationships tr2
                    inner join wp_posts p on tr2.object_id = p.ID and p.post_status = "publish" 
                    inner join wp_postmeta pm11 on tr2.object_id = pm11.post_id and pm11.meta_key = "eagle_booking_mtb_room_min_booking_nights" 
                    where tr2.term_taxonomy_id = t.term_taxonomy_id
                    
                    order by pm11.meta_value desc, object_id
                    limit 1
    
                ) object_id_max
            from (
                select distinct tr.term_taxonomy_id, t.name 
                from wp_term_relationships tr
                inner join wp_term_taxonomy tt on tr.term_taxonomy_id = tt.term_taxonomy_id and tt.taxonomy = "eagle_room_type"
                left join wp_terms t on tt.term_id = t.term_id
                inner join wp_postmeta pm12 on (pm12.post_id = tr.object_id) and (pm12.meta_key = "eagle_booking_mtb_room_maxguests") and (pm12.meta_value >= 1)
                 
                where 
                    tr.object_id in (select object_id from wp_term_relationships where term_taxonomy_id = 22) 
                    
            ) t
        Array
(
    [0] => stdClass Object
        (
            [term_taxonomy_id] => 51
            [name] => One bedroom 1+1+1+① - only long term
            [object_id_min] => 4263
            [object_id_max] => 4263
        )

    [1] => stdClass Object
        (
            [term_taxonomy_id] => 50
            [name] => One bedroom 1+1+①
            [object_id_min] => 4257
            [object_id_max] => 4261
        )

    [2] => stdClass Object
        (
            [term_taxonomy_id] => 49
            [name] => One bedroom 2+①
            [object_id_min] => 4237
            [object_id_max] => 4248
        )

    [3] => stdClass Object
        (
            [term_taxonomy_id] => 48
            [name] => Studio 1+1+①
            [object_id_min] => 4227
            [object_id_max] => 4233
        )

    [4] => stdClass Object
        (
            [term_taxonomy_id] => 47
            [name] => Studio 2+①
            [object_id_min] => 4222
            [object_id_max] => 4225
        )

    [5] => stdClass Object
        (
            [term_taxonomy_id] => 46
            [name] => Studio 1+1
            [object_id_min] => 3854
            [object_id_max] => 4215
        )

    [6] => stdClass Object
        (
            [term_taxonomy_id] => 45
            [name] => Studio 2
            [object_id_min] => 4192
            [object_id_max] => 4202
        )

    [7] => stdClass Object
        (
            [term_taxonomy_id] => 44
            [name] => Studio 1
            [object_id_min] => 3850
            [object_id_max] => 4179
        )

)

Array
(
    [post_type] => eagle_rooms
    [post__in] => Array
        (
            [0] => 4263
            [1] => 4263
            [2] => 4257
            [3] => 4261
            [4] => 4237
            [5] => 4248
            [6] => 4227
            [7] => 4233
            [8] => 4222
            [9] => 4225
            [10] => 3854
            [11] => 4215
            [12] => 4192
            [13] => 4202
            [14] => 3850
            [15] => 4179
        )

    [post_per_page] => -1
    [orderby] => meta_value_num
    [order] => ASC
    [meta_key] => eagle_booking_mtb_room_price
)