Hello @regor, I am sorry but I don't know how to do that within SMP.
Would you be so kind to provide some more details? Or share your scripts?
Regards, Andrea

How to have a similar SQL random pool of 10 albums?

• First you need to create a materialized table from your media library:
  Go to "Preferences -> Media Library -> SQLite utilities -> MediaLibrary table", set for all columns, which you want to be part of the materialized table the "Materialize" flag and set "Materialized table" to "MMediaLibrary" in the upper right corner of the preferences page. Then click on the OK button and confirm, that you want to materialize the table. This will take some time, probably between 10-15 minutes on your PC, as it needs between 3-6 minutes on mine, but it needs to be done only once.
  
  Afterwards the materialized table will be maintained automatically and needs only to be refreshed, if you change the columns of the materialize dtable or in case the table gets out of sync due to abnormal program exits without having saved the latest tag changes (they are already in the materialized library but not anymore in the foobar2000 library after program restart). But with foobar2000 v2 this should normally not happen anymore.
• Now go to "Library -> SQLite console" and execute the following SQL statement
  
  Code: [Select]

  CREATE INDEX materialize.MMediaLibrary_in_album on MMediaLibrary(album||'|'||coalesce("album artist",artist));

• Finally you can define a pool "10 random albums". The left side of the dialog has the same entries as the pool for "20 random tracks", so you only need to supply different SQL expressions:
  
  Code: [Select]

  WITH:
  Albums AS (
    SELECT album||'|'||coalesce("album artist",artist) Album
    FROM MMediaLibrary
    GROUP BY 1
    ORDER BY random()
    LIMIT 10
  )
  
  SELECT path, subsong FROM:
  MMediaLibrary
  
  WHERE:
  album||'|'||coalesce("album artist",artist) IN (SELECT album FROM Albums)
  
  ORDER BY:
  album||'|'||coalesce("album artist",artist),coalesce(discnumber,1),tracknumber
  

  LIMIT remains blank. The proposed solution assumes, that you can identify an album uniquely by a combination of %album% and %album artist%. If this is not the case you need to adjust the expression "album||'|'||coalesce("album artist",artist)" wherever it is used to fit your needs. If you have an own tag to identify an album, e.g. %album id%, you should use this.
  

Nice and useful plugin, but what about people who don't have any concept or idea about how works with SQL plugin or about how build SQL database.

So some of us stuck with older and simple plugin of Random Pools.

Quote from: Priest_1 on 2022-09-01 07:03:29

Nice and useful plugin, but what about people who don't have any concept or idea about how works with SQL plugin or about how build SQL database.

They simply don't use the SQL feature.

Quote from: Priest_1 on 2022-09-01 07:03:29

So some of us stuck with older and simple plugin of Random Pools.

You're wrong. The SQL feature is only optional and the current version can be used without. There is no need to use an older version.

just signed up to say what a cool plugin this is! being able to pick music in this way really feels like it's refreshed my library.

in the longer term I want to work out how to make a playlist that would walk along camelot numbers, but right now this tool has taken out so much of the legwork in selection. thanks!

Quote from: cheezopath on 2022-10-01 15:52:43

just signed up to say what a cool plugin this is! being able to pick music in this way really feels like it's refreshed my library.

in the longer term I want to work out how to make a playlist that would walk along camelot numbers, but right now this tool has taken out so much of the legwork in selection. thanks!

https://regorxxx.github.io/foobar2000-SMP.github.io/scripts/playlist-tools-smp/

? I'm answering to an user request about camelot keys

... wow... too much ego here (?)

Let me be even more clear. It can be used along your plugin, after playlist creation.

So your comment was totally out of context and not justified at all.

I'm using random pools exclusively for playing albums, Can I get FB to play full albums without using Shuffle (albums) while using random pools?

Must I use the Shuffle (albums) playback mode or is there some other way to get random pools to playback in album mode?

Is that itself a potential problem (it takes only a few seconds to load)

and should I use the Autoload "Add" options instead?

What am I missing? Do I have a total misconception of how this works? Is there perhaps some other setting in FB or in one of the add-ins that keeps this from working properly?

I've read last three pages, and I didn't see - will there be 64 bit version of plugin for new foobar?