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 = 'Manual Shifters' AND SubCat1 = 'VW' ORDER BY m.Rank ASC,m.PartNumber ASC LIMIT 0,15