chroma;509702 Wrote: > > for example, the following query does 95% of what is required: > > select C2.id, C2.title, C2.contributor, C2.year, SUM(tracks.filesize) > FROM albums as C1, albums as C2 > JOIN tracks WHERE C1.title = C2.title AND C1.contributor = > C2.contributor AND (c1.year = c2.year > OR c1.year = 0 OR c2.year = 0) AND C1.id < C2.id AND tracks.album = > c2.id > group by tracks.album order by title; > If you are familiar with SQL, take a look at the Multi Library and Custom Browse plugins. I'm pretty sure you should be able to do a custom library and corresponding browse menu that matches your requirements.
You won't be able to search with this solution, but you will probably be able to create browse menus that only includes the albums you want. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=74288 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
