jezbo;382248 Wrote: > MySQL Query Browser is the thing you want > > Once you have that and can connect (same connection details as you plug > into muso), try the query: > > > Code: -------------------- > > SELECT t.id, t.url, > CAST(t.title AS CHAR(10000) CHARACTER SET utf8) track, > t.secs, > tp.lastplayed, > tp.rating, > CAST(a.title AS CHAR(10000) CHARACTER SET utf8) album, > a.Year, > CAST(g.name AS CHAR(10000) CHARACTER SET utf8) genre, > CAST(c.name AS CHAR(10000) CHARACTER SET utf8) artist, > t.tracknum, > tp.playcount, > ifnull(a.compilation,0) compilation > FROM tracks t > JOIN tracks_persistent tp ON (tp.id = t.id) > LEFT OUTER JOIN genre_track gt ON (t.id = gt.track) > LEFT OUTER JOIN genres g ON (gt.genre = g.id) > LEFT OUTER JOIN albums a ON (t.album = a.id) > LEFT OUTER JOIN contributor_track ct ON (ct.track = t.id and ct.role = 1) > LEFT OUTER JOIN contributors c ON (ct.contributor = c.id) > WHERE lower(t.url) NOT LIKE '%.cue' -------------------- > > > > and see if the artist column (4th from end) is null all the way down. >
Cheers - that's installed now. Not quite all tracks, but the vast majority of them are null in the artist column. jezbo;382248 Wrote: > If so we'll have to evaluate why with separate queries, like: > > > Code: -------------------- > > SELECT t.id, t.url, ct.role, CAST(c.name AS CHAR(10000) CHARACTER SET utf8) artist > FROM tracks t, contributor_track ct , contributors c > WHERE ct.track = t.id > AND ct.contributor = c.id > AND t.id < 30 > ORDER BY 1,3 -------------------- > > > > To get all the contributors for the first 30 tracks only. This shows each of those 30 tracks having a role of just 4 and 5 - is that what you needed? -- SadGamerGeek ------------------------------------------------------------------------ SadGamerGeek's Profile: http://forums.slimdevices.com/member.php?userid=6145 View this thread: http://forums.slimdevices.com/showthread.php?t=57629 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
