User:Rosenbluh

From MythTV Official Wiki
Revision as of 20:18, 1 April 2008 by Rosenbluh (talk | contribs)

Jump to: navigation, search

SQL queries

  • Show episode list and episode numbers for a given show (or shows with similar names). This is useful so you don't have to press 'u' for every item in the frontend; mythweb only shows episode numbers for shows that have yet to be recorded.
select syndicatedepisodenumber as epnum,title,subtitle from recordedprogram where title like "%<SHOW_NAME_OR_FRAGMENT>%" order by title,syndicatedepisodenumber;