Prune old mythtv channels
Looking for a way to bulk remove channels that I’ve delselected in my channel lineup at Schedules Direct, I happened upon this blog post. Seems to work great :)
For the impatient, the important bit is this:
DELETE channel,program FROM channel NATURAL LEFT JOIN program WHERE program.title IS NULL;