SELECT a.*, b.labelName AS publisherName,, d.packageName, e.styleName, f.price, g.countryName, h.recordingTypeName, i.labelName AS labelName FROM CDList a LEFT JOIN label b ON a.labelA=b.labelNumber LEFT JOIN artist c ON a.artist=c.artistNumber LEFT JOIN package d ON d.packageNumber=a.package LEFT JOIN style e ON LEFT JOIN priceList f ON f.priceNumber=a.price LEFT JOIN country g ON LEFT JOIN recordingType h ON h.recordingTypeNumber=a.recordingType LEFT JOIN label i ON a.labelB=i.labelNumber WHERE a.barcode='093624847328'
Pat Metheny
[One Quiet Night] (2003-05-27)
WARNER / WARNER | JAZZ | USA | 1CD | 093624847328

최근입고 : 2007-12-28

주문수량 :
{ Track List }

1. One Quiet Night
2. Song For The Boys
3. Don't Know Why
4. Another Chance
5. And Time Goes On
6. My Song
7. Peace Memory
8. Ferry Cross The Mersey
9. Over On 4th Street
10. I Will Find The Way
11. North To South, East To West
12. Last Train Home