SELECT a.*, b.labelName AS publisherName, c.name, 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 e.styleNumber=a.style LEFT JOIN priceList f ON f.priceNumber=a.price LEFT JOIN country g ON g.countryNumber=a.country LEFT JOIN recordingType h ON h.recordingTypeNumber=a.recordingType LEFT JOIN label i ON a.labelB=i.labelNumber WHERE a.barcode='042286099422'
Jack Johnson
[Brushfire Fairytales] (2002-01-29)
UNIVERSAL / UNIVERSAL | POP | USA | 1CD | 042286099422 | Delete

최근입고 : 2010-09-24

주문수량 :
{ Track List }

DISC 1
1. Inaudible Melodies
2. Middle Man
3. Posters
4. Sexy Plexi
5. Flake
6. Bubble Toes
7. Fortunate Fool
8. The News
9. Drink The Water
10. Mudfootball
11. F-stop Blues
12. Losing Hope
13. It's All Understood
돌아가기