On Wed, 13 Apr 2022 22:21:48 +1200, you wrote: >create table xmltvids as select callsign,xmltvid from channel where >sourceid=1; Oops, this should be: create table xmltvids as select callsign,xmltvid from channel where sourceid=1 and deleted is null; I keep on forgetting about the new feature of deleted channels.