[mythtv-users] Duplicate detection

[Jan Ceuleers]

On 26/09/16 18:25, Jan Ceuleers wrote:
> Full disclosure: I'm not 100% certain about whether YYY is inserted
> before or after the INNER JOIN ... ON ... clauses, but I suspect before.

It's after, not before. I checked the source. So the query template becomes:

SELECT record.recordid, program.chanid, program.starttime, <more columns>
FROM (record, program INNER JOIN channel ON channel.chanid =
program.chanid YYY)
WHERE record.recordid = <number of the power rule> AND program.manualid
= 0 AND (
(
XXX
)
AND <more conditions> );

I'll update the wiki.