MythTV Record

mysql> select * from oldrecorded where title LIKE '%FOX%'\G
*************************** 1. row ***************************
     chanid: 1002
  starttime: 2013-12-05 15:00:00
    endtime: 2013-12-05 16:00:00
      title: FOX2 News at 10AM
   subtitle:
description:
     season: 0
    episode: 0
   category: News
   seriesid: EP01446781
  programid: SH014467810000
    inetref:
     findid: 0
   recordid: 349
    station: WJBK
    rectype: 1
  duplicate: 1
  recstatus: -3
 reactivate: 0
    generic: 0
     future: 0
*************************** 2. row ***************************
     chanid: 1002
  starttime: 2013-12-05 16:00:00
    endtime: 2013-12-05 17:00:00
      title: FOX2 News: Live at 11am
   subtitle:
description: Sherry Margolis.
     season: 0
    episode: 0
   category: News
   seriesid: EP00775315
  programid: SH007753150000
    inetref:
     findid: 0
   recordid: 350
    station: WJBK
    rectype: 1
  duplicate: 0
  recstatus: -2
 reactivate: 0
    generic: 0
     future: 0
2 rows in set (0.01 sec)

mysql> select * from recorded where recordid=350\G
*************************** 1. row ***************************
         chanid: 1002
      starttime: 2013-12-05 16:00:01
        endtime: 2013-12-05 17:00:01
          title: FOX2 News: Live at 11am
       subtitle:
    description: Sherry Margolis.
         season: 0
        episode: 0
       category: News
       hostname: mythtv1.lan
       bookmark: 0
        editing: 0
        cutlist: 0
     autoexpire: 10000
    commflagged: 0
       recgroup: LiveTV
       recordid: 350
       seriesid: EP00775315
      programid: SH007753150000
        inetref:
   lastmodified: 2013-12-05 12:00:01
       filesize: 1411442524
          stars: 0
previouslyshown: 1
originalairdate: 2005-09-12
       preserve: 0
         findid: 0
  deletepending: 0
     transcoder: 0
    timestretch: 1
    recpriority: 0
       basename: 1002_20131205160001.mpg
      progstart: 2013-12-05 16:00:00
        progend: 2013-12-05 17:00:00
      playgroup: Default
        profile: Default
      duplicate: 0
     transcoded: 0
        watched: 0
   storagegroup: LiveTV
 bookmarkupdate: 0000-00-00 00:00:00
*************************** 2. row ***************************
         chanid: 1002
      starttime: 2013-12-05 16:00:00
        endtime: 2013-12-05 17:00:30
          title: FOX2 News: Live at 11am
       subtitle:
    description: Sherry Margolis.
         season: 0
        episode: 0
       category: News
       hostname: mythtv1.lan
       bookmark: 0
        editing: 0
        cutlist: 0
     autoexpire: 1
    commflagged: 0
       recgroup: LiveTV
       recordid: 350
       seriesid: EP00775315
      programid: SH007753150000
        inetref:
   lastmodified: 2013-12-05 12:00:30
       filesize: 1431619436
          stars: 0
previouslyshown: 1
originalairdate: 2005-09-12
       preserve: 0
         findid: 0
  deletepending: 0
     transcoder: 0
    timestretch: 1
    recpriority: 0
       basename: 1002_20131205160000.mpg
      progstart: 2013-12-05 16:00:00
        progend: 2013-12-05 17:00:00
      playgroup: Default
        profile: Default
      duplicate: 0
     transcoded: 0
        watched: 0
   storagegroup: Default
 bookmarkupdate: 0000-00-00 00:00:00
2 rows in set (0.00 sec)

mysql>