No subject


Thu Sep 20 15:16:44 UTC 2007


"SELECT DISTINCT channel.chanid, channel.sourceid, "
program.starttime, program.endtime, "
program.title, program.subtitle, program.description, "
channel.channum, channel.callsign, channel.name, "
oldrecorded.endtime IS NOT NULL AS oldrecduplicate, program.category, "
RECTABLE.recpriority, "
RECTABLE.dupin, "
recorded.endtime IS NOT NULL AS recduplicate, "
oldfind.findid IS NOT NULL AS findduplicate, "
RECTABLE.type, RECTABLE.recordid, "
program.starttime - INTERVAL RECTABLE.startoffset minute AS recstartts, "
program.endtime + INTERVAL RECTABLE.endoffset minute AS recendts, "
program.previouslyshown, RECTABLE.recgroup, RECTABLE.dupmethod, "
channel.commfree, capturecard.cardid, "
cardinput.cardinputid, UPPER(cardinput.shareable) = 'Y' AS shareable, "
program.seriesid, program.programid, program.category_type, "
program.airdate, program.stars, program.originalairdate, RECTABLE.inactive, "
RECTABLE.parentid, ") + progfindid + ", RECTABLE.playgroup, "
oldrecstatus.recstatus, oldrecstatus.reactivate, "
channel.recpriority + cardinput.recpriority, "
RECTABLE.prefinput, program.hdtv, program.closecaptioned, "
program.first, program.last, program.stereo "
+ QString(
FROM recordmatch "

 INNER JOIN RECTABLE ON (recordmatch.recordid = RECTABLE.recordid) "
 INNER JOIN program ON (recordmatch.chanid = program.chanid AND "
                        recordmatch.starttime = program.starttime AND "
                        recordmatch.manualid = program.manualid) "
 INNER JOIN channel ON (channel.chanid = program.chanid) "
 INNER JOIN cardinput ON (channel.sourceid = cardinput.sourceid) "
 INNER JOIN capturecard ON (capturecard.cardid = cardinput.cardid) "
 LEFT JOIN oldrecorded as oldrecstatus ON "
  ( oldrecstatus.station = channel.callsign AND "
    oldrecstatus.starttime = program.starttime AND "
    oldrecstatus.title = program.title ) "
 LEFT JOIN oldrecorded ON "
  ( "
    RECTABLE.dupmethod > 1 AND "
    oldrecorded.duplicate <> 0 AND "
    program.title = oldrecorded.title "
     AND "
     ( "
      (program.programid <> '' AND program.generic = 0 "
       AND program.programid = oldrecorded.programid) "
      OR "
      (oldrecorded.findid <> 0 AND "
        oldrecorded.findid = ") + progfindid + QString(") "
      OR "
      ( "
       program.generic = 0 "
       AND "
       (program.programid = '' OR oldrecorded.programid = '') "
       AND "
       (((RECTABLE.dupmethod & 0x02) = 0) OR (program.subtitle <> '' "
          AND program.subtitle = oldrecorded.subtitle)) "
       AND "
       (((RECTABLE.dupmethod & 0x04) = 0) OR (program.description <> '' "
          AND program.description = oldrecorded.description)) "
      ) "
     ) "
  ) "


More information about the mythtv-users mailing list