Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

select top 100 count(tags.TagName) as liczba, users.DisplayName
from tags, PostTags, Posts, Users
where (TagName = 'java' OR TagName = 'javascript') AND
      (PostTags.PostId = Posts.id) AND
      (Posts.OwnerUserId = Users.Id) 
group by tags.TagName, users.DisplayName

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results