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='601215326925'
Soundtrack
[American Pie] (1999-06-29)
UNIVERSAL / UNIVERSAL | SOUNDTRACK | USA | 1CD | 601215326925

최근입고 : 2008-06-20

주문수량 :
{ Track List }

DISC 1
1. New Girl - Third Eye Blind
2. You Wanted More - Tonic
3. Mutt - Blink-182
4. Glory - Sugar Ray
5. Super Down - Super Transatlantic
6. Find Your Way Back Home - Dishwalla
7. Good Morning Baby - Bic Runga
8. Stranger By The Day - Shades Apart
9. Summertime - Bachelor Number One
10. Vintage Queen - Goldfinger
11. Sway - Bic Runga
12. Wishen - Loose Nuts
13. Man With The Hex - The Atomic Fireballs
{ Credits }
Average Rating: 5 stars out of 5
돌아가기