INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: smartlist or view to show artists that have more than x number of rated songs  (Read 1140 times)

broncodan

  • World Citizen
  • ***
  • Posts: 212

Hi,

I think this was asked about a long time ago but with all the new changes maybe there is now a way that this can be done - I would like to either create a veiw or playlist that shows all artists that have x number of songs with ratings?  Ultimately I would like to create either a smartlist template or an sql query that could determine which artist in my collection has 10 songs that have ratings, remove the duplicate songs, and present a list. 
Logged

mark_h

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1854

Any good?

([Media Type]=[Audio] -[Rating]=0 [=save(0,var_artist_votes[artist])1]=1 [=saveadd(var_artist_votes[artist],1)1]=1) [=compare(load(var_artist_votes[artist]),>,9)]=1 ~nodup=[Artist],[Name]

Logged
Pages: [1]   Go Up