0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

SELECT
 distinct top 50 p.id, p.Id as [Post Link], u.id as [user id], score, tags, reputation
FROM
   posts p
INNER JOIN
   posttags pt ON p.id = pt.Postid
INNER JOIN 
   tags t ON t.id = pt.TagId
Inner join
    users u on u.id = p.OwnerUserId
WHERE
   p.PostTypeId=1
AND
  TagName = 'java'
and CommunityOwnedDate is null
Order by reputation asc

fork query

edited sep 12 13

created sep 10 13 anonymous