select
	drmn.date,
	drmn.did,
	drmn.minutes
from zenoreport.daily_radio_minutes_new drmn
where date = date_sub(current_date, interval 1 day)
	or date = date_sub(current_date, interval 7 day);