[mythtv-users] Pilots and Premieres power search anyone?

[Doug Lytle]

Brian J. Murrell wrote:
> Does anyone
> have the search terms used for this?  IIRC it involved the episode
> number

Here is mine:

program.first > 0 AND (program.programid LIKE 'EP%0001' OR 
program.subtitle LIKE '%Pilot%')
AND program.originalairdate = 
DATE(CONVERT_TZ(program.starttime,'UTC','SYSTEM'))  AND 
program.previouslyshown = 0
AND program.category NOT IN (
  'Travel',
  'Sports Event',
  'Sports Talk',
  'Children',
  'Public Affairs',
  'Reality',
  'Shopping',
  'News',
  'Cooking',
  'Romance',
  'Entertainment',
  'Talk',
  'Game Show',
  'Music',
  'Sports non-event'
  )

Doug


-- 
Ben Franklin quote:

"Those who would give up Essential Liberty to purchase a little Temporary Safety, deserve neither Liberty nor Safety."