| 1 Down In The Valley audio chart bass uke bari ref - |
||
| 1 Drop Baby Drop references Who Loves You / 4 seasons audio chart bass uke bari ref - |
||
| 1 God Bless America audio chart bass uke bari ref G |
||
| 1 Lets Work Together Canned Heat audio chart bass uke bari ref key |
||
| 1 Lovely Day audio chart bass uke bari ref Em |
||
| 1 Morning Has Broken Eleanor Farjeon 1931, based on Scottish tune, Cat Stevens 1971 audio chart bass uke bari ref D |
||
| 1 Old Fashioned Love Song audio chart bass uke bari ref key |
||
| 1 On The Road Again for the film Honeysuckle Rose. Original is in E audio chart bass uke bari ref - |
||
| 1 Ramblin Man audio chart bass uke bari ref key |
||
| 1 Ramblin Rose audio chart bass uke bari ref A |
||
| 1 Song Sung Blue audio chart bass uke bari ref C |
||
| 1 Stray Cat Strut audio chart bass uke bari ref - |
||
| 1 Sunshine On My Shoulder audio chart bass uke bari ref G |
||
| 1 Today New Christie Minstrels 1964, John Denver audio chart bass uke bari ref key |
||
| 1 Will You Still Love Me Tomorrow audio chart bass uke bari ref C |
||
| 1 Yesterday When I Was Young audio chart bass uke bari ref key |
||
| 1 Your Mama Dont Dance audio chart bass uke bari ref - |
||
SELECT n.*, 237 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 = 237
ORDER BY n.`name`
|