test top users on openerp tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Software Quality Assurance and Testing Meta

Q&A about the site for software quality control experts, automation engineers, and software testers

Select Count(p.Id) as posts, p.OwnerDisplayName, p.OwnerUserId, u.DIsplayName
-- p.Title ,
--   p.Id as [Post Link]
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 = 'devexpress' and t.TagName='asp.net'
Group By p.OwnerDisplayName, p.OwnerUserId, u.DIsplayName
Order By posts

Enter Parameters

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