| 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.