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='720642462928'
[Weezer] (1995-01-19)
UNIVERSAL / GEFFEN | ROCK | USA | 1CD | 720642462928

최근입고 : 2012-08-08

주문수량 :
{ Track List }

1. My Name Is Jonas
2. No One Else
3. The World Has Turned And Left Me Here
4. Buddy Holly
5. Undone - The Sweater Song
6. Surf Wax America
7. Say It Ain't So
8. In The Garage
9. Holiday
10. Only In Dreams