as always, kudos Michael, very much appreciated
Diana Krall 128525 CANDLELIT EVENING 282965 0
2010
81a6bd55CANDLELIT EVENING
mamema's Profile: h
WHERE ( id IN ( SELECT me.album FROM tracks me WHERE ( (
...
/lms/Slim/Schema/Storage.pm line 125 , ambiguous column name: id
This time you'll have to specify what table's ID you refer to here. I
guess that would be "me.id".
___
plugins mailing lis
this:
SELECT contributors.name, 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 JOIN contributors ON contributors.id = me.contr
FROM albums JOIN contributors ON contributors.id = me.contributor me
That last "me" should probably go after "albums".
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
normally your head is good, so it's me. :-)
This:
SELECT contributors.name, 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 JOIN
Off the top of my head (and without testing): add "contributors.name" to
the field list after the select and "JOIN contributors ON
contributors.id = me.contributor" after the "FROM albums".
Michael
"It doesn't work - what shall I do?" - "Please check your server.log
and/or scanner.log file!"
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.
wonderful. Thanks Michael
mamema's Profile: http://forums.slimdevices.com/member.php?userid=44662
View this thread: http://forums.slimdevices.com/showthread.php?t=115686
___
plu
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 = ? AND
