well, i dont see any records where the featured local is = to Individual-Charm.
i see:
/Category/Individual-Charm
you could change the recordset so it uses Ends with:
SELECT * FROM featured LEFT OUTER JOIN products ON featured.FeaturedTypeID = products.ProductID WHERE FeaturedType = 1 AND FeaturedLocale LIKE '%Individual-Charm'