VIEW  vhsMultiframeDetector

View of MultiframeDetector table showing only VHS data

This view is just a select of MultiframeDetector for the VHS
and Calib programmes for access to pre-release data


SELECT dbo.MultiframeDetector.*
FROM   dbo.MultiframeDetector INNER JOIN dbo.ProgrammeFrame
ON     dbo.MultiframeDetector.multiframeID = dbo.ProgrammeFrame.multiframeID
WHERE  dbo.ProgrammeFrame.programmeID = 110 OR
       dbo.ProgrammeFrame.programmeID = 200

The details of the table defined by this view are available here.