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 = 21) 
                    
            ) t
        Array
(
    [0] => stdClass Object
        (
            [term_taxonomy_id] => 54
            [name] => Delux Apartment with balcony
            [object_id_min] => 4270
            [object_id_max] => 4270
        )

    [1] => stdClass Object
        (
            [term_taxonomy_id] => 53
            [name] => Apartment with balcony
            [object_id_min] => 4273
            [object_id_max] => 4273
        )

    [2] => stdClass Object
        (
            [term_taxonomy_id] => 57
            [name] => One-Bedroom Apartment
            [object_id_min] => 4276
            [object_id_max] => 4276
        )

    [3] => stdClass Object
        (
            [term_taxonomy_id] => 56
            [name] => Penthouse Apartment with terrace
            [object_id_min] => 4280
            [object_id_max] => 4280
        )

    [4] => stdClass Object
        (
            [term_taxonomy_id] => 55
            [name] => Studio Apartment
            [object_id_min] => 4282
            [object_id_max] => 4282
        )

    [5] => stdClass Object
        (
            [term_taxonomy_id] => 58
            [name] => Superior Apartment
            [object_id_min] => 4287
            [object_id_max] => 4287
        )

)

Array
(
    [post_type] => eagle_rooms
    [post__in] => Array
        (
            [0] => 4270
            [1] => 4270
            [2] => 4273
            [3] => 4273
            [4] => 4276
            [5] => 4276
            [6] => 4280
            [7] => 4280
            [8] => 4282
            [9] => 4282
            [10] => 4287
            [11] => 4287
        )

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