One way to get more sorting options is the use the add-on Custom Nodes as this allows you to define your own queries and sorts.
Consider, for example:
1). 40 Newest Albums by Added Date / SELECT * FROM Albums WHERE ID IN (SELECT IDAlbum FROM Songs GROUP BY IDAlbum HAVING Count(TrackNumber) > 3 ORDER BY Max(DateAdded) DESC LIMIT 40)
2). 40 Newest Albums by Released Date / SELECT * FROM Albums WHERE ID IN (SELECT IDAlbum FROM Songs WHERE Year > 0 GROUP BY IDAlbum HAVING Count(TrackNumber) > 3 ORDER BY Max(Year) DESC LIMIT 40)
3). 50 Most Played Albums / SELECT * FROM Albums WHERE ID IN (SELECT IDAlbum FROM Songs WHERE PlayCounter > 0 GROUP BY IDAlbum ORDER BY SUM(PlayCounter) DESC LIMIT 50)
4). Rolling 10 Years by Released Date / SELECT * FROM Albums WHERE ID IN (SELECT DISTINCT IDAlbum FROM Songs WHERE CAST(substr(Year, 1, 4) AS INTEGER) BETWEEN (CAST(strftime('%Y', 'now') AS INTEGER) - 9) AND CAST(strftime('%Y', 'now') AS INTEGER))
5). Album Artist with more than
?? Albums / SELECT * FROM Albums WHERE Artist NOT IN ('Various', 'Various Artists', 'Compilations', 'Unknown') AND Artist IS NOT NULL AND Artist <> '' AND ( /* Threshold Filter: Only artists with more than 75 albums */ SELECT COUNT(*) FROM Albums AS Sub WHERE Sub.Artist = Albums.Artist ) >
75 ORDER BY ( /* Sort Logic: Most prolific artists first */ SELECT COUNT(*) FROM Albums AS Sub WHERE Sub.Artist = Albums.Artist ) DESC, Artist ASC, Album ASC;
Reference:
https://www.mediamonkey.com/addons/brow ... tom-nodes/
One way to get more sorting options is the use the add-on Custom Nodes as this allows you to define your own queries and sorts.
Consider, for example:
1). 40 Newest Albums by Added Date / SELECT * FROM Albums WHERE ID IN (SELECT IDAlbum FROM Songs GROUP BY IDAlbum HAVING Count(TrackNumber) > 3 ORDER BY Max(DateAdded) DESC LIMIT 40)
2). 40 Newest Albums by Released Date / SELECT * FROM Albums WHERE ID IN (SELECT IDAlbum FROM Songs WHERE Year > 0 GROUP BY IDAlbum HAVING Count(TrackNumber) > 3 ORDER BY Max(Year) DESC LIMIT 40)
3). 50 Most Played Albums / SELECT * FROM Albums WHERE ID IN (SELECT IDAlbum FROM Songs WHERE PlayCounter > 0 GROUP BY IDAlbum ORDER BY SUM(PlayCounter) DESC LIMIT 50)
4). Rolling 10 Years by Released Date / SELECT * FROM Albums WHERE ID IN (SELECT DISTINCT IDAlbum FROM Songs WHERE CAST(substr(Year, 1, 4) AS INTEGER) BETWEEN (CAST(strftime('%Y', 'now') AS INTEGER) - 9) AND CAST(strftime('%Y', 'now') AS INTEGER))
5). Album Artist with more than [b]??[/b] Albums / SELECT * FROM Albums WHERE Artist NOT IN ('Various', 'Various Artists', 'Compilations', 'Unknown') AND Artist IS NOT NULL AND Artist <> '' AND ( /* Threshold Filter: Only artists with more than 75 albums */ SELECT COUNT(*) FROM Albums AS Sub WHERE Sub.Artist = Albums.Artist ) > [b]75[/b] ORDER BY ( /* Sort Logic: Most prolific artists first */ SELECT COUNT(*) FROM Albums AS Sub WHERE Sub.Artist = Albums.Artist ) DESC, Artist ASC, Album ASC;
Reference: https://www.mediamonkey.com/addons/browse/item/custom-nodes/