SELECT
                                Roomtypes.name, 
                                COUNT(*) AS count,
                                MAX(IF(Apartmentsfirst.t_stotal,Apartmentsfirst.stotal,Apartmentsfirst.n_stotal)) AS stotal_max, 
                                MIN(IF(Apartmentsfirst.t_stotal,Apartmentsfirst.stotal,Apartmentsfirst.n_stotal)) AS stotal_min,
                                MAX(IF(Apartmentsfirst.t_flatcostbase,Apartmentsfirst.flatcostbase,Apartmentsfirst.n_flatcostbase)) AS price_max, 
                                MIN(IF(Apartmentsfirst.t_flatcostbase,Apartmentsfirst.flatcostbase,Apartmentsfirst.n_flatcostbase)) AS price_min
                                FROM VeRTak\Models\SiteComplexes SiteComplexes
                                JOIN VeRTak\Models\Apartmentsfirst Apartmentsfirst
                                ON SiteComplexes.complexid = Apartmentsfirst.complexid
                                JOIN VeRTak\Models\Roomtypes Roomtypes
                                ON IF(Apartmentsfirst.t_roomtypeid = 1, Apartmentsfirst.roomtypeid, Apartmentsfirst.n_roomtypeid) = Roomtypes.id
                                WHERE SiteComplexes.siteid = $domain->id
                                GROUP BY 1

Результат

Mvc\Model\Row Object
(
    [name] => 1 ккв
    [count] => 653
    [stotal_max] => 58.66
    [stotal_min] => 31.08
    [price_max] => 4883445
    [price_min] => 2867130
)
Mvc\Model\Row Object
(
    [name] => 2 ккв
    [count] => 200
    [stotal_max] => 65.30
    [stotal_min] => 48.15
    [price_max] => 5905575
    [price_min] => 4526950
)
Mvc\Model\Row Object
(
    [name] => 3 ккв
    [count] => 35
    [stotal_max] => 84.67
    [stotal_min] => 77.18
    [price_max] => 7106400
    [price_min] => 6645915
)

Как сюда сюда добавить еще полностью информацию по квартире с минимальной ценной которая у каждого объекта price_min?

Спасибо заранее