- Purpose: in theory, reduces bandwidth usage by having the server send only the currently playing track rather than sending the whole list and having the client hunt for the one that's playing. In practice, we often want to know the last N tracks... so maybe we need a query for that instead.
- Uses: Tracks_Played
<mysql>CREATE OR REPLACE VIEW qryTrack_Playing AS
SELECT * from Tracks_Played ORDER BY ID DESC LIMIT 1;</mysql>