SELECT
Site.id,
MIN(Apartmentsfirst.stotal) AS stotal_min,
MAX(Apartmentsfirst.stotal) AS stotal_max
FROM VeRTak\Models\Site Site
JOIN VeRTak\Models\SiteComplexes SiteComplexes
ON SiteComplexes.siteid = Site.id
JOIN VeRTak\Models\Apartmentsfirst Apartmentsfirst
ON Apartmentsfirst.complexid = SiteComplexes.complexid
WHERE Site.domain LIKE :domain:

[stotal_min] => 101.10
[stotal_max] => 98.95

[stotal_min] => 101
[stotal_max] => 99