Difference between revisions of "User:Rosenbluh"
From MythTV Official Wiki
m |
|||
Line 1: | Line 1: | ||
===SQL queries=== | ===SQL queries=== | ||
− | *Show episode list and episode numbers for a given show (or shows with similar names) | + | *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. |
:<code>select syndicatedepisodenumber as epnum,title,subtitle from recordedprogram where title like "%<SHOW_NAME_OR_FRAGMENT>%" order by title,syndicatedepisodenumber;</code> | :<code>select syndicatedepisodenumber as epnum,title,subtitle from recordedprogram where title like "%<SHOW_NAME_OR_FRAGMENT>%" order by title,syndicatedepisodenumber;</code> |
Revision as of 20:18, 1 April 2008
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;