I don't think so.
I've just switched to 7.4.1 on Ubuntu from 7.3.2 on XP and my SQL
playlists are unchanged - and it worked before.
Has there been another change between 7.3 and 7.4 that would affect the
syntax of my SQL?
this is my file:
-- PlaylistName: Favourites
-- PlaylistGroups: Favourites...
select url from
(select tracks.url from tracks
join track_statistics on
tracks.url=track_statistics.url
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id
where
audio=1
and dynamicplaylist_history.id is null
group by tracks.id
order by track_statistics.rating desc,rand()
limit 10)
as toprated
order by rand();
--
MillmoorRon
------------------------------------------------------------------------
MillmoorRon's Profile: http://forums.slimdevices.com/member.php?userid=6413
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
