Hi there,
Is there the scheme of the database anywhere ?
I'd like to customise a query on track name and track number but I
don't find how to do this.
Here is my example:
Code:
--------------------
-- PlaylistName:Goldberg Variations
-- PlaylistGroups:
select tracks.url from tracks
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
join albums on
tracks.album=albums.id and
albums.title like 'BWV 988%' and albums.title not like '%Zenph%'
and (tracks.url like '%10%' or tracks.url like '% X %')
where
tracks.audio=1
and dynamicplaylist_history.id is null
group by tracks.id
order by rand()
limit 10;
--------------------
--
PatLogan
------------------------------------------------------------------------
PatLogan's Profile: http://forums.slimdevices.com/member.php?userid=30840
View this thread: http://forums.slimdevices.com/showthread.php?t=76244
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
