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='504009915'
Art Rock Magazine
[1999 No.15]
SIWAN / | BOOK | KOREA | | 504009915

최근입고 : 2008-09-19

주문수량 :
{ Track List }
{ Comment }
* Fairport Convention
* Greek Music Special Part 1
* Symphonic Rock + Symphonic Rock Guide-60Albums
* Finnish Progressive Rock
* Canterbury Tales
* Chamber Rock Catalogue Part.2
* Korean Rock Sampler One Man Band
* Label Penner Record
* Ozric Tentacles
* After Crying
* Area
돌아가기