| 1 Ballad of Gilligans Island audio chart bass uke bari ref C |
||
| 1 Banana Boat Song Harry Belafonte audio chart bass uke bari ref C |
||
| 1 Blue Hawaii Elvis might be in G audio chart bass uke bari ref - |
||
| 1 Homeward Bound audio chart bass uke bari ref - |
||
| 1 Jam Da Island tune is Jambalaya audio chart bass uke bari ref C |
||
| 1 Knee Deep audio chart bass uke bari ref key |
||
| 1 Ku.u_Home_.O_Kahalu.u Santos is E, (D, capo 2) audio chart bass uke bari ref D |
||
| 1 Thats_the_Hawaiian_In_Me audio chart bass uke bari ref A |
||
SELECT n.*, 246 AS plid, roworder,
ifnull( p.bestkey,
( SELECT ifnull( thiskey, ' - ' ) FROM file WHERE rowid = p.bestchart ) ) AS bestkey,
ifnull( p.bestmp3, '---' ) AS bestmp3,
( SELECT ifnull( name, '---' ) FROM file WHERE rowid = p.bestmp3 ) AS mp3name,
( SELECT ifnull( publicurl, '---' ) FROM file WHERE rowid = p.bestmp3 ) AS mp3src,
ifnull( p.bestchart, '---' ) AS bestchart,
( SELECT ifnull( name, '---' ) FROM file WHERE rowid = p.bestchart ) AS chartname,
( SELECT ifnull( publicurl, '---' ) FROM file WHERE rowid = p.bestchart ) AS chartsrc,
ifnull( p.bestbass, '---' ) AS bestbass,
( SELECT ifnull( name, '---' ) FROM file WHERE rowid = p.bestbass ) AS bassname,
( SELECT ifnull( publicurl, '---' ) FROM file WHERE rowid = p.bestbass ) AS basssrc,
ifnull( p.bestuke, '---' ) AS bestuke,
( SELECT ifnull( name, '---' ) FROM file WHERE rowid = p.bestuke ) AS ukename,
( SELECT ifnull( publicurl, '---' ) FROM file WHERE rowid = p.bestuke ) AS ukesrc, -- picky
ifnull( p.bestbari, '---' ) AS bestbari,
( SELECT ifnull( name, '---' ) FROM file WHERE rowid = p.bestbari ) AS bariname,
( SELECT ifnull( publicurl, '---' ) FROM file WHERE rowid = p.bestbari ) AS barisrc,
-- reference file
( SELECT ifnull( name, '---' ) FROM file WHERE rowid = n.reference ) AS refname,
( SELECT ifnull( publicurl, '---' ) FROM file WHERE rowid = n.reference ) AS refsrc
FROM `tune` AS n, `playlisttunes` AS p
WHERE n.rowid = p.tune
AND p.playlist = 246
ORDER BY n.`name`
|