this should be enough:
```
DELETE FROM map_channelgroups_channels m LEFT JOIN channels c ON (c.idChannel = m.idChannel) WHERE c.idChannel IS NULL
```
(without m after DELETE)