select id, redirect from sf_404 where url like 'buy/commercial/kerry/kenmare/the-purple-heather'Would redirect