mherger wrote: > > > > The question marks in there are placeholders, and the three values after > > the colon are the values to replace those placeholders with: > > SELECT me.id, me.titlesort, me.contributor, me.compilation, me.year, > me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, > me.replay_gain, me.replay_peak, me.musicbrainz_id, me.extid, me.title > FROM albums me WHERE ( id IN ( SELECT me.album FROM tracks me WHERE ( ( > me.audio = 1 AND me.year = 2015 AND samplesize = 16 ) ) GROUP BY me.id ) > ) > ORDER BY me.disc, me.titlesort COLLATE de_DE LIMIT 1001
coming back to this. running smoothly but the above query lists: id titlesort contributor compilation year artwork disc discc musicmagic_mixable titlesearch replay_gain replay_peak musicbrainz_id extid title and i found out, that i need the artist also. Can you help me to modify the above query to integrate artists, please? the album table doesn't include the artist column, so some join is needed, i'm a little bit lost..... ------------------------------------------------------------------------ mamema's Profile: http://forums.slimdevices.com/member.php?userid=44662 View this thread: http://forums.slimdevices.com/showthread.php?t=115686 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
