select `obs_pricings`.`id` as `id`, `capacity_categories`.`id` as `capacity_category_id`, `capacity_categories`.`name` as `capacity_categores`, MIN(storage_capacities.count) as min_unit_size, MAX(storage_capacities.count) as max_unit_size from `obs_pricings` leftjoin `storage_capacities` on `storage_capacities`.`id` = `obs_pricings`.`unit_size` leftjoin `capacity_categories` on `capacity_categories`.`id` = `obs_pricings`.`capacity_categores` groupby `obs_pricings`.`capacity_categores` orderby `storage_capacities`.`count` asc