AudioFerret/v1/sql/qryCbx Albums byArtist

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot

< AudioFerret‎ | v1‎ | sql

Jump to navigation Jump to search

About

Uses: Album
History:
- 2012-01-09 Fixed reference to Album (was "Albums")

SQL

<mysql>CREATE OR REPLACE VIEW qryCbx_Albums_byArtist AS

 SELECT
   a.id,
   a.name,
   a.sort,
   a.idartist AS ID_Artist
 FROM Album AS a

ORDER BY a.idartist, CONCAT(sort,name);</mysql>

Retrieved from "https://htyp.org/mw/index.php?title=AudioFerret/v1/sql/qryCbx_Albums_byArtist&oldid=16648"