SELECT u.Id [User Link], u.Reputation, u.CreationDate, u....

0

Please login or register to vote for this query.

(click on this box to dismiss)

German Language Meta

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

Enter Parameters

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