Custom Browse / Years / Albums / Songs:
2006-10-02 19:40:16.5836 CustomBrowse: Searching for custom browse
configuration in: M:\Music\SlimServer Playlists
2006-10-02 19:40:16.5842 CustomBrowse: Loading browse configuration from:
P:\Music\SlimServer\trunk\server\Plugins\CustomBrowse\Playlists
2006-10-02 19:40:16.8504 CustomBrowse: Loading browse configuration from:
M:\Music\SlimServer Playlists
2006-10-02 19:40:19.5501 CustomBrowse: Preparing SQL:
select years.id,case when years.id>0 then
years.id else 'Unknown' end from years
order by years.id desc
2006-10-02 19:40:19.5522 CustomBrowse: Executing: select years.id,case when
years.id>0 then years.id else 'Unknown' end from years
order by years.id desc
2006-10-02 19:40:19.5847 CustomBrowse: Executing and collecting: select
years.id,case when years.id>0 then years.id else 'Unknown' end from years
order by years.id desc
2006-10-02 19:40:22.4231 CustomBrowse: Preparing SQL:
select
albums.id,albums.title,substr(albums.titlesort,1,1) from albums
where
albums.year={year}
order by albums.titlesort
2006-10-02 19:40:22.4252 CustomBrowse: Executing: select
albums.id,albums.title,substr(albums.titlesort,1,1) from albums
where
albums.year=0
order by albums.titlesort
2006-10-02 19:40:22.4474 CustomBrowse: Executing and collecting: select
albums.id,albums.title,substr(albums.titlesort,1,1) from albums
where
albums.year=0
order by albums.titlesort
2006-10-02 19:40:24.6158 CustomBrowse: Preparing SQL:
select tracks.id,tracks.title
from tracks
where
tracks.audio=1 and
tracks.album={album}
and
tracks.year={year}
order by tracks.tracknum
asc,tracks.titlesort asc
2006-10-02 19:40:24.6182 CustomBrowse: Executing: select tracks.id,tracks.title
from tracks
where
tracks.audio=1 and
tracks.album=865 and
tracks.year=0
order by tracks.tracknum
asc,tracks.titlesort asc
2006-10-02 19:40:24.6198 CustomBrowse: Executing and collecting: select
tracks.id,tracks.title from tracks
where
tracks.audio=1 and
tracks.album=865 and
tracks.year=0
order by tracks.tracknum
asc,tracks.titlesort asc
Custom Browse / Decades / Albums / Songs (for the first "Song" album):
2006-10-02 19:41:59.4860 CustomBrowse: Preparing SQL:
select floor(tracks.year/10)*10,case when
tracks.year>0 then concat(floor(tracks.year/10)*10,'s') else 'Unknown' end from
tracks
where
tracks.audio=1
group by floor(tracks.year/10)*10
order by tracks.year asc
2006-10-02 19:41:59.4885 CustomBrowse: Executing: select
floor(tracks.year/10)*10,case when tracks.year>0 then
concat(floor(tracks.year/10)*10,'s') else 'Unknown' end from tracks
where
tracks.audio=1
group by floor(tracks.year/10)*10
order by tracks.year asc
2006-10-02 19:41:59.6093 CustomBrowse: Executing and collecting: select
floor(tracks.year/10)*10,case when tracks.year>0 then
concat(floor(tracks.year/10)*10,'s') else 'Unknown' end from tracks
where
tracks.audio=1
group by floor(tracks.year/10)*10
order by tracks.year asc
2006-10-02 19:42:02.1713 CustomBrowse: Preparing SQL:
select
albums.id,albums.title,substr(albums.titlesort,1,1) from tracks,albums
where
tracks.audio=1 and
albums.id=tracks.album and
tracks.year>={year} and
tracks.year<{year}+10
group by albums.id
order by {orderby}
2006-10-02 19:42:02.1738 CustomBrowse: Executing: select
albums.id,albums.title,substr(albums.titlesort,1,1) from tracks,albums
where
tracks.audio=1 and
albums.id=tracks.album and
tracks.year>=0 and
tracks.year<0+10
group by albums.id
order by albums.titlesort asc
2006-10-02 19:42:02.2662 CustomBrowse: Executing and collecting: select
albums.id,albums.title,substr(albums.titlesort,1,1) from tracks,albums
where
tracks.audio=1 and
albums.id=tracks.album and
tracks.year>=0 and
tracks.year<0+10
group by albums.id
order by albums.titlesort asc
2006-10-02 19:42:06.1052 CustomBrowse: Preparing SQL:
select tracks.id,tracks.title
from tracks,albums
where
tracks.audio=1 and
tracks.album={album}
and
tracks.year>={year} and
tracks.year<{year}+10
group by tracks.id
order by tracks.tracknum
asc,tracks.titlesort asc
2006-10-02 19:42:06.1077 CustomBrowse: Executing: select tracks.id,tracks.title
from tracks,albums
where
tracks.audio=1 and
tracks.album=3 and
tracks.year>=0 and
tracks.year<0+10
group by tracks.id
order by tracks.tracknum
asc,tracks.titlesort asc
Custom Browse / Decades / Albums / Songs (for the second "Song" album):
2006-10-02 19:43:20.2706 CustomBrowse: Preparing SQL:
select tracks.id,tracks.title
from tracks,albums
where
tracks.audio=1 and
tracks.album={album}
and
tracks.year>={year} and
tracks.year<{year}+10
group by tracks.id
order by tracks.tracknum
asc,tracks.titlesort asc
2006-10-02 19:43:20.2728 CustomBrowse: Executing: select tracks.id,tracks.title
from tracks,albums
where
tracks.audio=1 and
tracks.album=865 and
tracks.year>=0 and
tracks.year<0+10
group by tracks.id
order by tracks.tracknum
asc,tracks.titlesort asc
2006-10-02 19:43:20.2810 CustomBrowse: Executing and collecting: select
tracks.id,tracks.title from tracks,albums
where
tracks.audio=1 and
tracks.album=865 and
tracks.year>=0 and
tracks.year<0+10
group by tracks.id
order by tracks.tracknum
asc,tracks.titlesort asc
Phil
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
