update channel set name = CONCAT(name,' (DVB-C)') where not name like '%DVB-%' and sourceid in (select sourceid from videosource where name = 'DVB-C') ; update channel set name = CONCAT(name,' (DVB-T)') where not name like '%DVB-%' and sourceid in (select sourceid from videosource where name = 'DVB-T') ; update channel set name = CONCAT(name,' (Kab.)') where not name like '%Kab.%' and not name like '%Analog%' and sourceid in (select sourceid from videosource where name = 'Kabel Analog') ;
update channel set visible = 0 where not chanid in ( select distinct(chanid) from program) ; update channel set visible = 1 where chanid in ( select distinct(chanid) from program) ;
This works of course only after you alread did get EPG data.