select
	a.broadcast_id,
	surb.user_id,
	su.email
from (
	select
		dc.broadcast_id,
		count(*) count_broadcast_id
	from data_content dc
	where is_deleted = 0
	group by dc.broadcast_id
) a
	inner join sys_user_resource_broadcast surb on surb.broadcast_id = a.broadcast_id
	inner join sys_user su on su.id = surb.user_id
where count_broadcast_id > 1;