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='042284292320'
Nick Drake
[Pink Moon] (2000-06-26)
UNIVERSAL / ISLAND | POP | EU | 1CD | 042284292320

최근입고 : 2012-03-05

주문수량 :
{ Track List }

1. Pink Moon
2. Place To Be
3. Road
4. Which Will
5. Horn
6. Things Behind The Sun
7. Know
8. Parasite
9. Ride
10. Harvest Breed
11. From The Morning