PARTITION BY

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

select users.Id [User Link],displayname, emailhash, reputation, location, tags
from users
inner join posthistory ph
  on ph.userid = users.id
inner join posts
  on posts.id = ph.postid
  
where tags like '%java%' and tags like '%bigdata%' 
and location not in ('','on the server farm')
and location like '%PoznaƄ%'

order by reputation desc

Enter Parameters

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