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='501001039'
Fresh Maggots
[Fresh Maggots (s1039)]
SIWAN / | ART ROCK | KOREA | 1CD | 501001039

최근입고 : 2003-10-29

주문수량 :
{ Track List }

1. Dole Song
2. Rosemary Hill
3. Ouickie
4. Everyone`s Gone To War
5. And When She Laughs
6. Spring
7. Balloon Song
8. Guzz Up
9. Who`s To Die
10. Elizabeth R
11. Frustration