use vidux_dispatcher

select
	n.alias,
	c.channelNumber,
	a.propertiesString like '%"roiInfo":{"activeRegions":[],"gridX":10,"gridY":10,"qualityLevel":3}%' as defaultRoi
from ChannelData as c, NVRData as n, AnalyticsData as a
where n.status='ON'
	and c.channelNumber like 'I%'
	and c.status in ('AVAILABLE', 'VIDEOLOSS')
	and c.nvr_id=n.id
	and c.analytics_id=a.id
order by alias, channelNumber
;