Ok Rob,
I got it. Now I try to explain. You have these items:
(5, '/bprod/prod.cfm', 'http://{siteurl}/index.php?option=com_virtuemart&Itemid=53', 8, 5, 1, 0, '0000-00-00 00:00:00'),
...
(8, '/bprod/prod.cfm\\?prodid=1460', 'http://{siteurl}/index.php?page=shop.product_details&flypage=flypage.tpl&product_id=39&category_id=23&option=com_virtuemart&Itemid=53&lang=en', 0, 8, 1, 0, '0000-00-00 00:00:00'),
(9, '/bprod/prod.cfm\\?prodid=8910', 'http://{siteurl}/index.php?option=com_virtuemart&page=shop.product_details&flypage=flypage.tpl&category_id=25&product_id=119&Itemid=53&lang=en', 0, 9, 1, 0, '0000-00-00 00:00:00'),
...
So, ReDJ compare the current URL with matching items using regexp. If more that one matches, only the first one found is used (i.e. the lowest ID). In your case, for any URL like this:
www.yoursite.com/bprod/prod.cfm?prodid=8910
The first one that match is the item with ID=5, that redirect to:
http://{siteurl}/index.php?option=com_virtuemart&Itemid=53
One "poor" solution to the problem is to move this item as the last one, but a more elegant solution is to use power of "regular expressions"...
I mean, modify the "From URL" for item 5 as follow:
From URL: ^/bprod/prod.cfm$
It this case ONLY the URL
www.yoursite.com/bprod/prod.cfm matches. The caret (^) means "start with", and the dollar ($) means "end with".
More info here:
dev.mysql.com/doc/refman/5.1/en/regexp.html
Let me know if there are still problems.
Regards,
Luigi