Thanks for the quick response kdf.

kdf Wrote: 
> 
> not all iTunes podcasts mark the genre as "podcast"
> 
I've just checked the tracks in question and all seem to show in iTunes
with genre "podcast".

kdf Wrote: 
> the iTunes scan adds a specific "podcasts" genre to all tracks found in
> the "podcasts" iTunes playlist. As each track can have multiple genres,
> this allows teh server to provide an "iTunes Podcasts" menu item that
> searches for those items and provides them as an instant listing.
> 
I ran the following SQL against my slimserver database:

> SELECT distinct t.title, g.name
> FROM tracks t
> LEFT JOIN genre_track gt ON t.id = gt.track
> LEFT JOIN genres g ON gt.genre = g.id
> where g.name like 'Pod%'
> order by t.title, g.name
> 
And it returns a list of tracks with either "podcast" or "podcasts"
genres but none with both.


-- 
barcar
------------------------------------------------------------------------
barcar's Profile: http://forums.slimdevices.com/member.php?userid=1760
View this thread: http://forums.slimdevices.com/showthread.php?t=21869

_______________________________________________
Discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss

Reply via email to