Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[psiborg.ca]

After searching for a couple of hours in the forums I think I need some help from the smartlist experts...

I'd like a smartlist that shows all songs in my database by all artists that have at least 3 songs. If I were to use SQL it would look something like:
SELECT allSongs
GROUP BY artist, numTracks
HAVING count(numTracks) >= 3;

I'm basically just trying to weed out all of the 1 hit wonder artists that I seem to have so many of in my database.... Any ideas?

(currently using MediaCenter 10.0.173 registered)

[risingdamp]

Sorry but not possible.

(If marko comes along with the answer I will be very upset    )

[marko]

I think you're right.

The closest I can get to this is to use the LIMIT function to list 4 tracks from every artist. for those that don't have 4 tracks it'll just show what it's got. sort them by artist and then manually weed out the bits you want.

[media type]=audio ~limit-1,4,[artist] ~sort=[artist]

not sure it's possible to get any closer than that. that search has just taught me that I have just one Acker Bilk track in my library. no prizes for guessing which one 

-marko.

[risingdamp]

Great track though.

de da, da da, da da da da da da.  De da da da da da.... da da da da da da da.. aaa.