https://htyp.org/mw/index.php?action=history&feed=atom&title=AudioFerret%2Fv1%2Fsql%2FqryCbx_TitlesAudioFerret/v1/sql/qryCbx Titles - Revision history2026-08-02T14:09:35ZRevision history for this page on the wikiMediaWiki 1.45.3https://htyp.org/mw/index.php?title=AudioFerret/v1/sql/qryCbx_Titles&diff=16650&oldid=prevWoozle: extracted from main page2012-01-10T02:47:20Z<p>extracted from main page</p>
<p><b>New page</b></p><div>==SQL==<br />
<mysql>CREATE OR REPLACE VIEW qryCbx_Titles AS<br />
SELECT<br />
t.ID,<br />
CONCAT_WS(' - ',IF(t.name IS NULL,t.track,t.name),IF(t.Artist_ID IS NULL,aa.Name,at.Name),ab.Name) AS Track,<br />
t.album_id<br />
FROM<br />
(<br />
(Titles AS t LEFT JOIN Artists AS at ON t.Artist_ID=at.ID)<br />
LEFT JOIN Albums AS ab ON t.Album_ID=ab.ID<br />
) LEFT JOIN Artists AS aa ON ab.idArtist=aa.ID<br />
ORDER BY t.name,t.track;</mysql></div>Woozle