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='042284291521'
Nick Drake
[Five Leaves Left [Remastered]] (2003-05-06)
UNIVERSAL / ISLAND | POP | EU | 1CD | 042284291521

최근입고 : 2012-07-05

주문수량 :
{ Track List }

1. Time Has Told Me
2. River Man
3. Three Hours
4. Day Is Done
5. Way To Blue
6. Cello Song
7. Thoughts Of Mary Jane
8. Man In A Shed
9. Fruit Tree
10. Saturday Sun