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='008811292126'
Sublime
[Millennium Collection - 20th Century Masters] (2002-10-29)
UNIVERSAL / MCA | ROCK | USA | 1CD | 008811292126 | Delete

최근입고 : 2006-02-24

주문수량 :
{ Track List }

DISC 1
1. Date Rape (nowell) - 3:40
2. Smoke Two Joints (kay/kay) - 2:56
3. Badfish (nowell) - 3:07
4. Greatest-hits (nowell) - 2:55
5. Saw Red (nowell) - 1:59
6. What I Got (gaugh/nowell/roberts/wilson) - 2:51
7. Santeria (gaugh/nowell/wilson) - 3:04
8. Wrong Way (gaugh/nowell/wilson) - 2:16
9. Doin' Time (gershwin/gershwin/goodman/heyward/heyward/nowell) - 4:13
10. April 29, 1992 [miami] (goodman/happoldt/nowell) - 3:53
돌아가기