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