SELECT pd.ProductionDayId
FROM dbo.ProductionDays pd
JOIN dbo.ProductionDayElements pde ON pde.ProductionDayId = pd.ProductionDayId
JOIN dbo.frProductionScenes ps ON ps.ProductionDayElementId = pde.ProductionDayElementId
JOIN dbo.ProductionSceneCastLink pscl ON pscl.SceneId = ps.SceneId
WHERE pd.DayStatus <> 1 AND pscl.CastId = @CastId