declare @p0 datetime,@p1 datetime,@p2 datetime,@p3 datetime
select @p0='Jan 31 2011 10:42:48:030AM',@p1='Feb 10 2011 10:42:48:043AM',@p2='Feb 10 2011 10:42:48:043AM',@p3='Feb 10 2011 10:42:48:043AM'
SELECT TOP (9) [t38].[value] AS [Id], [t38].[value2] AS [Description], [t38].[value3] AS [ProgramSerieSlug], [t38].[value4] AS [Title], [t38].[value5], [t38].[value6] AS [value2], [t38].[value7] AS [BroadcastTime], [t38].[value8] AS [BroadcastChannel], [t38].[value9] AS [VideoManifestUrl], [t38].[value10] AS [VideoResourceUrl], [t38].[value11] AS [Premiere], [t38].[VideoId]
FROM (
    SELECT (
        SELECT [t3].[Id]
        FROM (
            SELECT TOP (1) [t2].[Id]
            FROM [dbo].[Videos2] AS [t2]
            WHERE ([t2].[Id] = [t1].[VideoId]) AND ([t2].[Publish] < @p1) AND ([t2].[Expire] > @p2)
            ORDER BY [t2].[Publish] DESC
            ) AS [t3]
        ) AS [value], (
        SELECT [t5].[Description]
        FROM (
            SELECT TOP (1) [t4].[Description]
            FROM [dbo].[Videos2] AS [t4]
            WHERE ([t4].[Id] = [t1].[VideoId]) AND ([t4].[Publish] < @p1) AND ([t4].[Expire] > @p2)
            ORDER BY [t4].[Publish] DESC
            ) AS [t5]
        ) AS [value2], (
        SELECT [t7].[ProgramSerieSlug]
        FROM (
            SELECT TOP (1) [t6].[ProgramSerieSlug]
            FROM [dbo].[Videos2] AS [t6]
            WHERE ([t6].[Id] = [t1].[VideoId]) AND ([t6].[Publish] < @p1) AND ([t6].[Expire] > @p2)
            ORDER BY [t6].[Publish] DESC
            ) AS [t7]
        ) AS [value3], (
        SELECT [t9].[Title]
        FROM (
            SELECT TOP (1) [t8].[Title]
            FROM [dbo].[Videos2] AS [t8]
            WHERE ([t8].[Id] = [t1].[VideoId]) AND ([t8].[Publish] < @p1) AND ([t8].[Expire] > @p2)
            ORDER BY [t8].[Publish] DESC
            ) AS [t9]
        ) AS [value4],
        (CASE
            WHEN ((
                SELECT [t11].[Duration]
                FROM (
                    SELECT TOP (1) [t10].[Duration]
                    FROM [dbo].[Videos2] AS [t10]
                    WHERE ([t10].[Id] = [t1].[VideoId]) AND ([t10].[Publish] < @p1) AND ([t10].[Expire] > @p2)
                    ORDER BY [t10].[Publish] DESC
                    ) AS [t11]
                )) IS NOT NULL THEN 1
            ELSE 0
         END) AS [value5], CONVERT(Float,(
        SELECT [t13].[Duration]
        FROM (
            SELECT TOP (1) [t12].[Duration]
            FROM [dbo].[Videos2] AS [t12]
            WHERE ([t12].[Id] = [t1].[VideoId]) AND ([t12].[Publish] < @p1) AND ([t12].[Expire] > @p2)
            ORDER BY [t12].[Publish] DESC
            ) AS [t13]
        )) AS [value6], (
        SELECT [t15].[BroascastTime]
        FROM (
            SELECT TOP (1) [t14].[BroascastTime]
            FROM [dbo].[Videos2] AS [t14]
            WHERE ([t14].[Id] = [t1].[VideoId]) AND ([t14].[Publish] < @p1) AND ([t14].[Expire] > @p2)
            ORDER BY [t14].[Publish] DESC
            ) AS [t15]
        ) AS [value7], (
        SELECT [t17].[BroadcastChannel]
        FROM (
            SELECT TOP (1) [t16].[BroadcastChannel]
            FROM [dbo].[Videos2] AS [t16]
            WHERE ([t16].[Id] = [t1].[VideoId]) AND ([t16].[Publish] < @p1) AND ([t16].[Expire] > @p2)
            ORDER BY [t16].[Publish] DESC
            ) AS [t17]
        ) AS [value8], (
        SELECT [t19].[VideoManifestUrl]
        FROM (
            SELECT TOP (1) [t18].[VideoManifestUrl]
            FROM [dbo].[Videos2] AS [t18]
            WHERE ([t18].[Id] = [t1].[VideoId]) AND ([t18].[Publish] < @p1) AND ([t18].[Expire] > @p2)
            ORDER BY [t18].[Publish] DESC
            ) AS [t19]
        ) AS [value9], (
        SELECT [t21].[VideoResourceUrl]
        FROM (
            SELECT TOP (1) [t20].[VideoResourceUrl]
            FROM [dbo].[Videos2] AS [t20]
            WHERE ([t20].[Id] = [t1].[VideoId]) AND ([t20].[Publish] < @p1) AND ([t20].[Expire] > @p2)
            ORDER BY [t20].[Publish] DESC
            ) AS [t21]
        ) AS [value10],
        (CASE
            WHEN (((
                SELECT [t31].[BroascastTime]
                FROM (
                    SELECT TOP (1) [t30].[BroascastTime]
                    FROM [dbo].[Videos2] AS [t30]
                    WHERE ([t30].[Id] = [t1].[VideoId]) AND ([t30].[Publish] < @p1) AND ([t30].[Expire] > @p2)
                    ORDER BY [t30].[Publish] DESC
                    ) AS [t31]
                )) IS NOT NULL) AND (((
                SELECT [t33].[BroascastTime]
                FROM (
                    SELECT TOP (1) [t32].[BroascastTime]
                    FROM [dbo].[Videos2] AS [t32]
                    WHERE ([t32].[Id] = [t1].[VideoId]) AND ([t32].[Publish] < @p1) AND ([t32].[Expire] > @p2)
                    ORDER BY [t32].[Publish] DESC
                    ) AS [t33]
                )) > ((
                SELECT [t35].[Publish]
                FROM (
                    SELECT TOP (1) [t34].[Publish]
                    FROM [dbo].[Videos2] AS [t34]
                    WHERE ([t34].[Id] = [t1].[VideoId]) AND ([t34].[Publish] < @p1) AND ([t34].[Expire] > @p2)
                    ORDER BY [t34].[Publish] DESC
                    ) AS [t35]
                ))) AND (((
                SELECT [t37].[BroascastTime]
                FROM (
                    SELECT TOP (1) [t36].[BroascastTime]
                    FROM [dbo].[Videos2] AS [t36]
                    WHERE ([t36].[Id] = [t1].[VideoId]) AND ([t36].[Publish] < @p1) AND ([t36].[Expire] > @p2)
                    ORDER BY [t36].[Publish] DESC
                    ) AS [t37]
                )) > @p3) THEN 1
            WHEN NOT ((((
                SELECT [t31].[BroascastTime]
                FROM (
                    SELECT TOP (1) [t30].[BroascastTime]
                    FROM [dbo].[Videos2] AS [t30]
                    WHERE ([t30].[Id] = [t1].[VideoId]) AND ([t30].[Publish] < @p1) AND ([t30].[Expire] > @p2)
                    ORDER BY [t30].[Publish] DESC
                    ) AS [t31]
                )) IS NOT NULL) AND (((
                SELECT [t33].[BroascastTime]
                FROM (
                    SELECT TOP (1) [t32].[BroascastTime]
                    FROM [dbo].[Videos2] AS [t32]
                    WHERE ([t32].[Id] = [t1].[VideoId]) AND ([t32].[Publish] < @p1) AND ([t32].[Expire] > @p2)
                    ORDER BY [t32].[Publish] DESC
                    ) AS [t33]
                )) > ((
                SELECT [t35].[Publish]
                FROM (
                    SELECT TOP (1) [t34].[Publish]
                    FROM [dbo].[Videos2] AS [t34]
                    WHERE ([t34].[Id] = [t1].[VideoId]) AND ([t34].[Publish] < @p1) AND ([t34].[Expire] > @p2)
                    ORDER BY [t34].[Publish] DESC
                    ) AS [t35]
                ))) AND (((
                SELECT [t37].[BroascastTime]
                FROM (
                    SELECT TOP (1) [t36].[BroascastTime]
                    FROM [dbo].[Videos2] AS [t36]
                    WHERE ([t36].[Id] = [t1].[VideoId]) AND ([t36].[Publish] < @p1) AND ([t36].[Expire] > @p2)
                    ORDER BY [t36].[Publish] DESC
                    ) AS [t37]
                )) > @p3)) THEN 0
            ELSE NULL
         END) AS [value11], [t1].[VideoId], [t1].[value] AS [value12]
    FROM (
        SELECT COUNT(*) AS [value], [t0].[VideoId]
        FROM [dbo].[VideoViews] AS [t0]
        WHERE [t0].[ViewTime] > @p0
        GROUP BY [t0].[VideoId]
        ) AS [t1]
    ) AS [t38]
WHERE EXISTS(
    SELECT TOP (1) NULL AS [EMPTY]
    FROM [dbo].[Videos2] AS [t39]
    WHERE ([t39].[Id] = [t38].[VideoId]) AND ([t39].[Publish] < @p1) AND ([t39].[Expire] > @p2)
    ORDER BY [t39].[Publish] DESC
    )
ORDER BY [t38].[value12] DESC