0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for speakers of German wanting to discuss the finer points of the language and translation

SELECT
  u.Id [User Link],
  u.Reputation,
  u.CreationDate,
  u.LastAccessDate,
  u.Views,
  u.UpVotes,
  u.DownVotes,
  p.Id [Post Link],
  p.AcceptedAnswerId,
  p.ParentId,
  p.CreationDate,
  p.Score,
  p.OwnerUserId,
  p.AnswerCount,
  p.ClosedDate,
  v.Id,
  v.PostId,
  v.VoteTypeId,
  v.Userid,
  v.CreationDate,
  v.BountyAmount
FROM 
  Users u
JOIN Posts p ON p.OwnerUserId = u.Id
JOIN Votes v ON v.PostId = p.Id AND v.UserId = u.Id

--JOIN SuggestedEdits e ON e.OnwerUserId = u.Id
WHERE u.Id = 9190135

view current version

edited jan 28

created jan 28 LasseG