select id, redirect from sf_404 where url like 'buy/commercial/tipperary/borrisokane/main-street-borrisokane'Would redirect