SET STATISTICS IO ON; SELECT TOP (1000) u.* FROM dbo.Use...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SET STATISTICS IO ON;

SELECT TOP (1000)
    u.*
FROM dbo.Users AS u
WHERE EXISTS
(
    SELECT
        u2.Id
    FROM dbo.Users AS u2
    WHERE u2.Id = u.Id
    AND   u2.Reputation > 50

    UNION

    SELECT
        u2.Id
    FROM dbo.Users AS u2
    WHERE u2.Id = u.Id
    AND   u2.CreationDate >= DATEADD(DAY, -90, '2013-09-14 23:06:39.187')
)
ORDER BY
    u.Reputation DESC;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results