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 = 'Shifter Accessories' ORDER BY m.Rank ASC,m.PartNumber ASC LIMIT 150,15

No Results Found. View All Products.