It looks like some of my friendly url's are broken, and the links to those products give 404 errors. If I look at the url_rewrite table in MySQL I see what appear to be the correct request_path / target_path values. Example simplified query would look like:
select * from url_rewrite where entity_id = 2671 and store_id = 1;
And that shows 4 different url rewrites based on the category structure.
Is there any other table I can look at to see why it's not using the url rewrites in the table correctly, or is there an indexing table?
