select
	date_sub(current_date, interval 1 day) yesterday,
	sl.content_id,
	dc.title stream_name,
	round(sum(case when date(sl.date) = date_sub(current_date, interval 1 day) then sl.seconds else 0 end)/60) minutes_yesterday,
	round(sum(case when date(sl.date) = date_sub(current_date, interval 7 day) then sl.seconds else 0 end)/60) minutes_last_week
from summary_listen sl
	left join data_content dc on dc.id = sl.content_id
where sl.content_id = 17580
	and sl.gateway_id = 333
	and (date(sl.date) = date_sub(current_date, interval 1 day)
	or date(sl.date) = date_sub(current_date, interval 7 day))