test top users on openerp tag

1

Please login or register to vote for this query.

(click on this box to dismiss)

Skeptics

Q&A for scientific skepticism

Select Count(p.Id) as posts, p.OwnerDisplayName, p.OwnerUserId, u.DIsplayName,
u.id as [User Link], u.Location
From PostTags pt
Left join Posts p on pt.PostId = p.Id
left join Tags t on pt.TagId = t.Id
left join Users u on u.Id = p.OwnerUserId
where t.TagName = 'openerp'
Group By p.OwnerDisplayName, p.OwnerUserId, u.DIsplayName, u.id, u.Location
Order By posts DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results