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='042283935327'
Cure
[Disintegration] (1992-08-13)
UNIVERSAL / FICTION | ROCK | EU | 1CD | 042283935327 | Delete

최근입고 : 2010-05-28

주문수량 :
{ Track List }

DISC 1
1. Plainsong
2. Closedown
3. Last Dance
4. Fascination Street
5. Same Deep Water As You
6. Homesick
7. Pictures Of You
8. Love Song
9. Lullaby
10. Prayers For Rain
11. Disintegration
12. Untitled
돌아가기