[mythtv-users] SQL Query Help

[Craig Huff]

Ok.  I see that my inquiry won't make sense without inflicting the list
with the long(er) story --

I use the custom schedule for premieres with recordings disabled to watch
for new shows that I might be interested in.  When one comes up, I set an
override to record the first episode and place it into a recording group
labeled "Premieres".  Of late, I have been too busy with other things to
keep on top of them and when I _do_ get around to watching one I like, I
have missed several episodes that have aired in the meantime.  I was trying
to find a way to construct an SQL query for recording rules that put
recordings in the Premieres group (that part was easy, just use 'where
record.recgroup="Premieres"'), then combine it with data from other tables
(primarily the program and recorded tables), filter down to only the ones
that have a single episode recorded or to be recorded, and then to discern
when other episodes become available for those programs so I could tell
when to create new recording rules to capture the rest of the series until
I get around to deciding if I'm interested in them.

Yes, I could get there with more effort and attention to the various menu
choices in the frontend "Manage Recordings" menu sub-tree, but I thought I
could cover each and every such series premiere (sometimes there are
several at the same time) in one operation if I could come up with the
"right" SQL query.

At the moment, the first episode of "The Alienist" will be airing on the
29th and there are not yet any listings for subsequent episodes in the
program guide from Schedules Direct (too soon), so I thought this would be
a good trial candidate for my efforts.  I used the Gunsmoke series for my
test queries since I knew there were results to be found if I could get my
query syntax worked out.

I know this would be imperfect because I wouldn't be taking into account
the various recording types (e.g. record one showing daily, record only on
this day, etc.), but that would be okay because my intended use case would
normally be based on rules for the "record all showings" recording type.

Given the feedback thus far, I will be looking into what I can do with the
oldrecorded table, which I hadn't considered before.

I'd rather stick with an SQL query, if it's doable, otherwise I'll just go
back to jockeying around in the "Manage Recordings" menu sub-tree to check
on upcoming premieres and looking for additional episodes getting added to
the schedule.

Thanks for the suggestions so far.  Additional advice welcome, as always.

--
Craig.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20180118/70732b66/attachment.html>