| 1 76 Trombones Preston movie was 1962 mp3 chart bass uke bari ref key |
||
| 2 9 to 5 mp3 chart bass uke bari ref F# |
||
| 3 Any Dream Will Do mp3 chart bass uke bari ref key |
||
| 4 Boulevard of Broken Dreams mp3 chart bass uke bari ref key |
||
| 5 Cabaret movie, Liza, 1972 mp3 chart bass uke bari ref C |
||
| 8 Hello Dolly yellow book pg 105 mp3 chart bass uke bari ref key |
||
| 9 Wandrin Star Paint Your Wagon mp3 chart bass uke bari ref key |
||
| 10 I Whistle A Happy Tune blue book pg 166 mp3 chart bass uke bari ref key |
||
| 12 Muddy Water Big River on Broadway mp3 chart bass uke bari ref E |
||
| 13 My Cup Runneth Over mp3 chart bass uke bari ref key |
||
| 14 Oh What a Beautiful Morning mp3 chart bass uke bari ref key |
||
| 15 Oom Pah Pah Oliver - Lee has paper song sheet mp3 chart bass uke bari ref key |
||
| 16 Singin in the Rain mp3 chart bass uke bari ref key |
||
| 17 Supercalifragilisticexpialidocious daily (yellow book pg 327 mp3 chart bass uke bari ref key |
||
| 18 Waterloo mp3 chart bass uke bari ref key |
||
| 19 Will You Still Love Me Tomorrow mp3 chart bass uke bari ref key |
||
| 20 Youre Never Fully Dressed Without A Smile Annie mp3 chart bass uke bari ref key |
||
| 90 Consider Yourself yellow book pg 57 mp3 chart bass uke bari ref key |
||
| 90 I Will Follow Him Peggy March 1963, Sister Act 1992 mp3 chart bass uke bari ref key |
||
| 90 Makin Whoopee mp3 chart bass uke bari ref key |
||
| 90 Do You Hear The People Sing mp3 chart bass uke bari ref key |
||
| 90 Youve Got A Friend mp3 chart bass uke bari ref key |
||
| 90 Tomorrow Leap Year (Blue Book) pg 362 mp3 chart bass uke bari ref key |
||
| 90 Hallelujah John Cale 1991 mp3 chart bass uke bari ref key |
||
| 90 Cant Take My Eyes Off Of You Frankie Valli, Andy Williams mp3 chart bass uke bari ref key |
||
SELECT n.*, 211 AS plid, roworder,
ifnull( p.bestkey, '---' ) 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 = 211
ORDER BY roworder
|