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, 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>