select
	a.gateway_id,
	b.title,
	c.title,
	sum(a.total_minutes)
from report_total_minutes_by_day a
	inner join data_gateway b on a.gateway_id = b.id
	inner join data_group_rca c on b.rca_id = c.id
where b.is_deleted = 0
	and c.is_deleted = 0
	and a.report_date = current_date
group by a.gateway_id