select id, redirect from sf_404 where url like 'buy/bungalow/clare/sixmilebridge/sooreeny-sixmilebridge'Would redirect