Totals

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

-- Test on single user
-- Users.Id = 10853463

SELECT
    Users.Id ,--as [User Link],
    --Users.CreationDate,
    Posts.Id,
    Posts.CreationDate,
    Comments.Id,
    Comments.CreationDate
FROM
    Users,Posts, Comments
WHERE
  --Users.CreationDate > '2019-01-01 00:00:00'
  Users.Id = 10853463
  AND Users.Id = Comments.UserId
  AND Users.Id = Posts.OwnerUserId
--GROUP BY
--    Users.Id, DisplayName,Users.CreationDate
--HAVING
--    Count(Posts.Id) > 10

Enter Parameters

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