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='606949304522'
Weezer
[Weezer [Green Album]] (2001-05-15)
UNIVERSAL / GEFFEN | ROCK | USA | 1CD | 606949304522

최근입고 : 2012-07-05

주문수량 :
{ Track List }

DISC 1
1. Don't Let Go (cuomo) - 2:59
2. Photograph (cuomo) - 2:19
3. Hash Pipe (cuomo) - 3:06
4. Island In The Sun (cuomo) - 3:20
5. Crab (cuomo) - 2:34
6. Knock-down Drag-out (cuomo) - 2:08
7. Smile (cuomo) - 2:38
8. Simple Pages (cuomo) - 2:56
9. Glorious Day (cuomo) - 2:40
10. O Girlfriend (cuomo) - 3:49
돌아가기