SELECT DISTINCT m.PartNumber FROM bmnew.mapping m INNER JOIN dpbrands.partslifecycle pl ON m.partNumber = pl.PartNumber and (pl.Status<>'8') WHERE m.PartNumber != '' AND MainCat = 'Apparel' AND SubCat1 = 'Calendar' ORDER BY m.Rank ASC,m.PartNumber ASC LIMIT 0,15
13-month calendar with photos and descriptions promoting Flowmaster, B&M, Hurst and Hurst Driveline Conversions products and marks major American holidays....more details
Part #: 660165
Price: $19.99
Qty: