0

Please login or register to vote for this query.

(click on this box to dismiss)

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

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;

fork query

created feb 28 anonymous