| View of Multiframe table showing only VIDEO data |
| This view is just a select of Multiframe for the VIDEO and Calib programmes for access to pre-release data |
SELECT dbo.Multiframe.*
FROM dbo.Multiframe INNER JOIN dbo.ProgrammeFrame
ON dbo.Multiframe.multiframeID = dbo.ProgrammeFrame.multiframeID
WHERE dbo.ProgrammeFrame.programmeID = 150 OR
dbo.ProgrammeFrame.programmeID = 200
The details of the table defined by this view are available here.