views:

27

answers:

0

Hi,

I have 2 entities...

Audio Tag

These are setup as a many-to-many, Audio has a reference to Tags, but Tags doesn't have a reference back to Audio.

What i want to do is return all tags matching a search query with a count of how many Audios for each tag, they also need to be ordered by the Tags with the most Audio items.

Just to make it a little more complicated, it also needs to be paged.

I would prefer to use the Criteria API if possible.

Hope somebody can help because i have searched for days but can't find a solution.

Paul