dSw;151675 Wrote:
> Can anyone see anything obviously wrong with this query or suggest an
> alternative way of doing it?I think the problem is that mysql re-executes the
> inner SQL for every
row in the main SQL, so this results in that you need to get very lucky
to get any hit at all.
Something like this seems to work for me:
>
> select tracks.url
> from tracks, (select distinct albums.id
> from tracks, albums, genre_track, genres
> where genres.name = 'Mix'
> and genre_track.genre=genres.id
> and tracks.id = genre_track.track
> and tracks.album = albums.id
> and albums.titlesort not in ('NO TITLE','N/A','UNKNOWN
> ALBUM','NO
> ALBUM')
> order by rand() limit 1) as albums
> where tracks.album = albums.id
> order by tracks.disc, tracks.tracknum;
>
--
erland
Erland Isaksson
'My homepage' (http://erland.homeip.net) 'My download page'
(http://erland.homeip.net/download)
(Developer of 'TrackStat'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat)
, 'SQLPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-sqlplaylist)
, 'DynamicPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-dynamicplaylist),
'Custom Browse'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-custombrowse),'Custom
Scan'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan)
and 'RandomPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-randomplaylist)
plugins)
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=20533
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/plugins
