Never Too Old To Learn (No Self-Answers)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT
    U.Id AS [User Link],
    P.Id As [Post Link]


FROM Posts P
    INNER JOIN Users U on U.Id = P.OwnerUserId
    INNER JOIN Posts A on A.ParentId = P.Id
    WHERE 
        P.PostTypeId = 1 AND
        A.PostTypeId = 2 AND
        A.OwnerUserId <> U.Id AND -- ignore self-answers
        P.CreationDate >= '2016-01-01' AND P.CreationDate <= '2016-12-31' AND
        U.CreationDate <= '2014-01-01'
    GROUP BY
        U.Id, P.id
    ORDER BY
        U.Id DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results