AudioFerret/v1/sql/qryArtists index

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

SQL

<mysql>CREATE OR REPLACE VIEW qryArtists_index AS SELECT

 id,
 name

FROM Artist UNION SELECT

 id,
 sort

FROM Artist WHERE NULLIF(sort,) IS NOT NULL ORDER BY name;</mysql>

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