Upvotes for questions older then 30 days


Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

SELECT sum(Amount)
  FROM ( 
    SELECT PostId, Count(*) AS Amount
        Votes v JOIN Posts p ON v.PostId=p.Id
    WHERE v.CreationDate > DATEADD(DD, 30, p.CreationDate)  AND VoteTypeId In (2,3)
      AND p.OwnerUserId = ##UserId##
    GROUP BY PostId
  ) AS v

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results