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='008811207328'
Three Dog Night
[Millennium Collection - 20th Century Masters] (2000-05-16)
UNIVERSAL / MCA | ROCK | USA | 1CD | 008811207328 | Delete

최근입고 : 2008-09-11

주문수량 :
{ Track List }

1. Joy To The World
2. Shambala
3. One
4. Black & White
5. Mama Told Me Not To Come
6. Old Fashioned Love Song, An
7. Never Been To Spain
8. Liar
9. Eli's Coming
10. Easy To Be Hard
11. Celebrate
12. Show Must Go On, The